sgxt.pdb

医院管理系统

0
0
0



0
0
1
1
0
0
KSDM

5
3
140
140
物品序号
WPXH



132
0
numeric(10)
10
0
0
0





0
0
0



0
0
1
1
0
0
WPXH

6
3
147
147
拼音代码
PYDM



132
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
JGBZ

7
3
160
160
备注
MEMO



132
0
varchar(250)
250
0
0
0





0
0
0



0
0
0
1
0
0
MEMO

8
3
165
165
包裹ID号
BGID



133
0
numeric(6)
6
0
0
0





0
0
0



1
1
1
1
0
0
BGID

1
3
150
150
物品序号
WPXH



133
0
numeric(10)
10
0
0
0





0
0
0



1
0
1
1
0
0
WPXH

2
3
152
152
物品数量
WPSL



133
0
numeric(10,2)
10
2
0
0




0
0
0
0



0
0
1
1
0
0
WPSL

3
3
170
170
科室代码
KSDM



169
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
KSDM

1
3
184
184
使用科室
SYKS



169
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
SYKS

2
3
171
171
物品序号
WPXH



169
0
numeric(10)
10
0
0
0





0
0
0



1
0
1
1
0
0
WPXH

3
3
172
172
物品产地
WPCD



169
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
WPCD

4
3
173
173
物品数量
WPSL



169
0
numeric(10,2)
10
2
0
0





0
0
0



0
0
1
1
0
0
WPSL

5
3
174
174
物品单价
WPDJ



169
0
numeric(12,4)
12
4
0
0





0
0
0



0
0
1
1
0
0
WPDJ

6
3
175
175
启用日期
QYRQ



169
0
datetime
0
0
0
0





0
0
0



0
0
1
1
0
0
QYRQ

7
3
177
177
记录ID号
JLID



176
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
JLID

1
3
178
178
科室代码
KSDM



176
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
KSDM

2
3
186
186
使用科室
SYKS



176
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
SYKS

3
3
180
180
使用日期
SYRQ



176
0
datetime
0
0
0
0





0
0
0



0
0
1
1
0
0
SYRQ

4
3
179
179
物品序号
WPXH



176
0
numeric(10)
10
0
0
0





0
0
0



0
0
1
1
0
0
WPXH

5
3
181
181
物品产地
WPCD



176
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
WPCD

6
3
182
182
物品数量
WPSL



176
0
numeric(10,2)
10
2
0
0





0
0
0



0
0
1
1
0
0
WPSL

7
3
185
185
物品单价
WPDJ



176
0
numeric(12,4)
12
4
0
0





0
0
0



0
0
1
1
0
0
WPDJ

8
3
183
183
库存数量
KCSL
物品入库


176
0
numeric(10,2)
10
2
0
0





0
0
0



0
0
1
1
0
0
KCSL

9
/END_TABLE AMCCOLN

/BEGIN_TABLE AMCREFR
@       N5
OID     N8
REFR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL1   N8
TABL2   N8
URUL    N1
DRUL    N1
MAND    N1
CPRT    N1
SOID    N8
TOBJ    N5
COBJ    A80
FKCN    A30
CMIN    A10
CMAX    A10
NGEN    N1
/BEGIN_DATA AMCREFR
3
8
8
Ref_8
Ref_8



1
5
1
1
1
1
0
0
Ref_8

0
n
0
3
78
78
Ref_78
Ref_78



69
70
1
1
1
1
0
0
Ref_78

0
n
0
3
128
128
Ref_128
Ref_128



83
112
1
1
1
1
0
0
Ref_128

0
n
0
3
164
164
Ref_164
Ref_164



132
133
1
1
1
1
0
0
Ref_164

0
n
0
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N8
CCOL    N8
COLN1   N8
COLN2   N8
/BEGIN_DATA AMCCCOL
1
9
9
2
7
1
80
80
71
79
1
129
129
85
113
1
166
166
158
165
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N8
CREF    N8
REFR    N8
CCOL    N8
NUMR    N8
/BEGIN_DATA AMCCREF
3
10
10
8
9
1
3
81
81
78
80
1
3
130
130
128
129
1
3
167
167
164
166
1
/END_TABLE AMCCREF

/BEGIN_TABLE AMCINDX
@       N5
OID     N8
INDX    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
PRIM    N1
FORN    N1
UNIQ    N1
CLUS    N1
OPTS    TXT
COBJ    A80
NUMR    N8
TYPE    A40
/BEGIN_DATA AMCINDX
3
161
161
IDX_SG_WPBG_KSDM_WPXH
IDX_SG_WPBG_KSDM_WPXH
132



0
0
1
0


1

/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N8
CIDX    N8
INDX    N8
COLN    N8
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
3
162
162
161
136
1
1
3
163
163
161
140
1
2
/END_TABLE AMCCIDX

/BEGIN_TABLE AMCAKEY
@       N5
OID     N8
AKEY    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
AKCN    A30
NUMR    N8
/BEGIN_DATA AMCAKEY
/END_TABLE AMCAKEY

/BEGIN_TABLE AMCCKEY
@       N5
OID     N8
CKEY    N8
AKEY    N8
COLN    N8
NUMR    N8
/BEGIN_DATA AMCCKEY
/END_TABLE AMCCKEY

/BEGIN_TABLE AMCTRGR
@       N5
TEMP    A30
TEXT    TXT
NAME    A30
TABL    N8
ALWS    N1
/BEGIN_DATA AMCTRGR
/END_TABLE AMCTRGR

/BEGIN_TABLE AMCPROC
@       N5
OID     N8
PROC    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TEXT    TXT
FUNC    N1
/BEGIN_DATA AMCPROC
/END_TABLE AMCPROC

/BEGIN_TABLE AMCVIEW
@       N5
OID     N8
VIEW    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
CUST    N1
LOBJ    TXT
QURY    TXT
UPDT    N1
GENE    N1
CHCK    N1
/BEGIN_DATA AMCVIEW
/END_TABLE AMCVIEW

/BEGIN_TABLE AMCRULE
@       N5
OID     N8
RULE    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TYPE    N5
FLAG    N5
CEXP    TXT
SEXP    TXT
LOBJ    TXT
SOID    N8
COBJ    A80
/BEGIN_DATA AMCRULE
/END_TABLE AMCRULE

/BEGIN_TABLE AMCTSPC
@       N5
OID     N8
TSPC    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
/BEGIN_DATA AMCTSPC
/END_TABLE AMCTSPC

/BEGIN_TABLE AMCSTOR
@       N5
OID     N8
STOR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
/BEGIN_DATA AMCSTOR
/END_TABLE AMCSTOR

/BEGIN_TABLE AMCLTBL
@       N5
OID     N8
LTBL    N8
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
HEAD    TXT
FOOT    TXT
GENE    N1
TABL    N8
/BEGIN_DATA AMCLTBL
/END_TABLE AMCLTBL

/BEGIN_TABLE AMCLCOL
@       N5
OID     N8
LCOL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
LTBL    N8
COLN    N8
DTTP    A30
MLEN    N8
PREC    N2
MAND    N1
UNIQ    N1
DISP    N1
IQIX    N4
OPTFP   TXT
OPTLF   TXT
OPTLD   TXT
OPTHG   TXT
OPTHNG  TXT
NUMR    N8
/BEGIN_DATA AMCLCOL
/END_TABLE AMCLCOL

/BEGIN_TABLE AMCJREL
@       N5
OID     N8
JREL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
LTBL1   N8
LTBL2   N8
MANY    N1
/BEGIN_DATA AMCJREL
/END_TABLE AMCJREL

/BEGIN_TABLE AMCJIDX
@       N5
OID     N8
JIDX    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
HEAD    TXT
FOOT    TXT
LTBL    N8
LOBJ    TXT
/BEGIN_DATA AMCJIDX
/END_TABLE AMCJIDX

/BEGIN_TABLE AMCJCCL
@       N5
OID     N8
JCCL    N8
LCOL1   N8
LCOL2   N8
/BEGIN_DATA AMCJCCL
/END_TABLE AMCJCCL

/BEGIN_TABLE AMCJCRL
@       N5
OID     N8
JCRL    N8
JREL    N8
JCCL    N8
NUMR    N8
/BEGIN_DATA AMCJCRL
/END_TABLE AMCJCRL

/BEGIN_TABLE AMCFACT
@       N5
OID     N8
FACT    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
/BEGIN_DATA AMCFACT
/END_TABLE AMCFACT

/BEGIN_TABLE AMCDIM
@       N5
OID     N8
DIM     N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
/BEGIN_DATA AMCDIM
/END_TABLE AMCDIM

/BEGIN_TABLE AMCHFCT
@       N5
OID     N8
HFCT    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
/BEGIN_DATA AMCHFCT
/END_TABLE AMCHFCT

/BEGIN_TABLE AMCHDIM
@       N5
OID     N8
HDIM    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
/BEGIN_DATA AMCHDIM
/END_TABLE AMCHDIM

/BEGIN_TABLE AMCMETR
@       N5
OID     N8
METR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TTYP    N8
COLN    N8
/BEGIN_DATA AMCMETR
/END_TABLE AMCMETR

/BEGIN_TABLE AMCATTR
@       N5
OID     N8
ATTR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TTYP    N8
COLN    N8
/BEGIN_DATA AMCATTR
/END_TABLE AMCATTR

/BEGIN_TABLE AMCNODE
@       N5
OID     N8
NODE    N8
PNODE   N8
TYPE    N8
NUMR    N8
/BEGIN_DATA AMCNODE
/END_TABLE AMCNODE

/BEGIN_TABLE AMCDTBS
@       N5
OID     N8
DTBS    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
DEFF    A256
DTSC    A80
SRVN    A30
LOGN    A128
PASS    A256
/BEGIN_DATA AMCDTBS
/END_TABLE AMCDTBS

/BEGIN_TABLE AMCETBL
@       N5
OID     N8
ETBL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
DTBS    N8
/BEGIN_DATA AMCETBL
/END_TABLE AMCETBL

/BEGIN_TABLE AMCECOL
@       N5
OID     N8
ECOL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
ETBL    N8
DTTP    A30
MLEN    N8
PREC    N2
DISP    N1
NUMR    N8
/BEGIN_DATA AMCECOL
/END_TABLE AMCECOL

/BEGIN_TABLE AMCTSRC
@       N5
OID     N8
TSRC    N8
TABL    N8
DTBS    N8
SCRPT   TXT
INVLD   N1
LOBJ    TXT
/BEGIN_DATA AMCTSRC
/END_TABLE AMCTSRC

/BEGIN_TABLE AMCCSRC
@       N5
OID     N8
CSRC    N8
COLN    N8
TSRC    N8
ALIAS   A80
EXPR    TXT
INVLD   N1
LOBJ    TXT
/BEGIN_DATA AMCCSRC
/END_TABLE AMCCSRC

/BEGIN_TABLE AMCRPRT
@       N5
OID     N8
RPRT    N8
FLGS    N8
NAME    A64
DESC    A254
TMLT    BIN
/BEGIN_DATA AMCRPRT
/END_TABLE AMCRPRT

/BEGIN_TABLE AMCSLCT
RPRT    N8
MODL    N8
LOBJ    TXT
/BEGIN_DATA AMCSLCT
/END_TABLE AMCSLCT

/BEGIN_TABLE AMCCNST
@       N5
CNST    N8
MODL    N8
NAME    A30
TYPE    A20
VALE    A254
RSRV    N1
/BEGIN_DATA AMCCNST
/END_TABLE AMCCNST

/BEGIN_TABLE AMCEXAT
@       N5
EXAT    N8
MODL    N8
NAME    A30
TYPE    A20
LABL    A254
VALE    A254
TOBJ    N5
RSRV    N1
/BEGIN_DATA AMCEXAT
/END_TABLE AMCEXAT

/BEGIN_TABLE AMCEXAV
@       N5
EXAV    N8
MODL    N8
EXAT    N8
VALE    A254
OBJT    N8
/BEGIN_DATA AMCEXAV
/END_TABLE AMCEXAV

/BEGIN_TABLE PBEDTS
@       N5
EDTN    N8
NAME    A30
EDIT    A254
TYPE    N5
CNTR    N8
SEQN    N5
FLAG    N12
RSVD    A32
/BEGIN_DATA PBEDTS
/END_TABLE PBEDTS

/BEGIN_TABLE PBFRMT
@       N5
FMTN    N8
NAME    A30
FRMT    A254
TYPE    N5
CNTR    N8
GENE    N8
/BEGIN_DATA PBFRMT
/END_TABLE PBFRMT

/BEGIN_TABLE PBVALD
@       N5
VLDN    N8
NAME    A30
VALD    A254
TYPE    N5
CNTR    N8
VMSG    A254
GENE    N8
/BEGIN_DATA PBVALD
/END_TABLE PBVALD

/BEGIN_TABLE AMCFONT
FONT    N5
FNAM    A32
FSIZ    N5
FSTY    N5
/BEGIN_DATA AMCFONT
1
Arial
8
0
2
MS Sans Serif
8
0
3
Arial
8
8
4
Arial
6
0
5
宋体
9
1
/END_TABLE AMCFONT

/BEGIN_TABLE AMCPENS
PENS    N5
PSTY    N5
PCLR    N8
PWID    N5
/BEGIN_DATA AMCPENS
1
1
0
0
2
1
255
0
3
3
255
0
4
1
128
0
5
1
65280
0
6
5
255
0
7
1
65535
0
8
4
255
0
9
3
0
0
10
1
160
0
11
1
65408
0
12
1
16776960
0
13
1
0
1
14
1
16711680
0
15
1
4194368
0
16
1
8421504
0
17
3
16744576
0
18
2
255
0
19
1
16744576
0
20
2
0
0
21
2
16744576
0
22
1
8454143
0
23
2
8454143
0
24
4
8454143
0
25
4
0
0
26
4
16744576
0
27
5
16744576
0
28
5
16776960
0
29
5
0
0
30
1
12632256
0
31
1
16777088
0
32
1
32768
0
33
1
64
0
34
5
16777088
0
35
3
16777088
0
36
2
128
0
37
2
16711680
0
38
1
16744448
0
39
2
65408
0
40
1
16711935
0
41
2
16711935
0
42
1
16744703
0
43
1
16711808
0
44
1
4227200
0
45
3
16776960
0
46
2
16776960
0
47
1
8388863
0
48
1
8404992
0
49
1
4194432
0
50
1
8388608
0
51
1
16777215
0
52
1
10799344
0
53
3
16711680
0
54
1
8453888
0
55
7
255
0
56
1
8405056
0
57
1
8388672
0
58
2
32768
0
59
1
16777192
0
60
1
65344
0
61
5
8421504
0
62
4
8421504
0
63
3
160
0
64
1
16744640
0
65
5
16744640
0
66
2
16777088
0
67
5
12632256
0
68
1
8421440
0
69
1
8388736
0
70
1
16512
0
71
1
8421631
0
72
1
33023
0
73
4
8421631
0
74
4
16777215
0
75
4
65535
0
76
4
160
0
77
1