Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| customer_id | BIGINT UNSIGNED | 20 | null |
|
|
顧客ID |
||||
| company_addition_item_id | BIGINT UNSIGNED | 20 | null |
|
|
追加項目ID |
||||
| company_addition_item_option_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
追加項目の選択肢ID |
|||
| content | TEXT | 65535 | null |
|
|
入力値（テキスト、テキストエリア） |
||||
| content_multi | JSON | 1073741824 | null |
|
|
入力値（複数） |
||||
| schedule | TIMESTAMP | 26 | √ | null |
|
|
入力値（日程） |
|||
| period_start | TIMESTAMP | 26 | √ | null |
|
|
入力値（期間/開始） |
|||
| period_end | TIMESTAMP | 26 | √ | 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 |
| customer_addition_item_values_company_addition_item_id_foreign | Performance | Asc | company_addition_item_id |
| customer_addition_item_values_customer_id_foreign | Performance | Asc | customer_id |
Relationships
Close relationships within degrees of separation
