160 lines
8.5 KiB
Transact-SQL
160 lines
8.5 KiB
Transact-SQL
update Sys_Menu set MenuName='开车危险源清单' where MenuId='1648A5CD-CF78-418B-9CF1-6325C353BDB8'
|
|
update Sys_Menu set MenuName='施工开车交叉期间作业许可' where MenuId='18F5914D-A5DF-44F9-BE04-9EA8908BA3C8'
|
|
go
|
|
|
|
DROP TABLE [dbo].[DriverHse_HseHazard]
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[DriverHse_HseHazard](
|
|
[HseHazardId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NOT NULL,
|
|
[Code] [nvarchar](50) NOT NULL,
|
|
[WorkArea] [nvarchar](50) NULL,
|
|
[IdentificationDate] [datetime] NULL,
|
|
[ControlHeaderMan] [nvarchar](50) NULL,
|
|
[Remark] [nvarchar](500) NULL,
|
|
[AttachUrl] [nvarchar](2000) NULL,
|
|
CONSTRAINT [PK_DriverHse_HseHazard] PRIMARY KEY CLUSTERED
|
|
(
|
|
[HseHazardId] 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].[DriverHse_HseHazard] WITH CHECK ADD CONSTRAINT [FK_DriverHse_HseHazard_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[DriverHse_HseHazard] CHECK CONSTRAINT [FK_DriverHse_HseHazard_Base_Project]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'HseHazardId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @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'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'Code'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目区域' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'WorkArea'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'辨识时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'IdentificationDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控制责任人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'ControlHeaderMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @level2type=N'COLUMN',@level2name=N'Remark'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseHazard', @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'DriverHse_HseHazard'
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[Base_TestRunLicenseType](
|
|
[LicenseTypeId] [nvarchar](50) NOT NULL,
|
|
[LicenseTypeCode] [nvarchar](50) NULL,
|
|
[LicenseTypeName] [nvarchar](50) NULL,
|
|
[TemplateUrl] [nvarchar](500) NULL,
|
|
[Remark] [nvarchar](500) NULL,
|
|
CONSTRAINT [PK_Base_TestRunLicenseType] PRIMARY KEY CLUSTERED
|
|
(
|
|
[LicenseTypeId] 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'Base_TestRunLicenseType', @level2type=N'COLUMN',@level2name=N'LicenseTypeId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业类别编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TestRunLicenseType', @level2type=N'COLUMN',@level2name=N'LicenseTypeCode'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业类别名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TestRunLicenseType', @level2type=N'COLUMN',@level2name=N'LicenseTypeName'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TestRunLicenseType', @level2type=N'COLUMN',@level2name=N'TemplateUrl'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TestRunLicenseType', @level2type=N'COLUMN',@level2name=N'Remark'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业类别及模板' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TestRunLicenseType'
|
|
GO
|
|
|
|
drop table DriverHse_HseLicense
|
|
go
|
|
CREATE TABLE [dbo].[DriverHse_HseLicense](
|
|
[HseLicenseId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NOT NULL,
|
|
[Code] [nvarchar](50) NOT NULL,
|
|
[LicenseTypeId] [nvarchar](50) NULL,
|
|
[ApplyUnit] [nvarchar](50) NULL,
|
|
[ApplyMan] [nvarchar](50) NULL,
|
|
[HeaderMan] [nvarchar](50) NULL,
|
|
[WorkAddress] [nvarchar](50) NULL,
|
|
[WorkContents] [nvarchar](500) NULL,
|
|
[Remark] [nvarchar](500) NULL,
|
|
CONSTRAINT [PK_DriverHse_HseLicense] PRIMARY KEY CLUSTERED
|
|
(
|
|
[HseLicenseId] 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].[DriverHse_HseLicense] WITH CHECK ADD CONSTRAINT [FK_DriverHse_HseLicense_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[DriverHse_HseLicense] CHECK CONSTRAINT [FK_DriverHse_HseLicense_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[DriverHse_HseLicense] WITH CHECK ADD CONSTRAINT [FK_DriverHse_HseLicense_Base_TestRunLicenseType] FOREIGN KEY([LicenseTypeId])
|
|
REFERENCES [dbo].[Base_TestRunLicenseType] ([LicenseTypeId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[DriverHse_HseLicense] CHECK CONSTRAINT [FK_DriverHse_HseLicense_Base_TestRunLicenseType]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'HseLicenseId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @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'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'Code'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'LicenseTypeId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'ApplyUnit'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'ApplyMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'HeaderMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'WorkAddress'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'WorkContents'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense', @level2type=N'COLUMN',@level2name=N'Remark'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开车作业票管理表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverHse_HseLicense'
|
|
GO
|
|
|
|
|
|
|
|
|