site
- Last UpdatedNov 20, 2024
- 1 minute read
The site table defines the time zone region and other information for a site. When entities belong to a site, the site's time zone is used to convert between UTC and local time.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
Entity ID of the site entity |
|
site_name |
string80 |
N |
Y |
Name of this site – usually equivalent to ent_name for the site but included here for convenience in that case Note: This field is currently not used. |
|
corporation |
string40 |
N |
Y |
The corporation to which this site belongs Note: This field is currently not used. |
|
division |
string40 |
N |
Y |
The division within the corporation to which this site belongs Note: This field is currently not used. |
|
sub_division |
string40 |
N |
Y |
The sub-division within this division of the corporation to which this site belongs Note: This field is currently not used. |
|
region_id |
string80 |
N |
N |
The time zone ID of this site as provided by Windows. For example, Eastern Standard Time, Pacific Standard Time. Used to convert child entity UTC and local times as well as for generating an entity's shift history records. |
|
spare1 |
string40 |
N |
Y |
Spare field |
|
spare2 |
string40 |
N |
Y |
Spare field |
|
spare3 |
string40 |
N |
Y |
Spare field |
|
spare4 |
string40 |
N |
Y |
Spare field |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail |
FK from ent_id to ent. (Cascade delete)