Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_customer_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗顧客ID |
||||
| rental_type | enum('housing', 'parking', 'business') | 8 | null |
|
|
物件タイプ |
||||
| kimaroom_rental_id | BIGINT UNSIGNED | 20 | null |
|
|
物件ID |
||||
| kimaroom_office_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗ID |
||||
| kimaroom_building_id | BIGINT UNSIGNED | 20 | null |
|
|
建物ID |
||||
| latitude | DECIMAL | 9,6 | null |
|
|
緯度 |
||||
| longitude | DECIMAL | 9,6 | null |
|
|
経度 |
||||
| distance | DECIMAL | 17,15 | null |
|
|
反響物件との距離 |
||||
| address | VARCHAR | 255 | null |
|
|
物件住所 |
||||
| update_time | DATETIME | 26 | null |
|
|
物件更新日時 |
||||
| is_suggested | BIT | 1 | 0 |
|
|
提案済 |
||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| auto_suggestions_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
