Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_customer_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗別顧客ID |
||||
| contactable_type | VARCHAR | 255 | √ | null |
|
|
||||
| contactable_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| rental_type | enum('housing', 'parking', 'business') | 8 | √ | null |
|
|
物件種目 |
|||
| rental_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
キマRoom!物件ID |
|||
| rental_info | JSON | 1073741824 | √ | null |
|
|
キマRoom!物件情報JSON |
|||
| memo | 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 |
| contact_rentals_contactable_type_contactable_id_index | Performance | Asc/Asc | contactable_type + contactable_id |
| contact_rentals_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
