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