Stores site information.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(250)
|
false
|
|
Stores the name of the site
|
|
DESCRIPTION
|
nvarchar(max)
|
false
|
|
Stores the description of the site
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
HIERARCHYPATH
|
hierarchyid
|
false
|
([dbo].[UFN_SITEHIERARCHY_GETNEWDESCENDANTVALUE](NULL))
|
Stores the hierarchy path
|
|
SHORTNAME
|
nvarchar(100)
|
false
|
|
Stores the short name of the site
|
|
SITEID
|
nvarchar(100)
|
false
|
|
Stores the site id
|
|
ACRONYM
|
nvarchar(100)
|
false
|
|
Stores the acronym of the site
|
