analysis_summaries

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
analysis_summary_records.analysis_summary_id analysis_summary_records_analysis_summary_id_foreignR
company_analysis_config_id BIGINT UNSIGNED 20 null
company_analysis_configs.id analysis_summaries_company_analysis_config_id_foreignR

集計設定ID
store_id BIGINT UNSIGNED 20 null
stores.id analysis_summaries_store_id_foreignR

店舗ID
deleted_at TIMESTAMP 26 √ null
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analysis_summaries_company_analysis_config_id_store_id_unique Must be unique Asc/Asc company_analysis_config_id + store_id
analysis_summaries_store_id_foreign Performance Asc store_id

Relationships

Close relationships within degrees of separation