inquiry_definitions

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
inquiry_definition_items.inquiry_definition_id inquiry_definition_items_inquiry_definition_id_foreignR
inquiry_definition_sorting_rules.inquiry_definition_id inquiry_definition_sorting_rules_inquiry_definition_id_foreignR
company_id BIGINT UNSIGNED 20 null
companies.id inquiry_definitions_company_id_foreignR

会社ID
advertising_medium_id BIGINT UNSIGNED 20 √ null
advertising_media.id inquiry_definitions_advertising_medium_id_foreignR

反響媒体ID
name VARCHAR 255 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
inquiry_definitions_advertising_medium_id_foreign Performance Asc advertising_medium_id
inquiry_definitions_company_id_foreign Performance Asc company_id

Relationships

Close relationships within degrees of separation