booking_items

16613 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
booking_id int4 10 null
booking.id fk_booking_items_booking_id C
booking_seq int4 10 null
rateplan_id int4 10 null
rate_plan.id fk_booking_items_rateplan_id R
roomtype_id int4 10 null
room_type.id fk_booking_items_roomtype_id R
bedtype_id int4 10 √ null
bed_type.id fk_booking_items_bedtype_id N
arrival date 13 null
departure date 13 null
qty int2 5 null
adult int2 5 2
child int2 5 0
infant int2 5 0
allot_qty int2 5 √ 0
block_qty int2 5 0
inhouse_qty int2 5 0
charge_to bpchar 1 'B'::bpchar
extra_adult int2 5 0
extra_child int2 5 0
extra_infant int2 5 0
no_amend bool 1 √ false
no_cancel bool 1 √ false
no_refund bool 1 √ false
room_numbers text 2147483647 √ null
rate_id int4 10 √ null
rate_details.rate_id fk_booking_items_rate_id N
item_id int4 10 √ null
booking_rates.booking_item fk_booking_rates_booking_items C
guest_request.booking_item fk_guest_request_booking_item C
registration.booking_item fk_registration_booking_items R
room_block.booking_item fk_room_block_booking_items C
rooms _text 2147483647 √ null
promotion_id int4 10 √ null
promotion.id fk_booking_items_promotion_id N
noshow_qty int2 5 0
pax text 2147483647 √ fn_pax((adult + extra_adult), (child + extra_child), (infant + extra_infant))
mealtype_id int4 10 √ null
meal_type.id fk_booking_items_mealtype_id R
included_adult int2 5 √ (adult - extra_adult)
included_child int2 5 √ (child - extra_child)
included_infant int2 5 √ (infant - extra_infant)
room_charge t_money 15,2 √ null
other_charge t_money 15,2 √ null
extra_charge t_money 15,2 √ null
total_charge t_money 15,2 √ ((COALESCE((room_charge)::numeric, (0)::numeric) + COALESCE((other_charge)::numeric, (0)::numeric)) + COALESCE((extra_charge)::numeric, (0)::numeric))

Indexes

Constraint Name Type Sort Column(s)
pk_booking_items Primary key Asc item_id
idx_booking_items_bedtype_id Performance Asc bedtype_id
idx_booking_items_booking_id Performance Asc booking_id
idx_booking_items_mealtype_id Performance Asc mealtype_id
idx_booking_items_promotion_id Performance Asc promotion_id
idx_booking_items_rateplan_id Performance Asc rateplan_id
idx_booking_items_roomtype_id Performance Asc roomtype_id
unq_booking_items Must be unique Asc/Asc booking_id + booking_seq

Relationships

Close relationships within degrees of separation