| id |
char |
36 |
|
|
|
| notes.parent_id
|
Defined in XML R |
|
|
| name |
varchar |
50 |
√ |
|
null |
|
|
| date_entered |
datetime |
19 |
√ |
|
null |
|
|
| date_modified |
datetime |
19 |
√ |
|
null |
|
|
| modified_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| created_by |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| description |
text |
65535 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| team_id |
char |
36 |
√ |
|
null |
|
| teams.id
|
Defined in XML R |
|
| team_set_id |
char |
36 |
√ |
|
null |
|
|
| duration_hours |
int |
2 |
√ |
|
null |
|
|
| duration_minutes |
int |
2 |
√ |
|
null |
|
|
| date_start |
datetime |
19 |
√ |
|
null |
|
|
| date_end |
datetime |
19 |
√ |
|
null |
|
|
| parent_type |
varchar |
255 |
√ |
|
null |
|
|
| status |
varchar |
100 |
√ |
|
Planned |
|
|
| direction |
varchar |
100 |
√ |
|
null |
|
|
| parent_id |
char |
36 |
√ |
|
null |
|
|
| reminder_time |
int |
11 |
√ |
|
-1 |
|
|
| email_reminder_time |
int |
11 |
√ |
|
-1 |
|
|
| email_reminder_sent |
bit |
1 |
√ |
|
0 |
|
|
| outlook_id |
varchar |
255 |
√ |
|
null |
|
|
| repeat_type |
varchar |
36 |
√ |
|
null |
|
|
| repeat_interval |
int |
3 |
√ |
|
1 |
|
|
| repeat_dow |
varchar |
7 |
√ |
|
null |
|
|
| repeat_until |
date |
10 |
√ |
|
null |
|
|
| repeat_count |
int |
7 |
√ |
|
null |
|
|
| repeat_parent_id |
char |
36 |
√ |
|
null |
|
|
| recurring_source |
varchar |
36 |
√ |
|
null |
|
|
