You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
65 lines
1.0 KiB
65 lines
1.0 KiB
DROP TABLE [dbo].[OM_SerialOrderStatusRecLst]
|
|
CREATE TABLE [dbo].[OM_SerialOrderStatusRecLst]
|
|
(
|
|
[
|
|
PlantNr]
|
|
int
|
|
NOT
|
|
NULL, [
|
|
SerialOrderId]
|
|
nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[Pos] int NOT NULL ,
|
|
[PrevStatus] int NOT NULL ,
|
|
[Status] int NOT NULL ,
|
|
[StartTime] datetime NULL ,
|
|
[EndTime] datetime NULL ,
|
|
[TriggerEvent] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[TriggerObjectId] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[TriggerSubObjectId] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[OutputStatus] int NOT NULL ,
|
|
[OutputEvent] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[OutputEventMessageId] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[OutputObjectId] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[OutputSubObjectId] nvarchar
|
|
(
|
|
40
|
|
) NOT NULL ,
|
|
[Remark1] nvarchar
|
|
(
|
|
100
|
|
) NOT NULL ,
|
|
[Remark2] nvarchar
|
|
(
|
|
100
|
|
) NOT NULL ,
|
|
[LastModify] datetime NOT NULL ,
|
|
[LastUser] nvarchar
|
|
(
|
|
20
|
|
) NOT NULL ,
|
|
[CreateTime] datetime NOT NULL
|
|
)
|
|
|
|
|
|
ALTER TABLE [dbo].[OM_SerialOrderStatusRecLst] ADD PRIMARY KEY ([PlantNr], [SerialOrderId], [Pos])
|