41 lines
1.6 KiB
Transact-SQL
41 lines
1.6 KiB
Transact-SQL
|
|
--==投料试车/生产试运行参数设置
|
|
if object_id(N'Run_ParameterSettings',N'U') is not null
|
|
drop table dbo.Run_ParameterSettings
|
|
CREATE TABLE dbo.Run_ParameterSettings(
|
|
SettingsId varchar(50) NOT NULL,--主键
|
|
ProjectId varchar(50) NULL,--项目主键
|
|
InstallationId varchar(50) NULL,--装置主键(冗余字段，方便后期关联适用)
|
|
ProcessesId varchar(50) NULL,--工序主键(冗余字段，方便后期关联适用)
|
|
SystemId varchar(50) NULL,--系统主键(冗余字段，方便后期关联适用)
|
|
States int null,--类型1:投料试车2:生产试运行
|
|
RunType int null,--投料试车(1:未投料2:投料中3:投料完成)生产试运行(1:未运行2:运行中3:停车检修)
|
|
AllNum int null,--全部数量
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
Sort int NULL,--排序
|
|
CONSTRAINT PK_Run_ParameterSettings PRIMARY KEY CLUSTERED
|
|
(
|
|
SettingsId 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
|
|
|
|
--==生产性能考核设置
|
|
if object_id(N'Run_ProductionSettings',N'U') is not null
|
|
drop table dbo.Run_ProductionSettings
|
|
CREATE TABLE dbo.Run_ProductionSettings(
|
|
ProductionId varchar(50) NOT NULL,--主键
|
|
ProjectId varchar(50) NULL,--项目主键
|
|
States int null,--类型1:考核未开始2:考核进行中3:考核已完成
|
|
StartTime datetime NULL,--开始日期
|
|
EndTime datetime NULL,--结束日期
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
Sort int NULL,--排序
|
|
CONSTRAINT PK_Run_ProductionSettings PRIMARY KEY CLUSTERED
|
|
(
|
|
ProductionId 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 |