Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_customer_id | BIGINT UNSIGNED | 20 | null |
|
|
店舗別顧客ID |
||||
| favoritable_type | VARCHAR | 255 | √ | null |
|
|
||||
| favoritable_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 |
|
|
メモ |
|||
| favorited_at | TIMESTAMP | 26 | √ | 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 |
| favorite_rentals_favoritable_type_favoritable_id_index | Performance | Asc/Asc | favoritable_type + favoritable_id |
| favorite_rentals_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
