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 |