site_item_subtype


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
site_item.site_item_subtype_id FKE031C90B633BB4FE R
name VARCHAR 40 null
site_item_type_id INT 10 null
site_item_type.id FK568862466D9E1076 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK568862466D9E1076 Performance Asc site_item_type_id
site_item_type_id Must be unique Asc/Asc site_item_type_id + name
unique_name Must be unique Asc/Asc site_item_type_id + name

Relationships

Close relationships within degrees of separation