allotment

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
channel_id int4 10 null
channel.id fk_allotment_channel_id C
roomtype_id int4 10 null
room_type.id fk_allotment_roomtype_id C
allot_date date 13 null
allot_qty int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_allotment Primary key Asc/Asc/Asc channel_id + roomtype_id + allot_date
allotment_channel_id_idx Performance Asc channel_id
allotment_roomtype_id_idx Performance Asc roomtype_id

Relationships

Close relationships within degrees of separation