156 lines
8.0 KiB
Transact-SQL
156 lines
8.0 KiB
Transact-SQL
|
||
|
||
/****** Object: Table [dbo].[License_TempElectricity] Script Date: 2022/6/28 12:15:08 ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
SET ANSI_PADDING ON
|
||
GO
|
||
|
||
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,
|
||
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
|
||
|
||
SET ANSI_PADDING OFF
|
||
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
|
||
|
||
|