Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_id | BIGINT UNSIGNED | 20 | null |
|
|
|||||
| enable_visit_reservation | BIT | 1 | 0 |
|
|
|||||
| enable_service | JSON | 1073741824 | null |
|
|
|||||
| business_time_from | TIME | 16 | null |
|
|
受付日時from |
||||
| business_time_to | TIME | 16 | null |
|
|
受付日時to |
||||
| closed_times | JSON | 1073741824 | null |
|
|
受付不可時間 |
||||
| holidays | JSON | 1073741824 | null |
|
|
定休日 |
||||
| enable_reserve_limit | BIT | 1 | null |
|
|
|||||
| JSON | 1073741824 | null |
|
|
受付不可日 |
|||||
| BIT | 1 | null |
|
|
||||||
| enable_store_information | BIT | 1 | null |
|
|
|||||
| store_information | TEXT | 65535 | null |
|
|
店舗のお知らせ |
||||
| enable_approve_auto_message | BIT | 1 | null |
|
|
|||||
| approve_auto_message | TEXT | 65535 | null |
|
|
予約確定時メッセージ |
||||
| enable_auto_message_3days_ago | BIT | 1 | null |
|
|
|||||
| auto_message_send_time_3days_ago | TIME | 16 | null |
|
|
|||||
| auto_message_3days_ago | TEXT | 65535 | null |
|
|
|||||
| enable_auto_message_1day_ago | BIT | 1 | null |
|
|
|||||
| auto_message_send_time_1day_ago | TIME | 16 | null |
|
|
|||||
| auto_message_1day_ago | TEXT | 65535 | null |
|
|
|||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| deleted_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| visit_reservation_settings_store_id_foreign | Performance | Asc | store_id |
Relationships
Close relationships within degrees of separation
