Subject Area Name
|
Definition
|
901 - Tables Added
|
Tables added since the last release.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
cntnr_snapshot
|
Container Snapshot
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
The automatically generated primary key of the cntnr_snapshot table.
|
bigint
|
|
|
cntnr_defn_id
|
Container Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
create_date
|
Create Date
|
The date that the Container Snapshot was created.
|
datetime
|
|
|
snapshot_status_name
|
Snapshot Status Name
|
The unique string identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
|
last_good_publ_date
|
Last Good Publish Date
|
|
datetime
|
|
snapshot_cfg_setting_val
|
Snapshot Configuration Setting Value
|
|
false
|
Configuration Setting Value is an association between the Configuration Setting entity and a container entity (i.e. User Profile, Role, and Definition). This association contains a distinct value for each of the intersection points between the two entities.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
cfg_setting_val_id
|
Configuration Setting Value Id
|
The automatically generated primary key of the snapshot_cfg_setting_val table.
|
bigint
|
|
|
cfg_setting_id
|
Configuration Setting Id
|
A Foreign Key to the Snapshot Configuration Setting Value table.
|
bigint
|
|
|
val_type_cd
|
Value Type Code
|
The data type for a Snapshot Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer.
|
char(1)
|
|
|
string_val
|
String Value
|
The value of a Snapshot Configuration Setting Value, stored as a string.
|
varchar(255)
|
|
|
text_val
|
Text Value
|
The value of a Snapshot Configuration Setting Value, stored as a long text object.
|
varchar(max)
|
|
|
real_val
|
Real Value
|
The value of a Configuration Setting Value stored as a real.
|
numeric(38,20)
|
|
|
long_val
|
Long Value
|
The value of a Configuration Setting Value stored as Long.
|
bigint
|
|
|
date_val
|
Date Value
|
The value of a Snapshot Configuration Setting Value, stored as a date.
|
datetime
|
|
|
boolean_val
|
Boolean Value
|
The value of a Configuration Setting Value stored as Boolean.
|
bit
|
|
|
int_val
|
Int Value
|
The value of a Configuration Setting Value stored as Int.
|
int
|
|
|
owner_id
|
Owner Id
|
A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables.
|
bigint
|
|
|
val_map_key
|
Value Map Key
|
The value of a Snapshot Configuration Setting Value, stored as a string.
|
varchar(255)
|
|
|
cfg_setting_owner_type_name
|
Configuration Setting Owner Type Name
|
The unique string identifier for an instance of Snapshot Configuration Setting Value. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
A Foreign Key to the Container Snapshot table.
|
bigint
|
|
snapshot_defn
|
Snapshot Definition
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
A Foreign Key to the Container Snapshot table.
|
bigint
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
defn_name
|
Definition Name
|
The name of the Snapshot Definition.
|
nvarchar(4000)
|
|
|
dsble_date
|
Disabled Date
|
The date that this instance of Snapshot Definition is logically deleted and disabled.
|
datetime
|
|
|
defn_guid
|
Definition GUID
|
A Global Unique IDentifier search key for the Snapshot Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
|
defn_type_name
|
Definition Type Name
|
The unique string identifier for an instance of Snapshot Definition. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
|
defn_subtype_id
|
Definition Subtype Id
|
A Foreign Key to the Snapshot Definition table.
|
int
|
|
|
tmpl_export_guid
|
Template Export GUID
|
The value of a Snapshot Definition, stored as a string.
|
VARCHAR(50)
|
|
snapshot_defn_reln
|
Snapshot Definition Relationship
|
|
false
|
All relationships between definitions are stored in this table in order to make the model able to handle new relationships without changes to tables.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_reln_id
|
Definition Relationship Id
|
The automatically generated primary key of the snapshot_definition_relationsh table.
|
bigint
|
|
|
from_defn_ver_id
|
From Definition Version Id
|
A Foreign Key to the Snapshot Definition Relationship table.
|
bigint
|
|
|
to_defn_ver_id
|
To Definition Version Id
|
A Foreign Key to the Snapshot Definition Relationship table.
|
bigint
|
|
|
defn_reln_type_id
|
Definition Relationship Type Id
|
A Foreign Key to the Snapshot Definition Relationship table.
|
int
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
A Foreign Key to the Container Snapshot table.
|
bigint
|
|
snapshot_defn_ver
|
Snapshot Definition Version
|
|
false
|
A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Snapshot Definition Version table.
|
bigint
|
|
|
defn_ver_id
|
Definition Version Id
|
The automatically generated primary key of the snapshot_definition_version table.
|
bigint
|
|
|
defn_ver_name
|
Definition Version Name
|
The name of the Snapshot Definition Version.
|
varchar(255)
|
|
|
defn_ver_status_id
|
Definition Version Status Id
|
A Foreign Key to the Snapshot Definition Version table.
|
int
|
|
|
defn_ver_guid
|
Definition Version GUID
|
A Global Unique IDentifier search key for the Snapshot Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
A Foreign Key to the Container Snapshot table.
|
bigint
|
|
snapshot_defn_ver_assoc
|
Snapshot Definition Version Assoc
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_ver_association_id
|
Definition Version Association Id
|
The automatically generated primary key of the snapshot_definition_version_as table.
|
bigint
|
|
|
from_defn_ver_id
|
From Definition Version ID
|
A Foreign Key to the Snapshot Definition Version Assoc table.
|
bigint
|
|
|
to_defn_ver_id
|
To Definition Version ID
|
A Foreign Key to the Snapshot Definition Version Assoc table.
|
bigint
|
|
|
association_type_id
|
Association Type Id
|
A Foreign Key to the Snapshot Definition Version Assoc table.
|
bigint
|
|
|
cntnr_snapshot_id
|
Container Snapshot Id
|
A Foreign Key to the Container Snapshot table.
|
bigint
|
|
snapshot_status
|
Snapshot Status
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
snapshot_status_id
|
Snapshot Status Id
|
The unique identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
integer
|
|
|
snapshot_status_name
|
Snapshot Status Name
|
The unique string identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
snapshot_type
|
Snapshot Type
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
snapshot_type_id
|
Snapshot Type Id
|
The unique identifier for an instance of Snapshot Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
integer
|
|
|
snapshot_type_name
|
Snapshot Type Name
|
The unique string identifier for an instance of Snapshot Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|