lpf
/
CNCEC_SUBQHSE_WUHUAN
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
CNCEC_SUBQHSE_WUHUAN/DataBase/版本日志/SGGLDB_WH_2024-02-28-gaofei...

165 lines
9.3 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

CREATE TABLE [dbo].[Solution_TestRunConstructSolution](
[ConstructSolutionId] [nvarchar](50) NOT NULL,
[Code] [nvarchar](50) NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[SolutionName] [nvarchar](100) NULL,
[SolutionType] [nvarchar](50) NULL,
[UnitWorkIds] [nvarchar](2000) NULL,
[CNProfessionalCodes] [nvarchar](500) NULL,
[AttachUrl] [nvarchar](2000) NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
[State] [char](1) NULL,
[Edition] [int] NULL,
[SpecialSchemeTypeId] [nvarchar](50) NULL,
[Content] [nvarchar](2000) NULL,
CONSTRAINT [PK_Solution_TestRunConstructSolution] PRIMARY KEY CLUSTERED
(
[ConstructSolutionId] 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].[Solution_TestRunConstructSolution] WITH CHECK ADD CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolution] CHECK CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_Project]
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolution] WITH CHECK ADD CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_SpecialSchemeType] FOREIGN KEY([SpecialSchemeTypeId])
REFERENCES [dbo].[Base_SpecialSchemeType] ([SpecialSchemeTypeId])
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolution] CHECK CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_SpecialSchemeType]
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolution] WITH CHECK ADD CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolution] CHECK CONSTRAINT [FK_Solution_TestRunConstructSolution_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ö÷¼ü' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'ConstructSolutionId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'񅧏' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÏîÄ¿Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'ProjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ê©¹¤µ¥Î»Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·½°¸Ãû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'SolutionName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·½°¸Àà±ð£¨1-Ê©¹¤×éÖ¯Éè¼Æ£¬2-רÏîÊ©¹¤·½°¸£¬3-Ê©¹¤·½°¸£©' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'SolutionType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µ¥Î»¹¤³Ì' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'UnitWorkIds'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'רҵ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'CNProfessionalCodes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸½¼þ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'AttachUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'±àÖÆÈË' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'CompileMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'±àÖÆÈÕÆÚ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'CompileDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶þ¼¶·½°¸' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'SpecialSchemeTypeId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÕýÎÄ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution', @level2type=N'COLUMN',@level2name=N'Content'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ê©¹¤·½°¸±í' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolution'
GO
CREATE TABLE [dbo].[Solution_TestRunConstructSolutionApprove](
[ConstructSolutionApproveId] [nvarchar](50) NOT NULL,
[ConstructSolutionId] [nvarchar](50) NULL,
[ApproveMan] [nvarchar](50) NULL,
[ApproveDate] [datetime] NULL,
[IsAgree] [bit] NULL,
[ApproveIdea] [nvarchar](200) NULL,
[ApproveType] [char](1) NULL,
[AttachUrl] [nvarchar](200) NULL,
[SignType] [nvarchar](20) NULL,
[Edition] [int] NULL,
[order] [int] NULL,
CONSTRAINT [PK_Solution_TestRunConstructSolutionApprove] PRIMARY KEY CLUSTERED
(
[ConstructSolutionApproveId] 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].[Solution_TestRunConstructSolutionApprove] WITH CHECK ADD CONSTRAINT [FK_Solution_TestRunConstructSolutionApprove_Solution_TestRunConstructSolution] FOREIGN KEY([ConstructSolutionId])
REFERENCES [dbo].[Solution_TestRunConstructSolution] ([ConstructSolutionId])
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolutionApprove] CHECK CONSTRAINT [FK_Solution_TestRunConstructSolutionApprove_Solution_TestRunConstructSolution]
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolutionApprove] WITH CHECK ADD CONSTRAINT [FK_Solution_TestRunConstructSolutionApprove_Sys_User] FOREIGN KEY([ApproveMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[Solution_TestRunConstructSolutionApprove] CHECK CONSTRAINT [FK_Solution_TestRunConstructSolutionApprove_Sys_User]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ö÷¼ü' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ConstructSolutionApproveId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Íâ¼ü' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ConstructSolutionId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'°ìÀíÈË' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ApproveMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'°ìÀíÈÕÆÚ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ApproveDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÊÇ·ñͬÒâ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'IsAgree'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'°ìÀíÒâ¼û' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ApproveIdea'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'°ìÀí²½Öè' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'ApproveType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸½¼þ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'AttachUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´ÎÐò' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove', @level2type=N'COLUMN',@level2name=N'order'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ê©¹¤·½°¸ÉóÅú±í' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Solution_TestRunConstructSolutionApprove'
GO
Reference in New Issue View Git Blame Copy Permalink