inquiries

228 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
customer_interaction_histories.inquiry_id customer_interaction_histories_inquiry_id_foreignR
inquiry_rentals.inquiry_id inquiry_rentals_inquiry_id_foreignC

PK
store_customer_id BIGINT UNSIGNED 20 null
store_customers.id inquiries_store_customer_id_foreignR

店舗別顧客ID
advertising_media_id BIGINT UNSIGNED 20 √ null
advertising_media.id inquiries_advertising_media_id_foreignR

反響媒体ID
inquiry_items JSON 1073741824 null

問い合わせ項目
inquiry_text LONGTEXT 2147483647 null

問い合わせ内容
customer_name VARCHAR 255

お客様 氏名
customer_name_kana VARCHAR 255

お客様 氏名(カナ)
customer_email VARCHAR 255

お客様 メールアドレス
customer_tel VARCHAR 255

お客様 電話番号
customer_fax VARCHAR 255

お客様 FAX番号
customer_gender enum('male', 'female', 'unknown') 7 unknown

お客様 性別
customer_zip VARCHAR 255

お客様 郵便番号
customer_address VARCHAR 255

お客様 住所
preferred_contact_time VARCHAR 255

希望連絡時間帯
aspiring_school_1 VARCHAR 255

第一志望校
aspiring_school_2 VARCHAR 255

第二志望校
aspiring_school_3 VARCHAR 255

第三志望校
preferred_move_in_date VARCHAR 255

入居希望時期
preferred_rent_fee VARCHAR 255

希望賃料
preferred_floor_plan VARCHAR 255

希望間取り
full_text LONGTEXT 2147483647 null

問い合わせ内容全文
registration_route enum('api', 'mail', 'manual', 'line') 6 null

反響登録経路
inquired_at TIMESTAMP 26 √ null

反響日時
viewed_at TIMESTAMP 26 √ null

内覧日時
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
inquiries_advertising_media_id_foreign Performance Asc advertising_media_id
inquiries_store_customer_id_foreign Performance Asc store_customer_id

Relationships

Close relationships within degrees of separation