mzxt.pdb

某正在运行的大型医院源程序

/BEGIN_TABLE AMCHEAD
NAME A30
VERS A8
USER A30
/BEGIN_DATA AMCHEAD
PowerDesigner/PDM
6.0.0

/END_TABLE AMCHEAD

/BEGIN_TABLE AMCMODL
@       N5
OID     N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
EXOP    TXT
DBMS    A256
FILE    A256
HEAD    TXT
FOOT    TXT
POID    N8
PNAM    A80
PCOD    A80
USER    A80
VERS    A8
CDAT    N12
MDAT    N12
EDAT    N12
PART    N1
ACCS    N5
CUST    TXT
/BEGIN_DATA AMCMODL
3
46
46
门诊系统数据表结构
MZXT





Microsoft SQL Server 6.x
SQLSERV6.DEF


0
创业医院管理信息系统
BSHIS
BSHIS
2.2
922946882
1011066396
0
0
0

/END_TABLE AMCMODL

/BEGIN_TABLE AMCDOMN
@       N5
OID     N8
DOMN    N8
NAME    A80
CODE    A80
DESC    TXT
NOTE    TXT
LABL    A254
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
MAND    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
SRUL    TXT
SOID    N8
/BEGIN_DATA AMCDOMN
/END_TABLE AMCDOMN

/BEGIN_TABLE AMCTABL
@       N5
OID     N8
TABL    N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
NBRC    N8
SOID    N8
TOBJ    N5
COBJ    A80
OPTS    TXT
PKOP    TXT
CRUL    TXT
SRUL    TXT
PKCN    A30
CKCN    A30
HEAD    TXT
FOOT    TXT
NGEN    N1
/BEGIN_DATA AMCTABL
3
1
1
46
门诊病人档案
MS_BRDA



0
0
0
MS_BRDA








0
3
22
22
46
门诊病人帐户
MS_BRZH



0
0
0
MS_BRZH








0
3
34
34
46
帐户收支明细
MS_SZMX



0
0
0
MS_SZMX








0
3
46
46
46
挂号科室
MS_GHKS



0
0
0
MS_GHKS








0
3
57
57
46
挂号明细
MS_GHMX



0
0
0
MS_GHMX








0
3
80
80
46
退号明细
MS_THMX



0
0
0
MS_THMX








0
3
88
88
46
门诊员工票据
MS_YGPJ



0
0
0
MS_YGPJ








0
3
177
177
46
门诊医生排班
MS_YSPB



0
0
0
MS_YSPB








0
3
178
178
46
预约挂号
MS_YYGH



0
0
0
MS_YYGH








0
3
292
292
46
门诊收费信息
MS_MZXX



0
0
0
MS_MZXX








0
3
309
309
46
收费明细
MS_SFMX



0
0
0
MS_SFMX








0
3
317
317
46
作废发票
MS_ZFFP



0
0
0
MS_ZFFP








0
3
325
325
46
门诊处方01表
MS_CF01



0
0
0
MS_CF01








0
3
326
326
46
门诊处方02表
MS_CF02



0
0
0
MS_CF02








0
3
364
364
46
门诊医技单01表
MS_YJ01



0
0
0
MS_YJ01








0
3
383
383
46
门诊医技单02表
MS_YJ02



0
0
0
MS_YJ02








0
3
596
596
46
常用单位表
MS_CYDW



0
0
0
MS_CYDW








0
3
601
601
46
常用地址表
MS_CYDZ



0
0
0
MS_CYDZ








0
3
1415
1415
46
门诊收费日报
MS_HZRB



0
0
0
MS_HZRB








0
3
1425
1425
46
收费日报明细
MS_RBMX



0
0
0
MS_RBMX








0
3
2322
2322
46
门诊科室核算汇总表
MS_MZHS



0
0
0
MS_KSHS








0
3
2329
2329
46
门诊科室核算明细表
MS_MZMX



0
0
0
MS_HSMX








0
3
2612
2612
46
医技科室核算汇总表
MS_YJHS



0
0
0
MS_YJHS








0
3
2613
2613
46
医技科室核算明细表
MS_YJMX



0
0
0
MS_YJMX








0
3
3712
3712
46
发药屏幕显示
YF_PMSC



0
0
0
YF_PMXS








0
3
4022
4022
46
帐户类别
MS_ZHLB



0
0
0
MS_BRZT








0
3
4919
4919
46
日报性质明细
MS_XZMX



0
0
0
MS_XZMX








0
3
9766
9766
46
门诊类别
MS_MZLB



0
0
0
MS_MZLB








0
3
12270
12270
46
科室排班
MS_KSPB



0
0
0
MS_KSPB




PK_MS_KSPB



0
3
14587
14587
46
挂号明细历史
MS_GHMX_LS



0
0
0
MS_GHMX_LS




PK_MS_GHMX_LS



0
3
14630
14630
46
门诊收费信息历史
MS_MZXX_LS



0
0
0
MS_MZXX_LS




PK_MS_MZXX_LS



0
3
14663
14663
46
收费明细历史
MS_SFMX_LS



0
0
0
MS_SFMX_LS




PK_MS_SFMX_LS



0
3
14668
14668
46
门诊医技单01表历史
MS_YJ01_LS



0
0
0
MS_YJ01_LS




PK_MS_YJ01_LS



0
3
14697
14697
46
门诊医技单02表历史
MS_YJ02_LS



0
0
0
MS_YJ02_LS




PK_MS_YJ02_LS



0
3
14709
14709
46
门诊处方01表历史
MS_CF01_LS



0
0
0
MS_CF01_LS




PK_MS_CF01_LS



0
3
14749
14749
46
门诊处方02表历史
MS_CF02_LS



0
0
0
MS_CF02_LS




PK_MS_CF02_LS



0
/END_TABLE AMCTABL

/BEGIN_TABLE AMCCOLN
@       N5
OID     N8
COLN    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
DOMN    N8
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
SRUL    TXT
PRIM    N1
FORN    N1
MAND    N1
DISP    N1
SOID    N8
TOBJ    N5
COBJ    A80
CKCN    A30
NUMR    N8
/BEGIN_DATA AMCCOLN
3
2
2
病人ID号
ID



1
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
ID

1
3
3
3
门诊号码
MZHM



1
0
varchar(12)
12
0
0
0





0
0
0



0
0
1
1
0
0
MZHM

2
3
6
6
病人姓名
BRXM



1
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
BRXM

3
3
5
5
医疗证号
FYZH



1
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
FYZH

4
3
17
17
身份证号
SFZH



1
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
SFZH

5
3
4
4
病人性质
BRXZ



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
BRXZ

6
3
7
7
病人性别
BRXB



1
0
numeric(4)
4
0
0
0




1
0
0
0



0
0
0
1
0
0
BRXB

7
3
8
8
出生年月
CSNY



1
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
CSNY

8
3
9
9
婚姻状况
HYZK



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
HYZK

9
3
10
10
职业代码
ZYDM



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
ZYDM

10
3
11
11
名族代码
MZDM



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
MZDM

11
3
20
20
血型代码
XXDM



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
XXDM

12
3
21
21
过敏药物
GMYW



1
0
numeric(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
GMYW

13
3
10157
10157
单位序号
DWXH



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
DWXH

14
3
13
13
单位名称
DWMC



1
0
varchar(40)
40
0
0
0





0
0
0



0
0
0
1
0
0
DWMC

15
3
14
14
单位电话
DWDH



1
0
varchar(16)
16
0
0
0





0
0
0



0
0
0
1
0
0
DWDH

16
3
15
15
单位邮编
DWYB



1
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
DWYB

17
3
16
16
户口地址
HKDZ



1
0
varchar(40)
40
0
0
0





0
0
0



0
0
0
1
0
0
HKDZ

18
3
18
18
家庭电话
JTDH



1
0
varchar(16)
16
0
0
0





0
0
0



0
0
0
1
0
0
JTDH

19
3
19
19
户口邮编
HKYB



1
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
HKYB

20
3
3166
3166
就诊次数
JZCS



1
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
JZCS

21
3
3167
3167
就诊日期
JZRQ



1
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JZRQ

22
3
8383
8383
初诊日期
CZRQ



1
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
CZRQ

23
3
1409
1409
病人ID号
ID



22
0
numeric(18)
18
0
0
0





0
0
0



1
1
1
1
0
0
ID

1
3
4622
4622
帐户类别
ZHLB



22
0
numeric(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
ZHLB

2
3
27
27
银行编号
YHBH



22
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
YHBH

3
3
28
28
银行帐号
YHZH



22
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
GRZH

4
3
29
29
帐户密码
PASS



22
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
PASS

5
3
4019
4019
工资总额
GZZE



22
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
GZZE

6
3
30
30
帐户余额
ZHYE



22
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
ZHYE

7
3
31
31
累计费用
LJFY



22
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
LJFY

8
3
32
32
自负点金额
ZFDJE



22
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
BLJE

9
3
4020
4020
超额自付比例
CEZFBL



22
0
numeric(4,2)
4
2
0
0




0
0
0
0



0
0
1
1
0
0
CEZFBL

10
3
33
33
其他金额
QTJE



22
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
QTJE

11
3
4338
4338
作废判别
ZFPB



22
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
ZFPB

12
3
13353
13353
病人卡号
BRKH



22
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
BRKH

13
3
39
39
识别序号
SBXH



34
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
1832
1832
病人ID号
ID



34
0
numeric(18)
18
0
0
0





0
0
0



0
0
0
1
0
0
ID

2
3
40
40
日期
RQ



34
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
RQ

3
3
42
42
摘要
ZY



34
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
ZY

4
3
43
43
借方金额
JFJE



34
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
JFJE

5
3
45
45
贷方金额
DFJE



34
0
numeric(12,2)
12
2
0
0




0
0
0
0



0
0
1
1
0
0
DFJE

6
3
44
44
操作工号
CZGH



34
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

7
3
1413
1413
收支类别
SZLB



34
0
numeric(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
SZLB

8
3
1414
1414
凭证号码
PZHM



34
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
PZHM

9
3
55
55
结帐日期
JZRQ



34
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JZRQ

10
3
56
56
汇总日期
HZRQ



34
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
HZRQ

11
3
47
47
科室代码
KSDM



46
0
varchar(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
KSDM

1
3
48
48
科室名称
KSMC



46
0
varchar(40)
40
0
0
0





0
0
0



0
0
0
1
0
0
KSMC

2
3
49
49
挂号类别
GHLB



46
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
GHLB

3
3
50
50
拼音代码
PYDM



46
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
PYM

4
3
51
51
五笔代码
WBDM



46
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
WBM

5
3
362
362
角形代码
JXDM



46
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
JXDM

6
3
52
52
其他代码
QTDM



46
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
QTM

7
3
53
53
挂号费
GHF



46
0
numeric(8,2)
8
2
0
0




0
0
0
0



0
0
1
1
0
0
GHF

8
3
54
54
诊疗费
ZLF



46
0
numeric(8,2)
8
2
0
0




0
0
0
0



0
0
1
1
0
0
ZLF

9
3
3452
3452
专家门诊
ZJMZ



46
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
ZJMZ

10
3
289
289
挂号限额
GHXE



46
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
1
1
0
0
GHXE

11
3
290
290
已挂人数
YGRS



46
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
1
1
0
0
YGRS

12
3
10706
10706
预约人数
YYRS



46
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
1
1
0
0
YYRS

13
3
291
291
挂号日期
GHRQ



46
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
GHRQ

14
3
6352
6352
门诊科室
MZKS



46
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
MZKS

15
3
6671
6671
体检判别
TJPB



46
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
TJPB

16
3
6672
6672
体验费
TJF



46
0
numeric(8,2)
8
2
0
0




0
0
0
0



0
0
1
1
0
0
TJF

17
3
6673
6673
门诊类别
MZLB



46
0
numeric(2)
2
0
0
0




0
0
0
0



0
0
1
1
0
0
JZPB

18
3
12688
12688
就诊序号
JZXH



46
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
0
1
0
0
JZXH

19
3
58
58
识别序号
SBXH



57
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
60
60
病人ID号
ID



57
0
numeric(18)
18
0
0
0





0
0
0



0
1
0
1
0
0
ID

2
3
4936
4936
病人性质
BRXZ



57
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
BRXZ

3
3
63
63
挂号时间
GHSJ



57
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
GHSJ

4
3
594
594
挂号类别
GHLB



57
0
numeric(4)
4
0
0
0





0
0
0