| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| company_id |
Company Id |
globally unique identifier | |
| user_id |
User Id |
globally unique identifier | |
| is_temp_link |
Check temp link |
boolean | |
| created_for_jobs_id |
Foreign key of the job (work order) this temp link was created for |
globally unique identifier | |
| root_project_id |
Root location of the job this temp link was created for, derived at read time (not stored) |
globally unique identifier | |
| sys_logical_delete |
Check delete |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |