|
|
|
|
|
CREATE TABLE MC_BT_VIDEOMONITORRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
LOCATIONID int NULL,
|
|
|
LOCATION varchar(500) NULL,
|
|
|
ALLCT int NULL,
|
|
|
BADCT int NULL,
|
|
|
OKCT int NULL,
|
|
|
BADINFO varchar(4000) NULL,
|
|
|
EXCPINFO varchar(4000) NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_SENDINFORRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
FLAGMANNO int NULL,
|
|
|
FLAGMAN varchar(32) NULL,
|
|
|
SENDDT datetime NULL,
|
|
|
SENDMANNO int NULL,
|
|
|
SENDMAN varchar(16) NULL,
|
|
|
SENDINFO varchar(2000) NULL,
|
|
|
PBMANNO int NULL,
|
|
|
PBMAN varchar(50) NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
REMARK varchar(2000) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
USERTYPE int NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_QBBPUBSPRRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
INFO varchar(4000) NULL,
|
|
|
LOCATIONID int NULL,
|
|
|
LOCATION varchar(2000) NULL,
|
|
|
FONTCOL int NULL,
|
|
|
PUBSTDT datetime NULL,
|
|
|
PUBENDDT datetime NULL,
|
|
|
SENDPART int NULL,
|
|
|
SENDPARTS varchar(50) NULL,
|
|
|
SENDMANNO int NULL,
|
|
|
SENDMAN varchar(16) NULL,
|
|
|
SENDDT datetime NULL,
|
|
|
SENDSHINFO varchar(1000) NULL,
|
|
|
SENDSHMANNO int NULL,
|
|
|
SENDSHMAN varchar(16) NULL,
|
|
|
SENDSHDT datetime NULL,
|
|
|
LEADERSHINFO varchar(1000) NULL,
|
|
|
LEADERSHMANNO int NULL,
|
|
|
LEADERSHMAN varchar(16) NULL,
|
|
|
LEADERSHDT datetime NULL,
|
|
|
REMARK varchar(2000) NULL,
|
|
|
PUBDT datetime NULL,
|
|
|
PUBMANNO int NULL,
|
|
|
PUBMAN varchar(16) NULL,
|
|
|
JCDT varchar(32) NULL,
|
|
|
JCMANNO int NULL,
|
|
|
JCMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_QBBPUBDJRRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
PUBDEPART int NULL,
|
|
|
PUBDEPARTS varchar(50) NULL,
|
|
|
RCVINFODT datetime NULL,
|
|
|
PUBODERMANNO int NULL,
|
|
|
PUBODERMAN varchar(16) NULL,
|
|
|
PUBLOCATIONID int NULL,
|
|
|
PUBLOCATION varchar(2000) NULL,
|
|
|
PUBCOLOR int NULL,
|
|
|
PUBREASON varchar(2000) NULL,
|
|
|
PUBINFO varchar(1000) NULL,
|
|
|
JCDT varchar(32) NULL,
|
|
|
JCORDERMANNO int NULL,
|
|
|
JCORDERMAN varchar(16) NULL,
|
|
|
RCVMANNO int NULL,
|
|
|
RCVMAN varchar(16) NULL,
|
|
|
RECVINFO varchar(1000) NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
PUBMANNO int NULL,
|
|
|
PUBMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_JDREPAIRRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
REPAIRNO varchar(21) NOT NULL,
|
|
|
UPMANNO int NULL,
|
|
|
UPMAN varchar(16) NULL,
|
|
|
UPDT datetime NULL,
|
|
|
UPEQPTYPE int NULL,
|
|
|
UPEQPBADDIS varchar(500) NULL,
|
|
|
UPISYXCAR int NULL,
|
|
|
UPYXWORK varchar(500) NULL,
|
|
|
UPBASEHANDLE varchar(1000) NULL,
|
|
|
ISCZFLAG int NULL,
|
|
|
CENCZDIS varchar(1000) NULL,
|
|
|
CENCZDUTYMANNO int NULL,
|
|
|
CENCZDUTYMAN varchar(16) NULL,
|
|
|
CENCZMANNO int NULL,
|
|
|
CENCZMAN varchar(16) NULL,
|
|
|
CENCZDT datetime NULL,
|
|
|
ISWXFLAG int NULL,
|
|
|
BADOKDIS varchar(1000) NULL,
|
|
|
BADOKDUTYMANNO int NULL,
|
|
|
BADOKDUTYMAN varchar(16) NULL,
|
|
|
BADOKMANNO int NULL,
|
|
|
BADOKMAN varchar(16) NULL,
|
|
|
ISBADOKFLAG int NULL,
|
|
|
ISBADOKDT datetime NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
REPAIRNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_JDREPAIRLOGRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
REPAIRNO varchar(21) NOT NULL,
|
|
|
REPAIRLG varchar(23) NOT NULL,
|
|
|
REPAIRJG varchar(4000) NULL,
|
|
|
DT datetime NULL,
|
|
|
MANNO int NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
CHANGEBJ varchar(1000) NULL,
|
|
|
ZCMANNO int NULL,
|
|
|
ZCMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
REPAIRNO,
|
|
|
REPAIRLG
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_JDREPAIRGDRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
REPAIRNO varchar(21) NOT NULL,
|
|
|
REPAIRGD varchar(23) NOT NULL,
|
|
|
GDHANDLE varchar(1000) NULL,
|
|
|
GDDT datetime NULL,
|
|
|
CARMAN varchar(16) NULL,
|
|
|
CARNO varchar(12) NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
WHMANNO int NULL,
|
|
|
WHMAN varchar(16) NULL,
|
|
|
MANNO int NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
REPAIRNO,
|
|
|
REPAIRGD
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_JDEQPXJRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
INCASH bigint NULL,
|
|
|
CARCT bigint NULL,
|
|
|
SCARINCASH bigint NULL,
|
|
|
SOUTCARCT bigint NULL,
|
|
|
SINCARCT int NULL,
|
|
|
HCARINCASH bigint NULL,
|
|
|
HOUTCARCT bigint NULL,
|
|
|
HINCARCT int NULL,
|
|
|
PORTDIS varchar(4000) NULL,
|
|
|
TEMPTERATURE float NULL,
|
|
|
HUMIDITY float NULL,
|
|
|
ROOMSTTUS int NULL,
|
|
|
NEWWORKSTATUS int NULL,
|
|
|
VEDIASTATUS int NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
FDUTYMANNO int NULL,
|
|
|
FDUTYMAN varchar(16) NULL,
|
|
|
MANNO int NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_JDEQPXJPORTRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
PORTNO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
PORTTYPE int NULL,
|
|
|
PORTKIND int NULL,
|
|
|
YXSTATUS int NULL,
|
|
|
PORTSTATUS int NULL,
|
|
|
REMARK varchar(500) NULL,
|
|
|
EPAYTYPE int NULL,
|
|
|
EPAYLOCAL int NULL,
|
|
|
EPAYKIND int NULL,
|
|
|
EPAYHANDCT int NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
PORTNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE MC_BT_HOTLINERECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
DT datetime NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
TEL varchar(16) NULL,
|
|
|
INFO varchar(1000) NULL,
|
|
|
HANDLEINFO varchar(1000) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
CREATE TABLE MC_BT_DUTYRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
DUTYMANNO int NULL,
|
|
|
DUTYMAN varchar(16) NULL,
|
|
|
INFOMANNO int NULL,
|
|
|
INFOMAN varchar(32) NULL,
|
|
|
JKMANNO int NULL,
|
|
|
JKMAN varchar(32) NULL,
|
|
|
LDORDERINFO text NULL,
|
|
|
DUTYINFO text NULL,
|
|
|
DUTYRESULT varchar(2000) NULL,
|
|
|
OLDDUTYLY text NULL,
|
|
|
OLDDUTYLYNOHANDLE varchar(2000) NULL,
|
|
|
DUTYLY text NULL,
|
|
|
OTHERINFO text NULL,
|
|
|
CHANGEDT datetime NULL,
|
|
|
JBINFOMANNO int NULL,
|
|
|
JBINFOMAN varchar(16) NULL,
|
|
|
JBJKMANNO int NULL,
|
|
|
JBJKMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
CREATE TABLE MC_BT_CARHELRRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
CARSUBCOMNO int NULL,
|
|
|
CARNO varchar(16) NULL,
|
|
|
CARTEL varchar(16) NULL,
|
|
|
CENMANNO int NULL,
|
|
|
CENMAN varchar(16) NULL,
|
|
|
HANDLEPART int NULL,
|
|
|
HANDLEMANNO int NULL,
|
|
|
HANDLEMAN varchar(16) NULL,
|
|
|
HANDLETEL varchar(20) NULL,
|
|
|
HANDLECARNO varchar(16) NULL,
|
|
|
HANDLECARMANNO int NULL,
|
|
|
HANDLECARMAN varchar(16) NULL,
|
|
|
INFO varchar(4000) NULL,
|
|
|
CENRCVDT datetime NULL,
|
|
|
CENRCVMANNO int NULL,
|
|
|
CENRCVMAN varchar(16) NULL,
|
|
|
CENDUTYMANNO int NULL,
|
|
|
CENDUTYMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
CREATE TABLE M_BT_ROOMINSPECTRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
HOUSENAME varchar(100) NULL,
|
|
|
TEMPTERATURE float NULL,
|
|
|
HUMIDITY float NULL,
|
|
|
HJFLAG int NULL,
|
|
|
HJHEALTH varchar(1000) NULL,
|
|
|
EQUIPSTATUS int NULL,
|
|
|
KTSTATUS int NULL,
|
|
|
ISWARNFLAG int NULL,
|
|
|
EQUIPEX varchar(1000) NULL,
|
|
|
WHDESCRIPT varchar(4000) NULL,
|
|
|
WHDT datetime NULL,
|
|
|
WHDEPARTID int NULL,
|
|
|
WHDEPART varchar(100) NULL,
|
|
|
WHMANNO int NULL,
|
|
|
WHMAN varchar(16) NULL,
|
|
|
XCMANNO int NULL,
|
|
|
XCMAN varchar(16) NULL,
|
|
|
XCDT datetime NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE M_BT_ROOMINRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
AIMNO varchar(21) NOT NULL,
|
|
|
ISUPCEN int NULL,
|
|
|
CENRCVMANNO int NULL,
|
|
|
CENRCVMAN varchar(16) NULL,
|
|
|
INROOMDT datetime NULL,
|
|
|
OUTROOMDT datetime NULL,
|
|
|
INAIM varchar(4000) NULL,
|
|
|
OPINFO varchar(4000) NULL,
|
|
|
RCVMANNO int NULL,
|
|
|
RCVMAN varchar(16) NULL,
|
|
|
REMARK varchar(2000) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
AIMNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE M_BT_ROOMINDJMANDETAIL(
|
|
|
AIMNO varchar(21) NOT NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
IDCARD varchar(22) NOT NULL,
|
|
|
TEL varchar(16) NULL,
|
|
|
PARTID int NULL,
|
|
|
PART varchar(100) NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
AIMNO,
|
|
|
IDCARD
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE M_BT_GENUSINGRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
SUBCOMNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
CLASSDATE datetime NOT NULL,
|
|
|
CLASSNO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
DT datetime NULL,
|
|
|
STDT datetime NULL,
|
|
|
ENDDT datetime NULL,
|
|
|
TSUSING int NULL,
|
|
|
SENDMANNO int NULL,
|
|
|
SENDMAN varchar(16) NULL,
|
|
|
CENJKMANNO int NULL,
|
|
|
CENJKMAN varchar(16) NULL,
|
|
|
OPMANNO int NULL,
|
|
|
OPMAN varchar(16) NULL,
|
|
|
USERTYPE int NULL,
|
|
|
DATEMARK datetime NULL,
|
|
|
BAK1 int NULL,
|
|
|
BAK2 int NULL,
|
|
|
BAK3 int NULL,
|
|
|
BAK4 varchar(1) NULL,
|
|
|
BAK5 varchar(1) NULL,
|
|
|
BAK6 varchar(1) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
SUBCOMNO,
|
|
|
STANO,
|
|
|
CLASSDATE,
|
|
|
CLASSNO,
|
|
|
SEQNO
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE M_EMERGENCYCARRECORD(
|
|
|
AREANO int NOT NULL,
|
|
|
ROADNO int NOT NULL,
|
|
|
STANO int NOT NULL,
|
|
|
SEQNO int NOT NULL,
|
|
|
MAKEDATE datetime NOT NULL,
|
|
|
PORTNO int NULL,
|
|
|
DT datetime NULL,
|
|
|
MAN varchar(16) NULL,
|
|
|
CARTYPE int NULL,
|
|
|
CARNO varchar(12) NULL,
|
|
|
TQ varchar(300) NULL,
|
|
|
HANDLE varchar(300) NULL,
|
|
|
CLASSNO int NULL,
|
|
|
JKMANNO int NULL,
|
|
|
JKMAN varchar(16) NULL,
|
|
|
UPDATETIME datetime NULL,
|
|
|
UNUSER1 int NULL,
|
|
|
UNUSER2 varchar(50) NULL,
|
|
|
TQCARTYPE varchar(20) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
AREANO,
|
|
|
ROADNO,
|
|
|
STANO,
|
|
|
SEQNO,
|
|
|
MAKEDATE
|
|
|
)
|
|
|
)
|
|
|
|
|
|
CREATE TABLE M_CODEDICTIONARY(
|
|
|
TYPENAME varchar(20) NOT NULL,
|
|
|
ID int NOT NULL,
|
|
|
TEXT varchar(80) NULL,
|
|
|
EXPLAIN11 varchar(50) NULL,
|
|
|
Expand1 varchar(20) NULL,
|
|
|
Expand2 varchar(20) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
TYPENAME,
|
|
|
ID ASC
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
CREATE TABLE M_CODE(
|
|
|
TYPENAME varchar(20) NOT NULL,
|
|
|
EXPLAIN11 varchar(50) NULL,
|
|
|
EDITFLAY int NULL,
|
|
|
FLAG int NULL,
|
|
|
SUBCOMNO int default 0 NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
TYPENAME
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
CREATE TABLE CMS_PRMIS_TABLE(
|
|
|
PRMISID int NOT NULL,
|
|
|
PRMISNAME varchar(30) NULL,
|
|
|
SYSID int NOT NULL,
|
|
|
PRMISURL varchar(200) NULL,
|
|
|
PARENTFLAG int NULL,
|
|
|
PRMISFLAG int NULL,
|
|
|
ENFLAG int NULL,
|
|
|
OPER varchar(20) NULL,
|
|
|
REMARK varchar(200) NULL,
|
|
|
ICON int NULL,
|
|
|
UNUSED int NULL,
|
|
|
PINDEXSTR varchar(200) NULL,
|
|
|
PRIMARY KEY
|
|
|
(
|
|
|
PRMISID
|
|
|
)
|
|
|
)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE CLASSNO_TEXT(
|
|
|
VALUE smallint NOT NULL,
|
|
|
TEXT varchar(10) NULL,
|
|
|
primary key(VALUE)
|
|
|
)
|
|
|
INSERT INTO CLASSNO_TEXT(VALUE, TEXT) VALUES (0, '未知');
|
|
|
INSERT INTO CLASSNO_TEXT(VALUE, TEXT) VALUES (1, '早班');
|
|
|
INSERT INTO CLASSNO_TEXT(VALUE, TEXT) VALUES (2, '中班');
|
|
|
INSERT INTO CLASSNO_TEXT(VALUE, TEXT) VALUES (3, '晚班');
|
|
|
INSERT INTO CLASSNO_TEXT(VALUE, TEXT) VALUES (4, '夜班');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE SETUP_TABLE (
|
|
|
AREANO smallint NULL,
|
|
|
ROADNO smallint NOT NULL,
|
|
|
STANO smallint NOT NULL,
|
|
|
PORTNO smallint NOT NULL,
|
|
|
PORTIP varchar(20) NULL,
|
|
|
PRIVILEGE smallint DEFAULT (0) NULL,
|
|
|
CARNO smallint DEFAULT (0) NULL,
|
|
|
STEP int DEFAULT (0) NULL,
|
|
|
OUTTIME int DEFAULT (0) NULL,
|
|
|
PORTTYPE smallint DEFAULT (0) NULL,
|
|
|
CARDBOXNEED smallint DEFAULT (0) NULL,
|
|
|
CARDBOXCOUNT int DEFAULT (0) NULL,
|
|
|
COMPARECOIL smallint DEFAULT (0) NULL,
|
|
|
IMAGE smallint DEFAULT (0) NULL,
|
|
|
IMAGEALL smallint DEFAULT (0) NULL,
|
|
|
UNUSE1 int NULL,
|
|
|
UNUSE2 int NULL,
|
|
|
UNUSE3 int NULL,
|
|
|
UNUSE4 int NULL,
|
|
|
UNUSE5 int NULL,
|
|
|
UNUSE6 int NULL,
|
|
|
UNUSE7 int NULL,
|
|
|
UNUSE8 int NULL,
|
|
|
UNUSE9 int NULL,
|
|
|
UNUSE10 int NULL,
|
|
|
UNUSE11 int NULL,
|
|
|
UNUSE12 int NULL,
|
|
|
UNUSE13 int NULL,
|
|
|
UNUSE14 int NULL,
|
|
|
UNUSE15 int NULL,
|
|
|
UNUSE16 int NULL,
|
|
|
PRIMARY KEY(ROADNO, STANO, PORTNO)
|
|
|
)
|
|
|
|