Footprints Data Model

Table
Name defn_subtype
Comment 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.

Column
Name Datatype Comment Is PK Is FK
defn_subtype_id int The automatically generated primary key of the defn_subtype table. Yes No
defn_parent_subtype_id int A Foreign Key to the Definition Subtype table. No Yes
defn_subtype_name varchar(255) The name of the Definition Subtype. No No
defn_subtype_descr varchar(512) A descriptive name of the Definition Subtype. This descriptive name may be localized. No No
defn_type_name varchar(255) The name of the Definition Type. No Yes
max_in_parent int A Foreign Key to the Definition Subtype table. No No