Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
|||||
| createdOn | DATETIME | 19 | current_timestamp() |
|
|
||||||
| modifiedOn | DATETIME | 19 | current_timestamp() |
|
|
||||||
| creatorId | BIGINT | 19 | null |
|
|
||||||
| url | VARCHAR | 255 | null |
|
|
||||||
| type | enum('video', 'image') | 5 | null |
|
|
||||||
| isDeleted | VARCHAR | 255 | '0' |
|
|
||||||
| metaData | LONGTEXT | 2147483647 | null |
|
|
||||||
| storageDetails | LONGTEXT | 2147483647 | null |
|
|
||||||
| encodingStatus | enum('encoding', 'failed', 'not_encoding') | 12 | 'not_encoding' |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| media_creatorId_index | Performance | Asc | creatorId |
| media_encodingStatus_index | Performance | Asc | encodingStatus |