inquiries

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null

問い合わせID
inquiry_type INT 10 null
inquiry_types.type inquiries_ibfk_3R

問い合わせ種別ID
company_name VARCHAR 100 null

会社名
name VARCHAR 100 null

名前
department INT 10 null
inquiry_company_departments.department inquiries_ibfk_1R

部署ID
position INT 10 null
inquiry_company_positions.position inquiries_ibfk_2R

役職ID
phone_number VARCHAR 15 null

電話番号
email VARCHAR 100 null

メールアドレス
reason_for_contact TEXT 65535 √ null

問い合わせ内容
reason_for_experiencing_ai_coaching TEXT 65535 √ null

AIコーチングを体験したい理由
created_at BIGINT UNSIGNED 20 unix_timestamp(now())

作成日(unixTimes)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
department Performance Asc department
inquiry_type Performance Asc inquiry_type
position Performance Asc position

Relationships

Close relationships within degrees of separation