| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| company_id |
Foreign key of the company this calendar entry belongs to. |
globally unique identifier | |
| company_calendar_type_id |
Foreign key of the type of calendar entry (e.g. closure, special hours). |
globally unique identifier | |
| date_start |
Date and time this calendar entry starts. |
date | |
| date_end |
Date and time this calendar entry ends. |
date | |
| description |
Free-text description of this calendar entry. |
string | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |