hold_groups_target_holds

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
hold_group_id INT UNSIGNED 10 null
hold_groups.hold_group_id hold_group_target_holds_ibfk_1 C

foreign key, linking this to the hold_groups table
reserve_id INT 10 null
reserves.reserve_id hold_group_target_holds_ibfk_2 C

foreign key, linking this to the reserves table

Indexes

Constraint Name Type Sort Column(s)
hold_groups_target_holds_s_pk Primary key Asc/Asc hold_group_id + reserve_id
PRIMARY Must be unique Asc/Asc hold_group_id + reserve_id
uq_hold_group_target_holds_hold_group_id Must be unique Asc hold_group_id
uq_hold_group_target_holds_reserve_id Must be unique Asc reserve_id

Relationships

Close relationships within degrees of separation