Footprints Data Model

Table
Name defn
Comment A definition is the supertype table that holds the structural and behaviaral information needed for an application element that is configuarable by the system designer and/or the end user. All of the metadata that is published is here. FootPrints 11 uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints 12+ provides all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. A lot of important information about the definition will be stored as associated Configuration Settings. See the database views v_defn_ver_active, v_cntnr_item_field.

Column
Name Datatype Comment Is PK Is FK
defn_id bigint The automatically generated primary key of the defn table. Yes No
defn_name varchar(255) The name of the Definition. No No
dsble_date datetime The date that this instance of Definition is logically deleted and disabled. No No
defn_guid varchar(50) 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. No No
defn_type_name varchar(255) The name of the Definition Type. No Yes
defn_subtype_id int A Foreign Key to the Definition Subtype table. No Yes
tmpl_export_guid VARCHAR(50) The value of a Definition, stored as a string. No No