Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_customer_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗顧客ID |
||||
| is_available | BIT | 1 | null |
|
|
自動物件提案有効フラグ |
||||
| frequency | enum('daily', 'weekly') | 6 | null |
|
|
提案頻度 |
||||
| is_sunday | BIT | 1 | null |
|
|
提案曜日(日) |
||||
| is_monday | BIT | 1 | null |
|
|
提案曜日(月) |
||||
| is_tuesday | BIT | 1 | null |
|
|
提案曜日(火) |
||||
| is_wednesday | BIT | 1 | null |
|
|
提案曜日(水) |
||||
| is_thursday | BIT | 1 | null |
|
|
提案曜日(木) |
||||
| is_friday | BIT | 1 | null |
|
|
提案曜日(金) |
||||
| is_saturday | BIT | 1 | null |
|
|
提案曜日(土) |
||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| auto_suggestion_settings_is_available_index | Performance | Asc | is_available |
| auto_suggestion_settings_is_friday_index | Performance | Asc | is_friday |
| auto_suggestion_settings_is_monday_index | Performance | Asc | is_monday |
| auto_suggestion_settings_is_saturday_index | Performance | Asc | is_saturday |
| auto_suggestion_settings_is_sunday_index | Performance | Asc | is_sunday |
| auto_suggestion_settings_is_thursday_index | Performance | Asc | is_thursday |
| auto_suggestion_settings_is_tuesday_index | Performance | Asc | is_tuesday |
| auto_suggestion_settings_is_wednesday_index | Performance | Asc | is_wednesday |
| auto_suggestion_settings_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
