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