21 lines
701 B
Transact-SQL
21 lines
701 B
Transact-SQL
CREATE TABLE [dbo].[tTbscsr]
|
|
(
|
|
[cCuid] BIGINT NOT NULL PRIMARY KEY IDENTITY(1,1),
|
|
[cIftid] NVARCHAR(100) NOT NULL,
|
|
[cMacaddr] NVARCHAR(100) NOT NULL,
|
|
[cWmi] NVARCHAR(20) NOT NULL,
|
|
[cIdType] NVARCHAR(10)NOT NULL,
|
|
[cSupplierId] NVARCHAR(10) NOT NULL,
|
|
[cDc] NVARCHAR(20) NOT NULL,
|
|
[cTierCode]NVARCHAR(20) NOT NULL,
|
|
[cUnitCode]NVARCHAR(20) NOT NULL,
|
|
[cPublickey]NVARCHAR(1024) NOT NULL,
|
|
[cCertType]NVARCHAR(20) NOT NULL,
|
|
[cOriginTbscsr] NVARCHAR(4000) NOT NULL,
|
|
[cHashedTbscsr] NVARCHAR(1024) NOT NULL,
|
|
[cPcid] NVARCHAR(50) NOT NULL,
|
|
[cDn]NVARCHAR(250) NOT NULL,
|
|
[cHasCertificate] TINYINT NOT NULL,
|
|
[cDateTime] DATETIME2 NOT NULL
|
|
)
|