Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
InstallerTokenId | INT UNSIGNED | 10 | √ | null |
|
|
||||
InstallerToken | VARCHAR | 200 | null |
|
|
|||||
LocationId | INT UNSIGNED | 10 | null |
|
|
|||||
InstallerTypeId | INT UNSIGNED | 10 | null |
|
|
|||||
ExpirationDateUtc | DATETIME | 19 | null |
|
|
|||||
VerificationKey | TEXT | 65535 | null |
|
|
|||||
IsEnabled | BIT | 1 | null |
|
|
|||||
CreatedBy | VARCHAR | 100 | null |
|
|
|||||
CreateDate | DATETIME | 19 | null |
|
|
|||||
UpdatedBy | VARCHAR | 100 | null |
|
|
|||||
UpdateDate | DATETIME | 19 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | InstallerTokenId |
ExpirationDateUtc | Performance | Asc | ExpirationDateUtc |
InstallerToken | Must be unique | Asc | InstallerToken |