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