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 |