1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| CREATE TABLE dbo.MobileUser (
Id [UNIQUEIDENTIFIER] DEFAULT NEWSEQUENTIALID() ROWGUIDCOL NOT NULL,
Hash VARCHAR(160) NOT NULL,
Active BIT NOT NULL,
BirthYear INT NOT NULL,
Gender CHAR(1) NOT NULL,
NickName NVARCHAR(60) NOT NULL,
[Image] VARBINARY(MAX) FILESTREAM NULL,
Grade SMALLINT NULL DEFAULT(0),
CONSTRAINT PK_MOBILEUSER PRIMARY KEY (Id),
CONSTRAINT CHK_GENDER CHECK (Gender IN ('M', 'F', 'L', 'G', 'B', 'T', 'Q', 'I')),
CONSTRAINT CHK_BIRTHDAY CHECK (BirthYear > 1900),
CONSTRAINT UNQ_NICKNAME UNIQUE (NickName),
CONSTRAINT UNQ_HASH UNIQUE (Hash)
)
ON [PRIMARY]
FILESTREAM_ON FS_VOX_GROUP_1
GO |
Partager