Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| event_trigger | VARCHAR | 255 | null |
|
|
記録された出来事の種類 |
||
| company_id | BIGINT UNSIGNED | 20 | null |
|
|
会社ID |
||
| customer_id | BIGINT UNSIGNED | 20 | null |
|
|
顧客ID |
||
| store_id | BIGINT UNSIGNED | 20 | null |
|
|
件数を計上する店舗ID |
||
| record_type | enum('inquiry', 'complete', 'lost') | 8 | null |
|
|
反響 or 決定 or 他決 |
||
| record_number | TINYINT | 3 | null |
|
|
件数を計上する数 |
||
| recorded_at | TIMESTAMP | 26 | null |
|
|
件数を計上する日時 |
||
| recorded_date | DATE | 10 | √ | 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 |
Diagram producer might be missing
No diagrams were produced please see application output for any errors