company_addition_item_options

364 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
analysis_summary_fields.company_addition_item_option_id analysis_summary_fields_company_addition_item_option_id_foreignR
company_addition_item_id BIGINT UNSIGNED 20 null
company_addition_items.id company_addition_item_options_company_addition_item_id_foreignC

追加項目ID
is_with_text BIT 1 0

テキストボックス有無フラグ
value VARCHAR 255

選択肢
sort INT 10 0

並び順
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
company_addition_item_options_company_addition_item_id_foreign Performance Asc company_addition_item_id

Relationships

Close relationships within degrees of separation