Footprints Data Model

Table
Table Name Definition
Table Definition A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Definition Id The automatically generated primary key of the defn table. LONG Yes
Definition Name The name of the Definition. VARCHAR(255) No
Disabled Date The date that this instance of Definition is logically deleted and disabled. DATE No
Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. VARCHAR(50) No
Definition Type Name The unique string identifier for an instance of Definition 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) Yes
Definition Subtype Id A Foreign Key to the Definition Subtype table. INTEGER No
Template Export GUID The value of a Definition, stored as a string. VARCHAR(255) No