88 lines
4.6 KiB
Transact-SQL
88 lines
4.6 KiB
Transact-SQL
alter table [dbo].[Person_TestRunPerformance] add Num int null
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[Person_TestRunMonthSummary](
|
|
[TestRunMonthSummaryId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[UserId] [nvarchar](50) NULL,
|
|
[ProcessName] [nvarchar](50) NULL,
|
|
[RaiseDate] [datetime] NULL,
|
|
[ProblemDescription] [nvarchar](4000) NULL,
|
|
[HandleMethod] [nvarchar](4000) NULL,
|
|
[ExperienceOrSuggestion] [nvarchar](4000) NULL,
|
|
CONSTRAINT [PK_Person_TestRunMonthSummary] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TestRunMonthSummaryId] 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].[Person_TestRunMonthSummary] WITH CHECK ADD CONSTRAINT [FK_Person_TestRunMonthSummary_Sys_User] FOREIGN KEY([UserId])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Person_TestRunMonthSummary] CHECK CONSTRAINT [FK_Person_TestRunMonthSummary_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'TestRunMonthSummaryId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提出人Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'UserId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工序名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'ProcessName'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提出时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'RaiseDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'问题描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'ProblemDescription'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'处理方法' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'HandleMethod'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'体会或建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary', @level2type=N'COLUMN',@level2name=N'ExperienceOrSuggestion'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开车月技术总结表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Person_TestRunMonthSummary'
|
|
GO
|
|
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[ZHGL_TestRunMonthSummaryReport](
|
|
[TestRunMonthSummaryReportId] [nvarchar](50) NOT NULL,
|
|
[Year] [int] NULL,
|
|
[UserId] [nvarchar](50) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
CONSTRAINT [PK_ZHGL_TestRunMonthSummaryReport] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TestRunMonthSummaryReportId] 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
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZHGL_TestRunMonthSummaryReport', @level2type=N'COLUMN',@level2name=N'TestRunMonthSummaryReportId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZHGL_TestRunMonthSummaryReport', @level2type=N'COLUMN',@level2name=N'Year'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZHGL_TestRunMonthSummaryReport', @level2type=N'COLUMN',@level2name=N'UserId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编制人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZHGL_TestRunMonthSummaryReport', @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'ZHGL_TestRunMonthSummaryReport', @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'ZHGL_TestRunMonthSummaryReport'
|
|
GO
|
|
|
|
|