Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
||
buildId | VARCHAR | 72 | null |
|
|
|||
status | VARCHAR | 11 | null |
|
|
|||
appId | VARCHAR | 72 | null |
|
|
|||
name | VARCHAR | 72 | null |
|
|
|||
version | VARCHAR | 72 | null |
|
|
|||
buildVersion | VARCHAR | 72 | null |
|
|
|||
channel | VARCHAR | 72 | 'default' |
|
|
|||
updateId | VARCHAR | 72 | '0' |
|
|
|||
patch | VARCHAR | 5 | √ | '0' |
|
|
||
updateCreated | VARCHAR | 255 | √ | NULL |
|
|
||
gitCommitHash | VARCHAR | 72 | √ | NULL |
|
|
||
buildMessage | VARCHAR | 72 | √ | NULL |
|
|
||
error | TINYINT | 3 | √ | 0 |
|
|
||
errorMessage | VARCHAR | 255 | √ | NULL |
|
|
||
createdAt | VARCHAR | 255 | √ | NULL |
|
|
||
completedAt | VARCHAR | 255 | √ | NULL |
|
|
||
updatedAt | VARCHAR | 255 | √ | NULL |
|
|
||
isSupported | TINYINT | 3 | √ | 1 |
|
|
||
isEASUpdate | TINYINT | 3 | √ | 0 |
|
|
||
platform | VARCHAR | 25 | null |
|
|
|||
artifact | VARCHAR | 255 | √ | NULL |
|
|
||
isSubmitted | TINYINT | 3 | √ | 0 |
|
|
||
storeUrl | VARCHAR | 255 | √ | NULL |
|
|
||
storeIdentifier | VARCHAR | 255 | √ | NULL |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
aspen_lida_build_s_pk | Primary key | Asc | id |
buildId | Must be unique | Asc/Asc | buildId + updateId |
PRIMARY | Must be unique | Asc | id |