Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| analysis_summary_record_id | BIGINT UNSIGNED | 20 | null |
|
|
レコードID |
||||
| company_addition_item_option_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
ID |
|||
| is_addition_item_option_exists | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| field_name1 | VARCHAR | 255 |
|
|
field_name1 |
|||||
| field_name2 | VARCHAR | 255 |
|
|
field_name2 |
|||||
| value | INT | 10 | 0 |
|
|
集計結果 |
||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| analysis_summary_field_unique | Must be unique | Asc/Asc/Asc/Asc | analysis_summary_record_id + is_addition_item_option_exists + field_name1 + field_name2 |
| analysis_summary_fields_company_addition_item_option_id_foreign | Performance | Asc | company_addition_item_option_id |
Relationships
Close relationships within degrees of separation
