suggestions

237 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
suggestion_rental_details.suggestion_id suggestion_rental_details_suggestion_id_foreignR

PK
store_customer_id BIGINT UNSIGNED 20 null
store_customers.id suggestions_store_customer_id_foreignR

店舗別顧客ID
staff_id BIGINT UNSIGNED 20 √ null
staffs.id suggestions_staff_id_foreignR

提案担当者ID
rental_id VARCHAR 255
job_batches.id Implied ConstraintR

kimaroomの物件管理番号
media_rental_id VARCHAR 255
job_batches.id Implied ConstraintR

コンバート先の物件管理番号
rental_type enum('housing', 'parking', 'business') 8 √ null

物件種目
registration_route enum('mail', 'manual', 'auto_suggestion') 15 null

提案登録経路
name VARCHAR 255

物件名
fee INT 10 0

賃料(単位:円)
occupied_area VARCHAR 255

専有・建物面積
url VARCHAR 255

物件URL
content TEXT 65535 null

内容
memo TEXT 65535 null

メモ
message_id BIGINT UNSIGNED 20 √ null
messages.id suggestions_message_id_foreignR

送信メールID
access_count_url_id BIGINT UNSIGNED 20 √ null
access_count_urls.id suggestions_access_count_url_id_foreignR

アクセスカウントURLのID
last_access_time TIMESTAMP 26 √ null

最終閲覧日時
access_count INT UNSIGNED 10 0

閲覧回数
suggested_at TIMESTAMP 26 √ null

提案日時
viewed_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
suggestions_access_count_url_id_foreign Performance Asc access_count_url_id
suggestions_message_id_foreign Performance Asc message_id
suggestions_registration_route_index Performance Asc registration_route
suggestions_staff_id_foreign Performance Asc staff_id
suggestions_store_customer_id_foreign Performance Asc store_customer_id
suggestions_suggested_at_deleted_at_index Performance Asc/Asc suggested_at + deleted_at

Relationships

Close relationships within degrees of separation