| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| date_start |
Date+Time of the beginning |
date |
Required |
| date_end |
Date+Time of the end |
date |
Required |
| user_unavailability_type_id | globally unique identifier | ||
| user_unavailability_type_name | string | ||
| description |
Description |
string |
Max length: 255 |
| sys_logical_delete |
Logical delete |
boolean | |
| user_id |
Assigned user |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| is_approved |
is_approved |
boolean | |
| user_week_approval_id |
user_week_approval_id |
globally unique identifier | |
| db_address_id |
db_address_id |
globally unique identifier | |
| location |
location |
string |
Max length: 50 |
| holiday_id |
holiday_id |
globally unique identifier | |
| archive_reason |
archive_reason |
string |
Max length: 4000 |
| recurrence_id |
recurrence_id |
globally unique identifier | |
| time_span |
time_span |
string |
Max length: 255 |
| dateutc_create |
dateutc_create |
date | |
| is_confirmed |
comfirmed by the user |
boolean |