Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| channel_name_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
チャンネル名 |
|||
| staff_id | BIGINT UNSIGNED | 20 | null |
|
|
担当者ID |
||||
| store_customer_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| passcode_flg | BIGINT UNSIGNED | 20 | √ | null |
|
|
入室コードフラグ |
|||
| passcode | VARCHAR | 255 | √ | null |
|
|
入室コード |
|||
| schedule_date | DATETIME | 26 | √ | null |
|
|
開始予定日 |
|||
| business_phase | enum('inquiry', 'visit', 'viewing', 'application', 'contract') | 11 | null |
|
|
業務フェーズ |
||||
| memo | VARCHAR | 255 | √ | null |
|
|
メモ |
|||
| meeting_id | VARCHAR | 255 | √ | null |
|
|
ミーティングID |
|||
| execution_date | DATETIME | 26 | √ | null |
|
|
実施日時 |
|||
| is_recording | BIT | 1 | 0 |
|
|
レコード中フラグ |
||||
| num | INT UNSIGNED | 10 | 0 |
|
|
参加人数 |
||||
| host_uids | TEXT | 65535 | √ | null |
|
|
ホストID |
|||
| agora_resource_id | TEXT | 65535 | √ | null |
|
|
録画用ID |
|||
| agora_sid | VARCHAR | 255 | 0 |
|
|
録画id |
||||
| record_start_time | DATETIME | 26 | √ | null |
|
|
録画開始日時 |
|||
| record_count | INT UNSIGNED | 10 | √ | 0 |
|
|
録画数 |
|||
| record_duration | BIGINT UNSIGNED | 20 | 0 |
|
|
録画時間合計（秒） |
||||
| 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 |
| web_meetings_staff_id_foreign | Performance | Asc | staff_id |
| web_meetings_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
