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/包头表结构.sql

809 lines
44 KiB
MySQL
Raw Permalink Normal View History Unescape Escape

cs
10 months ago
<EFBFBD><EFBFBD>
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_VI__F2D284B85DB6AC22] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_SENDINFORRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_SE__F2D284B86B10A740] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_QBBPUBSPRRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_QB__F2D284B8768259EC] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_QBBPUBDJRRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_QB__F2D284B87A52EAD0] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_JDREPAIRRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_JD__197C976A40E5634A] PRIMARY KEY CLUSTERED
(
[REPAIRNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_JDREPAIRLOGRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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 CLUSTERED
(
[REPAIRNO] ASC,
[REPAIRLG] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_JDREPAIRGDRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_JD__C8EBA2AA44B5F42E] PRIMARY KEY CLUSTERED
(
[REPAIRNO] ASC,
[REPAIRGD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_JDEQPXJRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_JD__FF0BA67E55E08030] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_JDEQPXJPORTRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_JD__02570B9A59B11114] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[PORTNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_HOTLINERECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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 CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_DUTYRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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] [varchar](4000) NULL,
[DUTYINFO] [varchar](4000) NULL,
[DUTYRESULT] [varchar](2000) NULL,
[OLDDUTYLY] [varchar](4000) NULL,
[OLDDUTYLYNOHANDLE] [varchar](2000) NULL,
[DUTYLY] [varchar](4000) NULL,
[OTHERINFO] [varchar](4000) 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,
CONSTRAINT [PK__MC_BT_DU__F2D284B84D804459] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MC_BT_CARHELRRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__MC_BT_CA__F2D284B809952E60] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[M_BT_ROOMINSPECTRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__M_BT_ROO__F2D284B82FBAD748] PRIMARY KEY CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[M_BT_ROOMINRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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 CLUSTERED
(
[AIMNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[M_BT_ROOMINDJMANDETAIL] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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,
CONSTRAINT [PK__M_BT_ROO__815CB0591CA802D4] PRIMARY KEY CLUSTERED
(
[AIMNO] ASC,
[IDCARD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[M_BT_GENUSINGRECORD] Script Date: 10/25/2022 17:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[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 CLUSTERED
(
[SUBCOMNO] ASC,
[STANO] ASC,
[CLASSDATE] ASC,
[CLASSNO] ASC,
[SEQNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
create table MC_WARNINFO_TABLE(
SUBCOMNO INT,
STANO INT,
SEQNO BIGINT,
INFO VARCHAR(4000),
ISCROLL INT,
DATEMARK DATETIME,
REMARK VARCHAR(1000),
BAKUP1 INT,
BAKUP2 INT,
BAKUP3 VARCHAR(1),
BAKUP4 VARCHAR(1),
PRIMARY KEY(STANO,SEQNO)
)
go