ssmz.pdb

医院管理系统

1047
0
text
0
0
0
0





0
0
0



0
0
0
1
0
0
THNR

3
0
0
0
0
0
0
3
4772
4772
类别
LB



1047
0
numeric(2)
2
0
0
0





0
0
0



1
0
1
1
0
0
LB

4
0
0
0
0
0
0
3
3450
3450
费用编号
FYBH



1450
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
FYBH

1
0
0
0
0
0
0
3
1451
1451
手术编号
SSBH



1450
0
numeric(10)
10
0
0
0





0
0
0



0
1
0
1
0
0
TZDH

2
0
0
0
0
0
0
3
1453
1453
住院号
ZYH



1450
0
numeric(9)
9
0
0
0





0
0
0



0
0
0
1
0
0
ZYH

3
0
0
0
0
0
0
3
4529
4529
费用名称
FYMC



1450
0
varchar(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
FYMC

4
0
0
0
0
0
0
3
1474
1474
费用类型
FYLX



1450
0
numeric(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
YPLX

5
0
0
0
0
0
0
3
1454
1454
费用序号
FYXH



1450
0
numeric(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
FYXH

6
0
0
0
0
0
0
3
2536
2536
费用项目
FYXM



1450
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FYXM

7
0
0
0
0
0
0
3
2379
2379
药品产地
YPCD



1450
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
YPCD

8
0
0
0
0
0
0
3
1455
1455
费用数量
FYSL



1450
0
numeric(10,2)
10
2
0
0




0
0
0
0



0
0
0
1
0
0
FYSL

9
0
0
0
0
0
0
3
1456
1456
费用单价
FYDJ



1450
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
0
1
0
0
FYDJ

10
0
0
0
0
0
0
3
1457
1457
自负比例
ZFBL



1450
0
numeric(3,2)
3
2
0
0





0
0
0



0
0
0
1
0
0
ZFBL

11
0
0
0
0
0
0
3
2381
2381
记费日期
JFRQ



1450
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JFRQ

12
0
0
0
0
0
0
3
2382
2382
记帐日期
JZRQ



1450
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JZRQ

13
0
0
0
0
0
0
3
2380
2380
费用科室
FYKS



1450
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FYKS

14
0
0
0
0
0
0
3
4470
4470
费用病区
FYBQ



1450
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FYBQ

15
0
0
0
0
0
0
3
2383
2383
执行科室
ZXKS



1450
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
ZXKS

16
0
0
0
0
0
0
3
2386
2386
医生工号
YSGH



1450
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
YSGH

17
0
0
0
0
0
0
3
2384
2384
记费工号
JFGH



1450
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
JFGH

18
0
0
0
0
0
0
3
2385
2385
记帐工号
JZGH



1450
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
JZGH

19
0
0
0
0
0
0
3
2315
2315
记帐标志
JZBZ



1450
0
numeric(1)
1
0
0
0




0
0
0
0
1	已记到收费处\
0	还没有记到收费自


0
0
0
1
0
0
JZBZ

20
0
0
0
0
0
0
3
4530
4530
总计金额
ZJJE



1450
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
0
1
0
0
ZJJE

21
0
0
0
0
0
0
3
4531
4531
自费金额
ZFJE



1450
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
0
1
0
0
ZFJE

22
0
0
0
0
0
0
3
6838
6838
入库标志
RKBZ



1450
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
0
1
0
0
RKBZ

23
0
0
0
0
0
0
3
1476
1476
手术编号
SSBH



1475
0
numeric(10)
10
0
0
0





0
0
0



1
1
1
1
0
0
SSBH

1
0
0
0
0
0
0
3
1477
1477
手术内码
SSNM



1475
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
SSNM

2
0
0
0
0
0
0
3
2258
2258
备注说明
BZSM



1475
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
BZSM

3
0
0
0
0
0
0
3
5000
5000
手术编号
SSBH



4999
0
numeric(10)
10
0
0
0





0
0
0



1
1
1
1
0
0
SSBH

1
0
0
0
0
0
0
3
5319
5319
住院号
ZYH



4999
0
numeric(9)
9
0
0
0





0
0
0



0
0
0
1
0
0
ZYH

2
0
0
0
0
0
0
3
5001
5001
麻醉师随访标志
MZSFBZ



4999
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
MZHFBZ

3
0
0
0
0
0
0
3
5002
5002
麻醉师随访信息
MZSFXX



4999
0
text
0
0
0
0





0
0
0



0
0
0
1
0
0
MZHFXX

4
0
0
0
0
0
0
3
5003
5003
护士随访标志
HSSFBZ



4999
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
HSHFBZ

5
0
0
0
0
0
0
3
5004
5004
护士随访信息
HSSFXX



4999
0
text
0
0
0
0





0
0
0



0
0
0
1
0
0
HSHFXX

6
0
0
0
0
0
0
3
5005
5005
术后感柒
SSGR



4999
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
SSGR

7
0
0
0
0
0
0
3
5006
5006
病人满意
BRMY



4999
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
BRMY

8
0
0
0
0
0
0
3
5007
5007
术后并发症
SSBFZ



4999
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
SSBFZ

9
0
0
0
0
0
0
3
5008
5008
愈合情况
YHLB



4999
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
YHLB

10
0
0
0
0
0
0
3
5956
5956
操作工号
CZGH



4999
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

11
0
0
0
0
0
0
3
5429
5429
编号
ID



5426
0
numeric(2)
2
0
0
0





0
0
0
1	申请单号\
2	手术编号


1
0
1
1
0
0
ID

1
0
0
0
0
0
0
3
5427
5427
单据号
CODE



5426
0
numeric(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
SQDH

2
0
0
0
0
0
0
1
6252
6252
包裹编号
BGBH



6251
0
varchar(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
BGBH

1
0
0
0
0
0
0
1
6253
6253
包裹名称
BGMC



6251
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
BGMC

2
0
0
0
0
0
0
1
6254
6254
器械编号
QXBH



6251
0
varchar(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
QXBH

3
0
0
0
0
0
0
1
6255
6255
器械数量
QXSL



6251
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
QXSL

4
0
0
0
0
0
0
/END_TABLE AMCCOLN

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

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

/BEGIN_TABLE AMCREFR
@       N5
OID     N10
REFR    N10
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL1   N10
TABL2   N10
KOBJ    N10
URUL    N1
DRUL    N1
MAND    N1
CPRT    N1
SOID    N10
TOBJ    N5
COBJ    A80
FKCN    A30
CMIN    A10
CMAX    A10
NGEN    N1
CMMT    N1
ROPR    N1
/BEGIN_DATA AMCREFR
3
3186
3186
SSAP_SQDH
SSAP_SQDH



278
98
278
1
1
0
1
0
0
SSAP_SQDH

0
n
0
0
0
3
3189
3189
HZJL_SSBH
HZJL_SSBH



98
244
98
1
1
1
1
0
0
HZJL_SSBH

0
n
0
0
0
3
3192
3192
THJL_SSBH
THJL_SSBH



98
245
98
1
1
1
1
0
0
THJL_SSBH

0
n
0
0
0
3
3195
3195
MZJL_SSBH
MZJL_SSBH



98
232
98
1
1
1
1
0
0
MZJL_SSBH

0
n
0
0
0
3
3202
3202
SSFY_SSBH
SSFY_SSBH



98
1450
98
1
1
0
1
0
0
SSFY_SSBH

0
n
0
0
0
3
3205
3205
SSJL_SSBH
SSJL_SSBH



98
99
98
1
1
1
1
0
0
SSJL_SSBH

0
n
0
0
0
3
3215
3215
QXQD_SSBH
QXQD_SSBH



99
841
99
1
1
1
1
0
0
QXQD_SSBH

0
n
0
0
0
3
3218
3218
QXQD_QXBH
QXQD_QXBH



840
841
840
1
1
1
1
0
0
QXQD_QXBH

0
n
0
0
0
3
3221
3221
QXZB_QXBH
QXZB_QXBH



840
842
840
1
1
1
1
0
0
QXZB_QXBH

0
n
0
0
0
3
3235
3235
FJSS_SSBH
FJSS_SSBH



99
1475
99
1
1
1
1
0
0
FJSS_SSBH

0
n
0
0
0
3
3238
3238
QXZB_SSBH
QXZB_SSBH



98
842
98
1
1
1
1
0
0
QXZB_SSBH

0
n
0
0
0
3
5009
5009
Ref_5009
Ref_5009



98
4999
98
1
1
1
1
0
0
Ref_5009

0
n
0
0
0
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N10
CCOL    N10
COLN1   N10
COLN2   N10
/BEGIN_DATA AMCCCOL
1
3187
3187
279
3183
1
3190
3190
100
246
1
3193
3193
100
254
1
3196
3196
100
233
1
3203
3203
100
1451
1
3206
3206
100
168
1
3216
3216
168
845
1
3219
3219
843
846
1
3222
3222
843
849
1
3236
3236
168
1476
1
3239
3239
100
848
1
5010
5010
100
5000
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N10
CREF    N10
REFR    N10
CCOL    N10
NUMR    N8
/BEGIN_DATA AMCCREF
3
3188
3188
3186
3187
1
3
3191
3191
3189
3190
1
3
3194
3194
3192
3193
1
3
3197
3197
3195
3196
1
3
3204
3204
3202
3203
1
3
3207
3207
3205
3206
1
3
3217
3217
3215
3216
1
3
3220
3220
3218
3219
1
3
3223
3223
3221
3222
1
3
3237
3237
3235
3236
1
3
3240
3240
3238
3239
1
3
5011
5011
5009
5010
1
/END_TABLE AMCCREF

/BEGIN_TABLE AMCINDX
@       N5
OID     N10
INDX    N10
NAME    A80
CODE    A80
TABL    N10
LABL    A254
DESC    TXT
NOTE    TXT
PRIM    N1
FORN    N1
ISAK    N1
KOBJ    N10
UNIQ    N1
CLUS    N1
OPTS    TXT
COBJ    A80
NUMR    N8
TYPE    A40
ROPR    N1
/BEGIN_DATA AMCINDX
3
4960
4960
SM_SZWJ_JCRQ
SM_SZWJ_JCRQ
20



0
0
0
0
0
0


1

0
3
4964
4964
SM_KQWJ_JCRQ
SM_KQWJ_JCRQ
21



0
0
0
0
0
0


2

0
3
5758
5758
SM_ZWXD_XDRQ
SM_ZWXD_XDRQ
22



0
0
0
0
0
0


3

0
3
4962
4962
SM_WPWJ_JCRQ
SM_WPWJ_JCRQ
27



0
0
0
0
0
0


4

0
3
5760
5760
SM_SSWJ_JCRQ
SM_SSWJ_JCRQ
45



0
0
0
0
0
0


5

0
3
4929
4929
SM_SSAP_APRQ
SM_SSAP_APRQ
98



0
0
0
0
0
0


6

0
3
4931
4931
SM_SSAP_ZYH
SM_SSAP_ZYH
98



0
0
0
0
0
0


7

0
3
4933
4933
SM_SSAP_WCBZ
SM_SSAP_WCBZ
98



0
0
0
0
0
0


8

0
3
4951
4951
SM_SSJL_ZYH
SM_SSJL_ZYH
99



0
0
0
0
0
0


9

0
3
4937
4937
SM_MZJL_MZRQ
SM_MZJL_MZRQ
232



0
0
0
0
0
0


10

0
3
4939
4939
SM_MZJL_ZYH
SM_MZJL_ZYH
232



0
0
0
0
0
0


11

0
3
5751
5751
SM_HZJL_HZRQ
SM_HZJL_HZRQ
244



0
0
0
0
0
0


12

0
3
5753
5753
SM_HZJL_ZYH
SM_HZJL_ZYH
244



0
0
0
0
0
0


13

0
3
4923
4923
SM_THJL_THRQ
SM_THJL_THRQ
245



0
0
0
0
0
0


14

0
3
4925
4925
SM_THJL_ZYH
SM_THJL_ZYH
245



0
0
0
0
0
0


15

0
3
4919
4919
SM_SSSQ_SQRQ
SM_SSSQ_SQRQ
278



0
0
0
0
0
0


16

0
3
5749
5749
SM_SSSQ_ZYH
SM_SSSQ_ZYH
278



0
0
0
0
0
0


17

0
3
4943
4943
SM_QXQD_QXBH
SM_QXQD_QXBH
841



0
0
0
0
0
0


18

0
3
4958
4958
SM_COPY_LB
SM_COPY_LB
1047



0
0
0
0
0
0


19

0
3
4913
4913
SM_SSFY_SSBH
SM_SSFY_SSBH
1450



0
0
0
0
0
0


20

0
3
4915
4915
SM_SSFY_ZYH
SM_SSFY_ZYH
1450



0
0
0
0
0
0


21

0
3
5755
5755
SM_SHXX_ZYH
SM_SHXX_ZYH
4999



0
0
0
0
0
0


22

0
/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N10
CIDX    N10
INDX    N10
COLN    N10
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
3
4961
4961
4960
23
1