bomitemgroup


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
bomitem.bomItemGroupId FKafig77wjhrxl0nhfvl3rwg42m R
bomId INT 10 null
bom.id FK95ddhpehxhlof0930en6q1qly R
name VARCHAR 70 null
prompt VARCHAR 256 √ null
sortOrder INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK95ddhpehxhlof0930en6q1qly Performance Asc bomId
UKr17l7pwyxwbfuv5f0cbwc2qh9 Must be unique Asc/Asc name + bomId

Relationships

Close relationships within degrees of separation