|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
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)
|
|
|
|
|
source
|
varchar(50)
|
|
|
|
|
type
|
varchar(255)
|
|
|
personal
|
|
oauth_connection_id
|
char(36)
|
|
|
|
|
username
|
varchar(255)
|
|
|
|
|
password
|
varchar(255)
|
|
|
|
|
server_url
|
varchar(500)
|
|
|
|
|
api_key
|
varchar(255)
|
|
|
|
|
api_endpoint
|
varchar(500)
|
|
|
|
|
calendar_user_id
|
char(36)
|
|
|
|
|
last_connection_status
|
tinyint(1)
|
|
|
0
|
|
last_connection_test
|
datetime
|
|
|
|
|
last_sync_attempt_date
|
datetime
|
|
|
|
|
last_sync_attempt_status
|
varchar(20)
|
|
|
|
|
last_sync_attempt_message
|
varchar(50)
|
|
|
|
|
last_sync_date
|
datetime
|
|
|
|
|
external_calendar_id
|
varchar(255)
|
|
|
|