| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| created_by |
char(36)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| assigned_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| location |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| join_url |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| host_url |
varchar(400)
|
utf8mb4_general_ci
|
|
|
| displayed_url |
varchar(400)
|
utf8mb4_general_ci
|
|
|
| creator |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| external_id |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| duration_hours |
int(3)
|
|
|
|
| duration_minutes |
int(2)
|
|
|
|
| date_start |
datetime
|
|
|
|
| date_end |
datetime
|
|
|
|
| parent_type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| type |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| parent_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| reminder_time |
int(11)
|
|
|
|
| email_reminder_time |
int(11)
|
|
|
|
| email_reminder_sent |
tinyint(1)
|
|
|
|
| outlook_id |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| sequence |
int(11)
|
|
|
|
| repeat_type |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| repeat_interval |
int(3)
|
|
|
|
| repeat_dow |
varchar(7)
|
utf8mb4_general_ci
|
|
|
| repeat_until |
date
|
|
|
|
| repeat_count |
int(7)
|
|
|
|
| repeat_parent_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| recurring_source |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| gsync_id |
varchar(1024)
|
utf8mb4_general_ci
|
|
|
| gsync_lastsync |
int(11)
|
|
|
|
