bqxt.pdb

医院管理系统

0
0
0
1
0
0
YZMC

3
3
2029
2029
药品序号
YPXH



2025
0
numeric(6)
6
0
0
0





0
0
0



0
0
1
1
0
0
YPXH

4
3
2030
2030
项目类型
XMLX
1.普通用药 2.急诊用药 3.出院带药 4.检查 5.检验 6.手术 7.治疗 8.护理  9.饮食 10.其他


2025
0
numeric(2)
2
0
0
0





0
0
0



0
0
1
1
0
0
XMLX

5
3
2031
2031
药品类型
YPLX



2025
0
numeric(1)
1
0
0
0





0
0
0



0
0
1
1
0
0
YPLX

6
3
2032
2032
每日次数
MRCS



2025
0
numeric(2)
2
0
0
0




1
0
0
0



0
0
1
1
0
0
MRCS

7
3
2033
2033
一次剂量
YCJL



2025
0
numeric(10,2)
10
2
0
0




0
0
0
0



0
0
1
1
0
0
YCJL

8
3
2034
2034
一次数量
YCSL



2025
0
numeric(8,2)
8
2
0
0




0
0
0
0



0
0
1
1
0
0
YCSL

9
3
2035
2035
每周次数
MZCS



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
MZCS

10
3
2036
2036
开始时间
KSSJ



2025
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
KSSJ

11
3
2037
2037
确认时间
QRSJ



2025
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
QRSJ

12
3
2038
2038
停止时间
TZSJ



2025
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
TZSJ

13
3
2039
2039
药品单价
YPDJ



2025
0
numeric(10,4)
10
4
0
0




0
0
0
0



0
0
1
1
0
0
YPDJ

14
3
2040
2040
药品用法
YPYF



2025
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
1
1
0
0
YPYF

15
3
2041
2041
开嘱医生
YSGH



2025
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
YSGH

16
3
2042
2042
停嘱医生
TZYS



2025
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
TZYS

17
3
2043
2043
操作工号
CZGH



2025
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

18
3
2044
2044
复核工号
FHGH



2025
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FHGH

19
3
2045
2045
使用标志
SYBZ



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
SYBZ

20
3
2046
2046
输入科室
SRKS



2025
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
SRKS

21
3
2047
2047
自负判别
ZFPB



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
ZFPB

22
3
2048
2048
医技主项
YJZX



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
YJZX

23
3
2049
2049
医技序号
YJXH



2025
0
numeric(18)
18
0
0
0




0
0
0
0



0
0
1
1
0
0
YJXH

24
3
2050
2050
特检号码
TJHM



2025
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
TJHM

25
3
2051
2051
执行科室
ZXKS



2025
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
ZXKS

26
3
2052
2052
安排日期
APRQ



2025
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
APRQ

27
3
2053
2053
医嘱组号
YZZH



2025
0
numeric(18)
18
0
0
0





0
0
0



0
0
1
1
0
0
YZZH

28
3
2054
2054
使用频次
SYPC



2025
0
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
SYPC

29
3
2055
2055
发药属性
FYSX
0.正常发药 1.发一次药(胰岛素类) 2.不发药（自备药)


2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
FYSX

30
3
2056
2056
婴儿判别
YEPB



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
YEPB

31
3
2057
2057
药房识别
YFSB



2025
0
numeric(2)
2
0
0
0




0
0
0
0



0
0
1
1
0
0
YFSB

32
3
2058
2058
临时医嘱
LSYZ



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
LSYZ

33
3
2059
2059
历史标志
LSBZ



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
LSBZ

34
3
2060
2060
医嘱判别
YZPB



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
YZPB

35
3
2061
2061
记费标志
JFBZ



2025
0
numeric(1)
1
0
0
0




1
0
0
0



0
0
1
1
0
0
JFBZ

36
3
2062
2062
备注
BZXX



2025
0
text
0
0
0
0





0
0
0



0
0
0
1
0
0
BZXX

37
3
2987
2987
化验项目
HYXM



2025
0
text
0
0
0
0





0
0
0



0
0
0
1
0
0
HYXM

38
3
3035
3035
发药方式
FYFS



2025
0
numeric(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
FYFS

39
3
3039
3039
TPN
TPN



2025
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
TPN

40
3
2587
2587
排斥组号
PCZH



2586
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
PCZH

1
3
2588
2588
医嘱序号
YZXH



2586
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
YZXH

2
3
2589
2589
医嘱类型
YZLX



2586
0
numeric(1)
1
0
0
0





0
0
0



1
0
1
1
0
0
YZLX

3
3
2590
2590
全排标志
QPBZ



2586
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
0
1
0
0
QPBZ

4
3
3021
3021
住院号
ZYH



3020
0
numeric(18)
18
0
0
0





0
0
0



1
0
1
1
0
0
ZYH

1
3
3022
3022
费用序号
FYXH



3020
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
FYXH

2
3
3023
3023
申请日期
SQRQ



3020
0
datetime
0
0
0
0





0
0
0



1
0
1
1
0
0
SQRQ

3
3
3024
3024
退费日期
TFRQ



3020
0
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
TFRQ

4
3
3025
3025
费用单位
FYDW



3020
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FYDW

5
3
3026
3026
费用价格
FYJG



3020
0
numeric(12,4)
12
4
0
0




0
0
0
0



0
0
0
1
0
0
FYJG

6
3
3027
3027
退费数量
TFSL



3020
0
numeric(8,2)
8
2
0
0




0
0
0
0



0
0
0
1
0
0
TFSL

7
3
3028
3028
自负比例
ZFBL



3020
0
numeric(4,2)
4
2
0
0




1
0
0
0



0
0
0
1
0
0
ZFBL

8
3
3029
3029
婴儿判别
YEPB



3020
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
0
1
0
0
YEPB

9
3
3030
3030
退费病区
TFBQ



3020
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
TFBQ

10
3
3031
3031
操作工号
CZGH



3020
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

11
3
3032
3032
医嘱ID
YZID



3020
0
numeric(18)
18
0
0
0





0
0
0



0
0
0
1
0
0
YZID

12
3
3033
3033
费用项目
FYXM



3020
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
FYXM

13
/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
44
44
Ref_44
REF_44



38
43
1
1
1
1
0
0
REF_44

0
n
0
3
62
62
Ref_62
REF_62



51
61
1
1
1
1
0
0
REF_62

0
n
0
3
2396
2396
Ref_2396
REF_2396



1357
1356
1
1
1
1
0
0
REF_2396

0
n
0
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N8
CCOL    N8
COLN1   N8
COLN2   N8
/BEGIN_DATA AMCCCOL
1
46
46
39
45
1
64
64
53
63
1
67
67
54
66
1
2397
2397
1361
1359
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N8
CREF    N8
REFR    N8
CCOL    N8
NUMR    N8
/BEGIN_DATA AMCCREF
3
47
47
44
46
1
3
65
65
62
64
1
3
68
68
62
67
2
3
2398
2398
2396
2397
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
27
27
IDX_ZY_BQYZ_ZYH
IDX_ZY_BQYZ_ZYH
1



0
0
0
0


1

3
752
752
IDX_ZY_BQYZ_SYBZ
IDX_ZY_BQYZ_SYBZ
1



0
0
0
0


2

3
759
759
IDX_ZY_BQYZ_YZZH
IDX_ZY_BQYZ_YZZH
1



0
0
0
0


3

3
1273
1273
IDX_ZY_BQYZ_LSYZ
IDX_ZY_BQYZ_LSYZ
1



0
0
0
0


4

3
2063
2063
IDX_ZY_BQYZ_ZYH3
IDX_ZY_BQYZ_ZYH3
2025



0
0
0
0


5

3
2064
2064
IDX_ZY_BQYZ_SYBZ3
IDX_ZY_BQYZ_SYBZ3
2025



0
0
0
0


6

3
2065
2065
IDX_ZY_BQYZ_YZZH3
IDX_ZY_BQYZ_YZZH3
2025



0
0
0
0


7

3
2066
2066
IDX_ZY_BQYZ_LSYZ2
IDX_ZY_BQYZ_LSYZ2
2025



0
0
0
0


8

/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N8
CIDX    N8
INDX    N8
COLN    N8
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
3
28
28
27
3
1
1
3
753
753
752
17
1
1
3
760
760
759
73
1
1
3
1274
1274
1273
977
1
1
3
2067
2067
2063
2027
1
1
3
2068
2068
2064
2045
1
1
3
2069
2069
2065
2053
1
1
3
2070
2070
2066
2059
1
1
/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
8
宋体
9
1
9
宋体
9
8
/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
32832
0
78