Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| store_id | int8 | 19 | √ | null |
|
|
店舗ID |
|
| name | varchar | 100 | √ | null |
|
|
店舗名 |
|
| valid_from | timestamp | 29,6 | null |
|
|
開始日時 |
||
| valid_to | timestamp | 29,6 | null |
|
|
終了日時 |
||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
削除日時 |
|
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
作成日時 |
||
| updated_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
更新日時 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| store_pk | Primary key | Asc | store_id |
| store_valid_from_valid_to_index | Performance | Asc/Asc | valid_from + valid_to |