299 lines
18 KiB
Transact-SQL
299 lines
18 KiB
Transact-SQL
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3FCD953E-6F9F-48F0-827E-591FF95F5647','施工日志','CQMS/ConstructionLog/ConstructionLog.aspx',180,'0','Menu_CQMS',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('0DAC405B-501F-406C-8881-84474F040A69','3FCD953E-6F9F-48F0-827E-591FF95F5647','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('96FC10D9-BCC0-45BA-9AE9-E8FDB39A44A9','3FCD953E-6F9F-48F0-827E-591FF95F5647','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('72D44317-0606-45AE-A0BB-0F0130CC0840','3FCD953E-6F9F-48F0-827E-591FF95F5647','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('066B0AC0-920D-4320-9881-0913885E4650','3FCD953E-6F9F-48F0-827E-591FF95F5647','保存',4)
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[CQMS_ConstructionLog](
|
|
[ConstructionLogId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[LogDate] [datetime] NULL,
|
|
[WeatherAM] [nvarchar](50) NULL,
|
|
[WeatherPM] [nvarchar](50) NULL,
|
|
[Weather] [nvarchar](50) NULL,
|
|
[DayTemperature] [nvarchar](50) NULL,
|
|
[DayTemperatureMax] [nvarchar](50) NULL,
|
|
[NightTemperature] [nvarchar](50) NULL,
|
|
[NightTemperatureMax] [nvarchar](50) NULL,
|
|
[UnitId] [nvarchar](50) NULL,
|
|
[ProgressAndWorkSituation] [nvarchar](4000) NULL,
|
|
[ConstructionManager] [nvarchar](50) NULL,
|
|
[SafetyGuardian] [nvarchar](50) NULL,
|
|
[ConstructionWorker] [nvarchar](50) NULL,
|
|
[MechanicNum] [int] NULL,
|
|
[LabourNum] [int] NULL,
|
|
[MainConstructionMachine] [nvarchar](500) NULL,
|
|
[ConstructionContent] [nvarchar](4000) NULL,
|
|
[ConstructionEnvironment] [nvarchar](1000) NULL,
|
|
[SafetyWorkSituation] [nvarchar](4000) NULL,
|
|
[SafetyAndQualityMeasures] [nvarchar](50) NULL,
|
|
[HabituaViolations] [nvarchar](50) NULL,
|
|
[SafetyStandardization] [nvarchar](50) NULL,
|
|
[CivilizedConstruction] [nvarchar](4000) NULL,
|
|
[Equipment1] [nvarchar](500) NULL,
|
|
[Equipment2] [nvarchar](500) NULL,
|
|
[Equipment3] [nvarchar](500) NULL,
|
|
[Equipment4] [nvarchar](500) NULL,
|
|
[Equipment5] [nvarchar](500) NULL,
|
|
[Equipment6] [nvarchar](500) NULL,
|
|
[Equipment7] [nvarchar](500) NULL,
|
|
[Equipment8] [nvarchar](500) NULL,
|
|
[Equipment9] [nvarchar](500) NULL,
|
|
[Equipment10] [nvarchar](1000) NULL,
|
|
[ProcessHandover] [nvarchar](4000) NULL,
|
|
[WorkArrangement] [nvarchar](4000) NULL,
|
|
[MeetingSituation] [nvarchar](4000) NULL,
|
|
[VisaRecords] [nvarchar](4000) NULL,
|
|
[UnresolvedIssues] [nvarchar](4000) NULL,
|
|
[FileProcessing] [nvarchar](4000) NULL,
|
|
[RectificationOfIssues] [nvarchar](4000) NULL,
|
|
[ImportantEvents] [nvarchar](4000) NULL,
|
|
[ProblemAndCauseAnalysis] [nvarchar](4000) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
[State] [char](1) NULL,
|
|
CONSTRAINT [PK_CQMS_ConstructionLog] PRIMARY KEY CLUSTERED
|
|
(
|
|
[ConstructionLogId] 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].[CQMS_ConstructionLog] WITH CHECK ADD CONSTRAINT [FK_CQMS_ConstructionLog_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLog] CHECK CONSTRAINT [FK_CQMS_ConstructionLog_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLog] WITH CHECK ADD CONSTRAINT [FK_CQMS_ConstructionLog_Base_Unit] FOREIGN KEY([UnitId])
|
|
REFERENCES [dbo].[Base_Unit] ([UnitId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLog] CHECK CONSTRAINT [FK_CQMS_ConstructionLog_Base_Unit]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLog] WITH CHECK ADD CONSTRAINT [FK_CQMS_ConstructionLog_Sys_User] FOREIGN KEY([CompileMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLog] CHECK CONSTRAINT [FK_CQMS_ConstructionLog_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ConstructionLogId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'LogDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上午气候' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'WeatherAM'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下午气候' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'WeatherPM'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'天气情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Weather'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'白天温度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'DayTemperature'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'白天最大温度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'DayTemperatureMax'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'夜间温度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'NightTemperature'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'夜间最大温度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'NightTemperatureMax'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'施工单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @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'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ProgressAndWorkSituation'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'施工负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ConstructionManager'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全监护人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'SafetyGuardian'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质检员/施工员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ConstructionWorker'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'技工人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'MechanicNum'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'劳工人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'LabourNum'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要施工机械' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'MainConstructionMachine'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'施工内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ConstructionContent'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'施工环境' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ConstructionEnvironment'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'各相关单位安全管理人员的工作情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'SafetyWorkSituation'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场安全质量措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'SafetyAndQualityMeasures'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场是否有习惯性违章情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'HabituaViolations'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场是否按安全文明标准化进行布置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'SafetyStandardization'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文明施工执行情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'CivilizedConstruction'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'到货设备、材料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment1'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'厂家名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment2'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'到货数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment3'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'到货外观质量情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment4'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'随车资料情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment5'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运输车辆车牌号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment6'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'司机姓名及联系方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment7'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接货人员信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment8'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备、材料存放位置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment9'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报验及验收情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'Equipment10'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工序交接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ProcessHandover'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量问题整改情况，存在问题及整改工作安排' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'WorkArrangement'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参加各种会议，会议主持人，参会单位及主要人员，会议内容，会议结论' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'MeetingSituation'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'签证记录（签证部位、投入人力、使用时间及完成情况）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'VisaRecords'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'需要专业、部门及上级领导协调解决的问题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'UnresolvedIssues'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'往来文件处理及计划安排' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'FileProcessing'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场遗留问题的整改情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'RectificationOfIssues'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重要事件：事件发生的时间、地点、涉及人员及事件简述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ImportantEvents'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'存在问题及原因分析' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @level2type=N'COLUMN',@level2name=N'ProblemAndCauseAnalysis'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLog', @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'CQMS_ConstructionLog', @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'CQMS_ConstructionLog', @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'CQMS_ConstructionLog'
|
|
GO
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[CQMS_ConstructionLogApprove](
|
|
[ConstructionLogApproveId] [nvarchar](50) NOT NULL,
|
|
[ConstructionLogId] [nvarchar](50) NULL,
|
|
[ApproveMan] [nvarchar](50) NULL,
|
|
[ApproveDate] [datetime] NULL,
|
|
[IsAgree] [bit] NULL,
|
|
[ApproveIdea] [nvarchar](200) NULL,
|
|
[ApproveType] [char](1) NULL,
|
|
CONSTRAINT [PK_CQMS_ConstructionLogApprove] PRIMARY KEY CLUSTERED
|
|
(
|
|
[ConstructionLogApproveId] 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].[CQMS_ConstructionLogApprove] WITH CHECK ADD CONSTRAINT [FK_CQMS_ConstructionLogApprove_CQMS_ConstructionLog] FOREIGN KEY([ConstructionLogId])
|
|
REFERENCES [dbo].[CQMS_ConstructionLog] ([ConstructionLogId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLogApprove] CHECK CONSTRAINT [FK_CQMS_ConstructionLogApprove_CQMS_ConstructionLog]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLogApprove] WITH CHECK ADD CONSTRAINT [FK_CQMS_ConstructionLogApprove_Sys_User] FOREIGN KEY([ApproveMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CQMS_ConstructionLogApprove] CHECK CONSTRAINT [FK_CQMS_ConstructionLogApprove_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLogApprove', @level2type=N'COLUMN',@level2name=N'ConstructionLogApproveId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主表外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLogApprove', @level2type=N'COLUMN',@level2name=N'ConstructionLogId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'办理人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMS_ConstructionLogApprove', @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'CQMS_ConstructionLogApprove', @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'CQMS_ConstructionLogApprove', @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'CQMS_ConstructionLogApprove', @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'CQMS_ConstructionLogApprove', @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'CQMS_ConstructionLogApprove'
|
|
GO
|
|
|
|
|