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