kjxt.pdb

医院管理系统

0
0
0



1
0
1
1
0
0
SBXH

1
3
67
67
进修员工
JXYG



7
0
varchar(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
WCXM

2
3
68
68
性别
WCXB



7
0
char(1)
1
0
0
0





0
0
0
1	男\
2	女


0
0
0
1
0
0
WCXB

3
3
69
69
单位序号
DWXH



7
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
WCDW

4
3
70
70
专业序号
ZYXH



7
0
numeric(3)
3
0
0
0





0
0
0



0
0
0
1
0
0
WCZY

5
3
71
71
开始日期
KSRQ



7
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSRQ

6
3
72
72
结束日期
JSRQ



7
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JSRQ

7
3
103
103
拼音代码
PYDM



7
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

8
3
73
73
实习序号
SXXH



8
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
74
74
姓名
LSXM



8
0
varchar(10)
10
0
0
0





0
0
0



0
0
1
1
0
0
LSXM

2
3
75
75
性别
LSXB



8
0
char(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
LSXB

3
3
76
76
学校序号
XXXH



8
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
LSXX

4
3
77
77
专业序号
ZYXH



8
0
numeric(3)
3
0
0
0





0
0
0



0
0
0
1
0
0
LSZY

5
3
78
78
开始日期
KSRQ



8
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSRQ

6
3
79
79
结束日期
JSRQ



8
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JSRQ

7
3
80
80
押金
LSYJ



8
0
numeric(6,2)
6
2
0
0





0
0
0



0
0
0
1
0
0
LSYJ

8
3
81
81
备注
LSBZ



8
0
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
LSBZ

9
3
105
105
拼音代码
PYDM



8
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

10
3
82
82
培训序号
PXXH



9
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
83
83
住院医师
ZYYS



9
0
varchar(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
YSXM

2
3
84
84
课程分类
KCFL



9
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
KCFL

3
3
85
85
课程序号
KCXH



9
0
numeric(3)
3
0
0
0





0
0
0



0
0
0
1
0
0
PXZY

4
3
86
86
分数
PXFS



9
0
numeric(3,0)
3
0
0
0





0
0
0



0
0
0
1
0
0
PXFS

5
3
158
158
开始日期
KSRQ



9
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSRQ

6
3
159
159
结束日期
JSRQ



9
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JSRQ

7
3
106
106
拼音代码
PYDM



9
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

8
3
87
87
进修序号
JXXH



10
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
88
88
姓名
LJXM



10
0
varchar(10)
10
0
0
0





0
0
0



0
0
1
1
0
0
LJXM

2
3
89
89
性别
LJXB



10
0
char(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
LJXB

3
3
90
90
单位序号
DWXH



10
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
LJDW

4
3
91
91
专业序号
ZYXH



10
0
numeric(3)
3
0
0
0





0
0
0



0
0
0
1
0
0
LJZY

5
3
92
92
开始日期
KSRQ



10
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSRQ

6
3
93
93
结束日期
JSRQ



10
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JSRQ

7
3
94
94
押金
LJYJ



10
0
numeric(6,2)
6
2
0
0





0
0
0



0
0
0
1
0
0
LJYJ

8
3
95
95
备注
LJBZ



10
0
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
LJBZ

9
3
104
104
拼音代码
PYDM



10
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

10
3
96
96
临床教学序号
LJXH



11
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
SBXH

1
3
97
97
课程名称
KCMC



11
0
varchar(60)
60
0
0
0





0
0
0



0
0
1
1
0
0
KCMC

2
3
156
156
主讲人
ZHJR



11
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
ZJXH

3
3
98
98
地点
LCDD



11
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
LCDD

4
3
99
99
开始日期
KSRQ



11
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSRQ

5
3
100
100
结束日期
JSRQ



11
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
JSRQ

6
3
101
101
学分
LCXF



11
0
numeric(2,0)
2
0
0
0





0
0
0



0
0
0
1
0
0
LCXF

7
3
102
102
拼音代码
PYDM



11
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

8
3
163
163
来源序号
LYXH



160
0
numeric(3)
3
0
0
0





0
0
0



1
0
1
1
0
0
LYXH

1
3
164
164
来源名称
LYMC



160
0
varchar(40)
40
0
0
0





0
0
0



0
0
1
1
0
0
LYMC

2
3
278
278
拼音代码
PYDM



160
0
varchar(8)
8
0
0
0





0
0
0



0
0
1
1
0
0
PYDM

3
3
165
165
专业序号
ZYXH



161
0
numeric(3)
3
0
0
0





0
0
0



1
0
1
1
0
0
ZYXH

1
3
166
166
专业名称
ZYMC



161
0
varchar(50)
50
0
0
0





0
0
0



0
0
1
1
0
0
ZYMC

2
3
280
280
专业分类
ZYFL



161
0
numeric(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
ZYFL

3
3
279
279
拼音代码
PYDM



161
0
varchar(8)
8
0
0
0





0
0
0



0
0
1
1
0
0
PYDM

4
3
168
168
科室代码
KSDM



162
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
KSDM

1
3
271
271
科室名称
KSMC



162
0
varchar(30)
30
0
0
0





0
0
0



0
0
1
1
0
0
KSMC

2
3
169
169
负责人
KSFZ



162
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
KSFZ

3
3
170
170
联系电话
LXDH



162
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
LXDH

4
3
171
171
科室性质
KSXZ



162
0
numeric(1)
1
0
0
0





0
0
0



0
0
1
1
0
0
KSXZ

5
3
276
276
拼音代码
PYDM



162
0
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
PYDM

6
3
291
291
课程序号
KCXH



290
0
numeric(3)
3
0
0
0





0
0
0



1
0
1
1
0
0
KCXH

1
3
292
292
课程名称
KCMC



290
0
varchar(30)
30
0
0
0





0
0
0



0
0
1
1
0
0
KCMC

2
3
293
293
课程分类
KCFL



290
0
numeric(1)
1
0
0
0





0
0
0



0
0
1
1
0
0
KCFL

3
3
294
294
拼音代码
PYDM



290
0
varchar(8)
8
0
0
0





0
0
0



0
0
1
1
0
0
PYDM

4
/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
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N8
CCOL    N8
COLN1   N8
COLN2   N8
/BEGIN_DATA AMCCCOL
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N8
CREF    N8
REFR    N8
CCOL    N8
NUMR    N8
/BEGIN_DATA AMCCREF
/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
/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N8
CIDX    N8
INDX    N8
COLN    N8
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
/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