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
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](
[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
Reference in New Issue View Git Blame Copy Permalink