Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
|||||
| createdOn | DATETIME | 19 | current_timestamp() |
|
|
||||||
| modifiedOn | DATETIME | 19 | current_timestamp() |
|
|
||||||
| userId | BIGINT | 19 | null |
|
|
||||||
| approvalStatus | enum('waiting', 'approved', 'denied') | 8 | 'waiting' |
|
|
||||||
| responseMessage | VARCHAR | 500 | √ | NULL |
|
|
|||||
| cardId | BIGINT | 19 | null |
|
|
||||||
| frontImageUrl | VARCHAR | 100 | null |
|
|
||||||
| backImageUrl | VARCHAR | 100 | null |
|
|
||||||
| isDeleted | BOOLEAN | 3 | 0 |
|
|
||||||
| designNumber | SMALLINT | 5 | 1 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| cardApproval_cardId_index | Performance | Asc | cardId |
| cardApproval_userId_index | Performance | Asc | userId |