2026-03-06 14:24:20 +08:00
|
|
|
|
-- auto-generated definition
|
|
|
|
|
|
create table dbo.Supervise_UnitHazardRegister
|
|
|
|
|
|
(
|
|
|
|
|
|
UnitHazardRegisterId nvarchar(50) not null
|
|
|
|
|
|
primary key,
|
|
|
|
|
|
UnitHazardRegisterCode nvarchar(50) not null,
|
|
|
|
|
|
CheckDate datetime,
|
|
|
|
|
|
CheckMainType nvarchar(2),
|
|
|
|
|
|
CheckType nvarchar(50),
|
|
|
|
|
|
ProjectId nvarchar(50)
|
|
|
|
|
|
constraint FK_UnitHazardRegister_Project
|
|
|
|
|
|
references dbo.Base_Project,
|
|
|
|
|
|
UnitId nvarchar(50)
|
|
|
|
|
|
constraint FK_UnitHazardRegister_Unit
|
|
|
|
|
|
references dbo.Base_Unit,
|
|
|
|
|
|
CheckObjectId nvarchar(200),
|
|
|
|
|
|
CheckUnitId nvarchar(50)
|
|
|
|
|
|
constraint FK_UnitHazardRegister_CheckUnit
|
|
|
|
|
|
references dbo.Base_Unit,
|
|
|
|
|
|
CheckTeam nvarchar(200),
|
|
|
|
|
|
CheckManIds nvarchar(max),
|
|
|
|
|
|
CheckManNames nvarchar(max),
|
|
|
|
|
|
EvaluationResult nvarchar(max),
|
|
|
|
|
|
AttachUrl nvarchar(2000),
|
|
|
|
|
|
States int default 0,
|
|
|
|
|
|
CompileMan nvarchar(50),
|
|
|
|
|
|
CreateDate datetime,
|
|
|
|
|
|
UpdateDate datetime,
|
|
|
|
|
|
IsUpdate bit
|
|
|
|
|
|
)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
create index IX_UnitHazardRegister_CheckDate
|
|
|
|
|
|
on dbo.Supervise_UnitHazardRegister (CheckDate desc)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
create index IX_UnitHazardRegister_CheckMainType
|
|
|
|
|
|
on dbo.Supervise_UnitHazardRegister (CheckMainType)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
create index IX_UnitHazardRegister_ProjectId
|
|
|
|
|
|
on dbo.Supervise_UnitHazardRegister (ProjectId)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
-- auto-generated definition
|
|
|
|
|
|
create table dbo.Supervise_UnitHazardRegisterItem
|
|
|
|
|
|
(
|
|
|
|
|
|
UnitHazardRegisterItemId nvarchar(50) not null
|
|
|
|
|
|
primary key,
|
|
|
|
|
|
UnitHazardRegisterId nvarchar(50) not null
|
|
|
|
|
|
constraint FK_UnitHazardRegisterItem_Register
|
|
|
|
|
|
references dbo.Supervise_UnitHazardRegister
|
|
|
|
|
|
on delete cascade,
|
|
|
|
|
|
ProblemDescription nvarchar(max),
|
|
|
|
|
|
ProblemType nvarchar(50),
|
|
|
|
|
|
RiskLevel nvarchar(50),
|
|
|
|
|
|
RectifyRequirement nvarchar(max),
|
|
|
|
|
|
CompleteStatus int default 0,
|
|
|
|
|
|
CompletedDate datetime,
|
|
|
|
|
|
SortIndex int default 0,
|
|
|
|
|
|
RectificationMeasures nvarchar(100),
|
|
|
|
|
|
IsUpdate bit
|
|
|
|
|
|
)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
create index IX_UnitHazardRegisterItem_RegisterId
|
|
|
|
|
|
on dbo.Supervise_UnitHazardRegisterItem (UnitHazardRegisterId)
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'C46C007E-A100-4A52-9317-3B885442E130', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', null, N'ZHGL/Supervise/UnitHazardRegister.aspx?type=0', 40, N'CD9FC4C8-4B02-4619-8B02-50DA6AE6146E', N'Menu_HSSE', 1, 1, 1);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'D15F74F2-CD1A-4F45-9501-DF00ED845730', N'C46C007E-A100-4A52-9317-3B885442E130', N'<EFBFBD><EFBFBD>', 2);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'A2CCDFF7-9593-4BCB-9425-769C99F8EFEE', N'C46C007E-A100-4A52-9317-3B885442E130', N'ɾ<EFBFBD><EFBFBD>', 3);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'435F26E9-232F-4CAA-835F-CAF41DA2B175', N'C46C007E-A100-4A52-9317-3B885442E130', N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 4);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'B822D703-CFE3-422A-88F3-67B26B0A255A', N'C46C007E-A100-4A52-9317-3B885442E130', N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1);
|
|
|
|
|
|
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'73283863-CF67-44CA-9DF8-67071734A528', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼', null, N'ZHGL/Supervise/UnitHazardRegisterRecord.aspx?type=0', 45, N'CD9FC4C8-4B02-4619-8B02-50DA6AE6146E', N'Menu_HSSE', 1, 1, 1);
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'6DA1F87C-C980-4A1D-8512-9F20718C77E5', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼', null, N'ZHGL/Supervise/UnitHazardRegisterRecord.aspx?type=0', 10, N'467A0CB9-737D-4451-965E-869EBC3A4BD6', N'Menu_HSSE_P', 1, 1, 1);
|
|
|
|
|
|
|
2026-03-23 15:22:29 +08:00
|
|
|
|
|
|
|
|
|
|
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'720325D1-1FDE-45FD-9BB5-77C7E4E3A16C', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', null, N'', 1, N'0', N'Menu_CQMS', 1, 0, 1);
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'FDA7722C-383E-4BB1-B29D-BB0BF87AA942', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', null, N'ZHGL/Supervise/UnitHazardRegister.aspx?type=1', 40, N'720325D1-1FDE-45FD-9BB5-77C7E4E3A16C', N'Menu_CQMS', 1, 1, 1);
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'B980C835-B079-4485-AE0E-EE721C191470', N'FDA7722C-383E-4BB1-B29D-BB0BF87AA942', N'<EFBFBD><EFBFBD>', 2);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'9BABA2CE-2593-422A-A792-80E826D164AB', N'FDA7722C-383E-4BB1-B29D-BB0BF87AA942', N'ɾ<EFBFBD><EFBFBD>', 3);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'5C9AF2B1-4AF0-4F16-BC5D-154055A6BF8F', N'FDA7722C-383E-4BB1-B29D-BB0BF87AA942', N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 4);
|
|
|
|
|
|
go
|
|
|
|
|
|
INSERT INTO dbo.Sys_ButtonToMenu (ButtonToMenuId, MenuId, ButtonName, SortIndex) VALUES (N'E3CD6629-9B4B-4B26-A24B-97F9F3E4428F', N'FDA7722C-383E-4BB1-B29D-BB0BF87AA942', N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1);
|
|
|
|
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
|
|
|
|
|
VALUES (N'15511354-9822-4A21-AB24-2483D889FDB8', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼', null, N'ZHGL/Supervise/UnitHazardRegisterRecord.aspx?type=1', 45, N'720325D1-1FDE-45FD-9BB5-77C7E4E3A16C', N'Menu_CQMS', 1, 1, 1);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2026-03-06 14:24:20 +08:00
|
|
|
|
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Icon, Url, SortIndex, SuperMenu, MenuType, IsOffice, IsEnd, IsUsed)
|
2026-03-23 15:22:29 +08:00
|
|
|
|
VALUES (N'37F54A65-8B2F-4443-9AC4-A591EF2B0971', N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼', null, N'ZHGL/Supervise/UnitHazardRegisterRecord.aspx?type=1', 5, N'b1249128-7dda-48b9-96dd-824a225b0101', N'Menu_CQMS_P', 1, 1, 1);
|
2026-03-06 14:24:20 +08:00
|
|
|
|
go
|
