| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | -- YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail definition |
|---|
| | | |
|---|
| | | -- Drop table |
|---|
| | | |
|---|
| | | -- DROP TABLE YrtWMS_Siemens2.deviceGeneralInfoForDetail; |
|---|
| | | |
|---|
| | | CREATE TABLE YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail ( |
|---|
| | | id int IDENTITY(1,1) NOT NULL, |
|---|
| | | taskEnterCount int NULL, |
|---|
| | | taskOutCount int NULL, |
|---|
| | | stockProportion int NULL, |
|---|
| | | outDate int NULL, |
|---|
| | | deviceRunTime decimal(18,0) NULL, |
|---|
| | | deviceWaitTime decimal(18,0) NULL, |
|---|
| | | deviceAlarmTime decimal(18,0) NULL, |
|---|
| | | createTime datetime NULL, |
|---|
| | | ext1 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
|---|
| | | ext2 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
|---|
| | | ext3 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
|---|
| | | ext4 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
|---|
| | | CONSTRAINT PK_deviceGeneralInfoForDetail PRIMARY KEY (id) |
|---|
| | | ); |
|---|
| | | |
|---|
| | | |
|---|
