advertising_media

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
inquiries.advertising_media_id inquiries_advertising_media_id_foreignR
inquiry_definitions.advertising_medium_id inquiry_definitions_advertising_medium_id_foreignR
company_id BIGINT UNSIGNED 20 null
companies.id advertising_media_company_id_foreignR

会社ID
name VARCHAR 50 null

媒体名
display_order_num SMALLINT UNSIGNED 5 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
advertising_media_company_id_foreign Performance Asc company_id

Relationships

Close relationships within degrees of separation