WuJunTao
/
monitorofficesys
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
main
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
monitorofficesys/监控办公包头版C/NMGSMoniterOfficeSys/更新痕记录20230304/script.sql

953 lines
47 KiB
Transact-SQL
Raw Permalink Blame History Unescape Escape

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.


CREATE TABLE [dbo].[MC_BT_VIDEOMONITORRECORD_1](
[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](max) NULL,
[BADINFOLOG] [varchar](max) NULL,
[EXCPINFO] [varchar](max) NULL,
[EXCPINFOLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_TFFLAGRECORD_1](
[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,
[FLAG] [int] NULL,
[DUTYMANNO] [int] NULL,
[DUTYMAN] [varchar](16) NULL,
[INFOMANNO] [int] NULL,
[INFOMAN] [varchar](20) NULL,
[FLAGINFO] [varchar](4000) NULL,
[OPMANNO] [int] NULL,
[OPMAN] [varchar](16) NULL,
[DATEMARK] [datetime] NULL,
[BAK1] [int] NULL,
[BAK2] [int] NULL,
[BAK3] [int] NULL,
[BAK4] [varchar](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_SENDINFORRECORD_1](
[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](max) NULL,
[SENDINFOLOG] [varchar](max) NULL,
[PBMANNO] [int] NULL,
[PBMAN] [varchar](50) NULL,
[DUTYMANNO] [int] NULL,
[DUTYMAN] [varchar](16) NULL,
[REMARK] [varchar](max) NULL,
[REMARKLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1000) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_QBBPUBSPRRECORD_1](
[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,
[INFOLOG] [varchar](max) 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](4000) NULL,
[SENDSHINFOLOG] [varchar](max) NULL,
[SENDSHMANNO] [int] NULL,
[SENDSHMAN] [varchar](16) NULL,
[SENDSHDT] [datetime] NULL,
[LEADERSHINFO] [varchar](4000) NULL,
[LEADERSHINFOLOG] [varchar](max) NULL,
[LEADERSHMANNO] [int] NULL,
[LEADERSHMAN] [varchar](16) NULL,
[LEADERSHDT] [datetime] NULL,
[REMARK] [varchar](4000) NULL,
[REMARKLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_QBBPUBDJRRECORD_1](
[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](max) NULL,
[PUBREASONLOG] [varchar](max) NULL,
[PUBINFO] [varchar](max) NULL,
[PUBINFOLOG] [varchar](max) NULL,
[JCDT] [varchar](32) NULL,
[JCORDERMANNO] [int] NULL,
[JCORDERMAN] [varchar](16) NULL,
[RCVMANNO] [int] NULL,
[RCVMAN] [varchar](16) NULL,
[RECVINFO] [varchar](max) NULL,
[RECVINFOLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_JDREPAIRRECORD_1](
[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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[REPAIRNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_JDREPAIRLOGRECORD_1](
[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] ASC,
[REPAIRLG] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_JDREPAIRGDRECORD_1](
[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] ASC,
[REPAIRGD] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_JDEQPXJPORTRECORD_1](
[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,
[PORTNO] [int] 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC,
[PORTNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_HOTLINERECORD_1](
[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](max) NULL,
[INFOLOG] [varchar](max) NULL,
[HANDLEINFO] [varchar](max) NULL,
[HANDLEINFOLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_JDEQPXJRECORD_1](
[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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_DUTYRECORD_1](
[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] [varchar](4000) NULL,
[LDORDERINFOLOG] [varchar](max) NULL,
[DUTYINFO] [varchar](4000) NULL,
[DUTYINFOLOG] [varchar](max) NULL,
[DUTYRESULT] [varchar](4000) NULL,
[DUTYRESULTLOG] [varchar](max) NULL,
[OLDDUTYLY] [varchar](4000) NULL,
[OLDDUTYLYLOG] [varchar](max) NULL,
[OLDDUTYLYNOHANDLE] [varchar](4000) NULL,
[OLDDUTYLYNOHANDLELOG] [varchar](max) NULL,
[DUTYLY] [varchar](4000) NULL,
[DUTYLYLOG] [varchar](max) NULL,
[OTHERINFO] [varchar](4000) NULL,
[OTHERINFOLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_COMPLAINSUPPORT_1](
[SUBCOMNO] [int] NOT NULL,
[STANO] [int] NOT NULL,
[CLASSDATE] [datetime] NOT NULL,
[CLASSNO] [int] NOT NULL,
[SEQNO] [int] NOT NULL,
[GONO] [int] NOT NULL,
[SUPORTTYPE] [int] NULL,
[SUPORTFILE] [varchar](2000) NULL,
[USERTYPE] [int] NULL,
[BAK1] [int] NULL,
[BAK2] [int] NULL,
[BAK3] [int] NULL,
[BAK4] [varchar](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC,
[GONO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_COMPLAINCALLRECORD_1](
[SUBCOMNO] [int] NOT NULL,
[STANO] [int] NOT NULL,
[CLASSDATE] [datetime] NOT NULL,
[CLASSNO] [int] NOT NULL,
[SEQNO] [int] NOT NULL,
[MAKEDATE] [datetime] NULL,
[INFOFROMNO] [int] NULL,
[INFOFROM] [varchar](300) NULL,
[FLAGTYPE] [int] NULL,
[FLAGNO] [varchar](300) NULL,
[RCDT] [datetime] NULL,
[BYDEPARTNO] [int] NULL,
[BYDEPART] [varchar](200) NULL,
[CPCONTENT] [varchar](4000) NULL,
[CPCONTENTLOG] [varchar](max) NULL,
[NOENDDIS] [varchar](4000) NULL,
[NOENDDISLOG] [varchar](max) NULL,
[CHECKFLAG] [int] NULL,
[CHECKDIS] [varchar](100) NULL,
[CTYCALLBACKFLAG] [int] NULL,
[CTYCALLBACKDIS] [varchar](100) NULL,
[ISREFUND] [int] NULL,
[USINGTIMCT] [int] NULL,
[RESULTFLAG] [int] NULL,
[RCJKMANNO] [int] NULL,
[RCJKMAN] [varchar](16) NULL,
[RCINFOMANNO] [int] NULL,
[RCINFOMAN] [varchar](16) NULL,
[RCOUTEQPNO] [int] NULL,
[RCDUTYMANNO] [int] NULL,
[RCDUTUMAN] [varchar](16) NULL,
[ENDJKMANNO] [int] NULL,
[ENDJKMAN] [varchar](16) NULL,
[ENDINFOMANNO] [int] NULL,
[ENDINFOMAN] [varchar](16) NULL,
[ENDOUTEQPNO] [int] NULL,
[ENDDUTYMANNO] [int] NULL,
[ENDDUTUMAN] [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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_CARHELRRECORD_1](
[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](max) NULL,
[INFOLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[MC_BT_CARHELNEWRRECORD](
[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] NOT NULL,
[INFOFROM] [varchar](2000) NULL,
[CENMANNO] [int] NULL,
[CENMAN] [varchar](16) NULL,
[CARMAN] [varchar](16) NULL,
[CARNO] [varchar](16) NULL,
[CARTYPE] [int] NULL,
[CARTEL] [varchar](16) NULL,
[INFO] [varchar](4000) NULL,
[INFOLOG] [varchar](max) NULL,
[HELPADDR] [varchar](2000) NULL,
[CZLZDT] [datetime] NULL,
[CZDEPARTID] [int] NULL,
[CZDEPART] [varchar](300) NULL,
[CZCARMAN] [varchar](16) NULL,
[CZCARTEL] [varchar](20) NULL,
[CZCARNO] [varchar](16) NULL,
[CZRESULT] [varchar](2000) NULL,
[CENRCVDT] [datetime] NULL,
[CENRCVMANNO] [int] NULL,
[CENRCVMAN] [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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_TFFLAGRECORD_1](
[SUBCOMNO] [int] NOT NULL,
[STANO] [int] NOT NULL,
[CLASSDATE] [datetime] NOT NULL,
[CLASSNO] [int] NOT NULL,
[SEQNO] [int] NOT NULL,
[MAKEDATE] [datetime] NOT NULL,
[INFOFROM] [varchar](500) NULL,
[DT] [datetime] NULL,
[FLAGKIND] [varchar](50) NULL,
[FLAGKTYPE] [int] NULL,
[FLAGDIS] [varchar](1000) NULL,
[CZDEPART] [varchar](64) NULL,
[DCMILE] [int] NULL,
[CZMANNO] [int] NULL,
[CZMAN] [varchar](16) NULL,
[CZTEL] [varchar](32) NULL,
[CZDT] [varchar](18) NULL,
[GLNAME] [varchar](500) NULL,
[FILENO] [varchar](500) NULL,
[FLAGADDR] [varchar](500) NULL,
[STADDINFO] [varchar](4000) NULL,
[STADDINFOLOG] [varchar](max) NULL,
[SEECDIS] [varchar](4000) NULL,
[SEECDISLOG] [varchar](max) NULL,
[DIEDIS] [varchar](500) NULL,
[NEWPLAN] [varchar](4000) NULL,
[NEWPLANLOG] [varchar](max) NULL,
[HANDLEINFO] [varchar](4000) NULL,
[HANDLEINFOLOG] [varchar](max) NULL,
[FIRSTMANNO] [int] NULL,
[FIRSTMAN] [varchar](16) NULL,
[FIRSTLDMANNO] [int] NULL,
[FIRSTLDMAN] [varchar](16) NULL,
[FILLDT] [datetime] NULL,
[RCVDT] [datetime] NULL,
[RCVDIS] [varchar](500) NULL,
[ENDMANNO] [int] NULL,
[ENDMAN] [varchar](16) NULL,
[ENDT] [datetime] NULL,
[ENDLDMANNO] [int] NULL,
[ENDLDMAN] [varchar](16) NULL,
[CENRCVFMANO] [int] NULL,
[CENRCVFMAN] [varchar](16) NULL,
[CENRCVFDT] [datetime] NULL,
[CENRCVXMANNO] [int] NULL,
[CENRCVXMAN] [varchar](16) NULL,
[CENRCVXDT] [datetime] NULL,
[CENRCVZMANNO] [int] NULL,
[CENRCVZMAN] [varchar](16) NULL,
[CENRCVZDT] [datetime] NULL,
[OPMANNO] [int] NULL,
[OPMAN] [varchar](16) NULL,
[DATEMARK] [datetime] NULL,
[BAK1] [int] NULL,
[BAK2] [int] NULL,
[BAK3] [int] NULL,
[BAK4] [varchar](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_TFFLAGDETAILRECORD_1](
[SUBCOMNO] [int] NOT NULL,
[STANO] [int] NOT NULL,
[CLASSDATE] [datetime] NOT NULL,
[CLASSNO] [int] NOT NULL,
[SEQNO] [int] NOT NULL,
[GONO] [int] NOT NULL,
[GOHANLEDIS] [varchar](500) NULL,
[GODT] [datetime] NULL,
[GOMANNO] [int] NULL,
[GOMAN] [varchar](16) NULL,
[OPMANNO] [int] NULL,
[OPMAN] [varchar](16) NULL,
[DATEMARK] [datetime] NULL,
[BAK1] [int] NULL,
[BAK2] [int] NULL,
[BAK3] [int] NULL,
[BAK4] [varchar](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC,
[GONO] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_ROOMINSPECTRECORD_1](
[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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_ROOMINRECORD_1](
[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,
[INAIMLOG] [varchar](max) NULL,
[OPINFO] [varchar](4000) NULL,
[OPINFOLOG] [varchar](max) NULL,
[RCVMANNO] [int] NULL,
[RCVMAN] [varchar](16) NULL,
[REMARK] [varchar](4000) NULL,
[REMARKLOG] [varchar](max) 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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[AIMNO] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_ROOMINDJMANDETAIL_1](
[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] ASC,
[IDCARD] ASC
)
)
GO
CREATE TABLE [dbo].[M_BT_GENUSINGRECORD_1](
[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](20) NULL,
[BAK5] [varchar](1) NULL,
[BAK6] [varchar](1) NULL,
PRIMARY KEY
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)
)
GO
Reference in New Issue View Git Blame Copy Permalink