Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗ID |
||||
| rental_data_owner_type | enum('own', 'other') | 5 | null |
|
|
自社他社（own:自社, other:他社） |
||||
| convert_type | TINYINT UNSIGNED | 3 | null |
|
|
コンバート（0:指定なし、1:非掲載、2:掲載） |
||||
| kimaroom_ids | JSON | 1073741824 | null |
|
|
キマルーム店舗ID配列 |
||||
| moving_in_statuses | JSON | 1073741824 | null |
|
|
入居状況配列 |
||||
| search_kimaroom | TINYINT UNSIGNED | 3 | null |
|
|
キマルーム！流通物件(0:非対象、1:対象） |
||||
| suggestion_count | TINYINT UNSIGNED | 3 | 1 |
|
|
提案物件数 |
||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| store_suggestion_settings_store_id_foreign | Performance | Asc | store_id |
Relationships
Close relationships within degrees of separation
