Footprints Data Model

Table
Table Name Definition Subtype
Table Definition The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Definition Subtype Id The automatically generated primary key of the defn_subtype table. INTEGER Yes
definition parent subtype id A Foreign Key to the Definition Subtype table. INTEGER No
Definition Subtype Name The name of the Definition Subtype. VARCHAR(255) No
Definition Subtype Description A descriptive name of the Definition Subtype. This descriptive name may be localized. VARCHAR(512) 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) No
Maximum In Parent A Foreign Key to the Definition Subtype table. INTEGER No