505 lines
25 KiB
Transact-SQL
505 lines
25 KiB
Transact-SQL
Alter TABLE [dbo].[License_BreakGround]add
|
||
[RealWorkDepth] [nvarchar](50) NULL,
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[WatchMan] [nvarchar](50) NULL,
|
||
[WorkMan] [nvarchar](50) NULL,
|
||
[IdNum] [nvarchar](50) NULL
|
||
|
||
|
||
Alter TABLE [dbo].[License_FireWork]add
|
||
[FireMan] [nvarchar](50) NULL,
|
||
[AnalysisData] [nvarchar](50) NULL,
|
||
[SignatureUrl] [nvarchar](500) NULL
|
||
|
||
Alter TABLE [dbo].[License_FlowOperate]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[CanEndFlow] [bit] NULL
|
||
|
||
|
||
Alter TABLE [dbo].[License_HeightWork]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[SafeMan] [nvarchar](50) NULL,
|
||
[WatchMan] [nvarchar](50) NULL,
|
||
[WorkMan] [nvarchar](50) NULL
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[License_JiaBan](
|
||
[JiaBanId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[LicenseCode] [nvarchar](50) NULL,
|
||
[ApplyUnitId] [nvarchar](50) NULL,
|
||
[ApplyManId] [nvarchar](50) NULL,
|
||
[ApplyDate] [datetime] NULL,
|
||
[WorkPalce] [nvarchar](300) NULL,
|
||
[WorkType] [nvarchar](50) NULL,
|
||
[SafeLeader] [nvarchar](50) NULL,
|
||
[Reason] [nvarchar](500) NULL,
|
||
[WorkLeader] [nvarchar](50) NULL,
|
||
[PeopleNum] [nvarchar](50) NULL,
|
||
[ElectricalMan] [nvarchar](50) NULL,
|
||
[ValidityStartTime] [datetime] NULL,
|
||
[ValidityEndTime] [datetime] NULL,
|
||
[WorkMeasures] [nvarchar](500) NULL,
|
||
[EquipmentTools] [nvarchar](100) NULL,
|
||
[CancelManId] [nvarchar](50) NULL,
|
||
[CancelReasons] [nvarchar](200) NULL,
|
||
[CancelTime] [datetime] NULL,
|
||
[CloseManId] [nvarchar](50) NULL,
|
||
[CloseReasons] [nvarchar](200) NULL,
|
||
[CloseTime] [datetime] NULL,
|
||
[States] [varchar](2) NULL,
|
||
[NextManId] [nvarchar](500) NULL,
|
||
[OldLicenseId] [nvarchar](50) NULL,
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
CONSTRAINT [PK_License_JiaBan] PRIMARY KEY CLUSTERED
|
||
(
|
||
[JiaBanId] 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
|
||
|
||
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] WITH CHECK ADD CONSTRAINT [FK_License_JiaBan_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] CHECK CONSTRAINT [FK_License_JiaBan_Base_Project]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] WITH CHECK ADD CONSTRAINT [FK_License_JiaBan_Base_Unit] FOREIGN KEY([ApplyUnitId])
|
||
REFERENCES [dbo].[Base_Unit] ([UnitId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] CHECK CONSTRAINT [FK_License_JiaBan_Base_Unit]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] WITH CHECK ADD CONSTRAINT [FK_License_JiaBan_Sys_User] FOREIGN KEY([ApplyManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] CHECK CONSTRAINT [FK_License_JiaBan_Sys_User]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] WITH CHECK ADD CONSTRAINT [FK_License_JiaBan_Sys_User2] FOREIGN KEY([CancelManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] CHECK CONSTRAINT [FK_License_JiaBan_Sys_User2]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] WITH CHECK ADD CONSTRAINT [FK_License_JiaBan_Sys_User3] FOREIGN KEY([CloseManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_JiaBan] CHECK CONSTRAINT [FK_License_JiaBan_Sys_User3]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>Ǹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'JiaBanId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'LicenseCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>뵥ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ApplyUnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ApplyManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ApplyDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ص<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'WorkPalce'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'WorkType'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڿ<EFBFBD>ʼʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ValidityStartTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڽ<EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'ValidityEndTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ݡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʩ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'WorkMeasures'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>豸<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'EquipmentTools'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CancelManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CancelReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CancelTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CloseManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CloseReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'CloseTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬(0-<2D><><EFBFBD>ύ<EFBFBD><E1BDBB>1-<2D><><EFBFBD><EFBFBD><EFBFBD>У<EFBFBD>2-<2D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɣ<EFBFBD>3-<2D>رգ<D8B1>-1ȡ<31><C8A1>)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'States'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'NextManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ԭ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan', @level2type=N'COLUMN',@level2name=N'OldLicenseId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>Ǹ<EFBFBD><EFBFBD><EFBFBD>ҵƱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_JiaBan'
|
||
GO
|
||
|
||
|
||
|
||
|
||
Alter TABLE [dbo].[License_LicenseManager]add
|
||
[IsHighRisk] [bit] NULL
|
||
|
||
Alter TABLE [dbo].[License_LiftingWork]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[SafeMan] [nvarchar](50) NULL,
|
||
[ControlMan] [nvarchar](50) NULL,
|
||
[DriverMan] [nvarchar](50) NULL,
|
||
[CarNum] [nvarchar](50) NULL,
|
||
[OtherMan] [nvarchar](50) NULL,
|
||
[WatchMan] [nvarchar](50) NULL
|
||
|
||
|
||
Alter TABLE [dbo].[License_LimitedSpace]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[O2Density] [nvarchar](50) NULL,
|
||
[ManAndDate] [nvarchar](50) NULL,
|
||
[ResponsibleManPhone] [nvarchar](50) NULL,
|
||
[WorkMan] [nvarchar](100) NULL,
|
||
[Tools] [nvarchar](200) NULL
|
||
|
||
|
||
Alter TABLE [dbo].[License_NightWork]add
|
||
[SignatureUrl] [nvarchar](500) NULL
|
||
|
||
Alter TABLE [dbo].[License_OpenCircuit]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[WatchMan] [nvarchar](50) NULL
|
||
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[License_PressureTest](
|
||
[PressureTestId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[LicenseCode] [nvarchar](50) NULL,
|
||
[ApplyUnitId] [nvarchar](50) NULL,
|
||
[ApplyManId] [nvarchar](50) NULL,
|
||
[ApplyDate] [datetime] NULL,
|
||
[WorkPalce] [nvarchar](300) NULL,
|
||
[WatchManId] [nvarchar](50) NULL,
|
||
[ValidityStartTime] [datetime] NULL,
|
||
[ValidityEndTime] [datetime] NULL,
|
||
[WorkContent] [nvarchar](500) NULL,
|
||
[PressureAndType] [nvarchar](50) NULL,
|
||
[CancelManId] [nvarchar](50) NULL,
|
||
[CancelReasons] [nvarchar](200) NULL,
|
||
[CancelTime] [datetime] NULL,
|
||
[CloseManId] [nvarchar](50) NULL,
|
||
[CloseReasons] [nvarchar](200) NULL,
|
||
[CloseTime] [datetime] NULL,
|
||
[States] [varchar](2) NULL,
|
||
[NextManId] [nvarchar](500) NULL,
|
||
[WatchManName] [nvarchar](50) NULL,
|
||
[OldLicenseId] [nvarchar](50) NULL,
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
CONSTRAINT [PK_License_PressureTest] PRIMARY KEY CLUSTERED
|
||
(
|
||
[PressureTestId] 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
|
||
|
||
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Base_Project]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Base_Unit] FOREIGN KEY([ApplyUnitId])
|
||
REFERENCES [dbo].[Base_Unit] ([UnitId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Base_Unit]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Sys_User] FOREIGN KEY([ApplyManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Sys_User]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Sys_User1] FOREIGN KEY([WatchManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Sys_User1]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Sys_User2] FOREIGN KEY([CancelManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Sys_User2]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] WITH CHECK ADD CONSTRAINT [FK_License_PressureTest_Sys_User3] FOREIGN KEY([CloseManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_PressureTest] CHECK CONSTRAINT [FK_License_PressureTest_Sys_User3]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'PressureTestId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'LicenseCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>뵥ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ApplyUnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ApplyManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ApplyDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ص<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'WorkPalce'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'WatchManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڿ<EFBFBD>ʼʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ValidityStartTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڽ<EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'ValidityEndTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ݡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʩ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'WorkContent'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CancelManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CancelReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CancelTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CloseManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CloseReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'CloseTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬(0-<2D><><EFBFBD>ύ<EFBFBD><E1BDBB>1-<2D><><EFBFBD><EFBFBD><EFBFBD>У<EFBFBD>2-<2D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɣ<EFBFBD>3-<2D>رգ<D8B1>-1ȡ<31><C8A1>)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'States'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'NextManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'WatchManName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ԭ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest', @level2type=N'COLUMN',@level2name=N'OldLicenseId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ѹ<EFBFBD><EFBFBD>ҵƱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_PressureTest'
|
||
GO
|
||
|
||
|
||
|
||
Alter TABLE [dbo].[License_RadialWork]add
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[WorkMan1] [nvarchar](50) NULL,
|
||
[WorkMan2] [nvarchar](50) NULL,
|
||
[WorkMan3] [nvarchar](50) NULL,
|
||
[WorkManCard1] [nvarchar](50) NULL,
|
||
[WorkManCard2] [nvarchar](50) NULL,
|
||
[WorkManCard3] [nvarchar](50) NULL,
|
||
[SafeDistance] [nvarchar](50) NULL
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[License_TempElectricity](
|
||
[TempElectricityId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[LicenseCode] [nvarchar](50) NULL,
|
||
[ApplyUnitId] [nvarchar](50) NULL,
|
||
[ApplyManId] [nvarchar](50) NULL,
|
||
[ApplyDate] [datetime] NULL,
|
||
[WorkPalce] [nvarchar](300) NULL,
|
||
[WatchManId] [nvarchar](50) NULL,
|
||
[ValidityStartTime] [datetime] NULL,
|
||
[ValidityEndTime] [datetime] NULL,
|
||
[WorkMeasures] [nvarchar](500) NULL,
|
||
[CancelManId] [nvarchar](50) NULL,
|
||
[CancelReasons] [nvarchar](200) NULL,
|
||
[CancelTime] [datetime] NULL,
|
||
[CloseManId] [nvarchar](50) NULL,
|
||
[CloseReasons] [nvarchar](200) NULL,
|
||
[CloseTime] [datetime] NULL,
|
||
[States] [varchar](2) NULL,
|
||
[NextManId] [nvarchar](500) NULL,
|
||
[WatchManName] [nvarchar](50) NULL,
|
||
[OldLicenseId] [nvarchar](50) NULL,
|
||
[SignatureUrl] [nvarchar](500) NULL,
|
||
[Electrician] [nvarchar](50) NULL,
|
||
[Tools] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_License_TempElectricity] PRIMARY KEY CLUSTERED
|
||
(
|
||
[TempElectricityId] 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
|
||
|
||
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Base_Project]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Base_Unit] FOREIGN KEY([ApplyUnitId])
|
||
REFERENCES [dbo].[Base_Unit] ([UnitId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Base_Unit]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Sys_User] FOREIGN KEY([ApplyManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Sys_User]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Sys_User1] FOREIGN KEY([WatchManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Sys_User1]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Sys_User2] FOREIGN KEY([CancelManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Sys_User2]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] WITH CHECK ADD CONSTRAINT [FK_License_TempElectricity_Sys_User3] FOREIGN KEY([CloseManId])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[License_TempElectricity] CHECK CONSTRAINT [FK_License_TempElectricity_Sys_User3]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'TempElectricityId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'LicenseCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>뵥ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ApplyUnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ApplyManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ApplyDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ص<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'WorkPalce'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'WatchManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڿ<EFBFBD>ʼʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ValidityStartTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ч<EFBFBD>ڽ<EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'ValidityEndTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ݡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʩ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'WorkMeasures'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CancelManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CancelReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȡ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CancelTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CloseManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ԭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CloseReasons'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'CloseTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬(0-<2D><><EFBFBD>ύ<EFBFBD><E1BDBB>1-<2D><><EFBFBD><EFBFBD><EFBFBD>У<EFBFBD>2-<2D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɣ<EFBFBD>3-<2D>رգ<D8B1>-1ȡ<31><C8A1>)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'States'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'NextManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'WatchManName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ԭ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity', @level2type=N'COLUMN',@level2name=N'OldLicenseId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD><EFBFBD>ҵƱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'License_TempElectricity'
|
||
GO
|
||
|
||
|