rsv_pickup

2856 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
date_ref date 13 null
status text 2147483647 'NEW'::text
booking_id int4 10 null
booking_item int4 10 null
roomtype_id int4 10 √ null
room_type.id fk_rsv_pickup_roomtype_id N
bedtype_id int4 10 √ null
bed_type.id fk_rsv_pickup_bedtype_id N
book_type bpchar 1 √ null
house_used bool 1 √ false
comp bool 1 √ false
day_used bool 1 √ false
rateplan_id int4 10 √ null
rate_plan.id fk_rsv_pickup_rateplan_id N
mealtype_id int4 10 √ null
meal_type.id fk_rsv_pickup_mealtype_id N
stay_type bpchar 1 √ null
arrival date 13 √ null
departure date 13 √ null
adult int2 5 √ 0
child int2 5 √ 0
infant int2 5 √ 0
extra_adult int2 5 √ 0
extra_child int2 5 √ 0
extra_infant int2 5 √ 0
room_rate t_money 15,2 √ null
extra_adult_rate t_money 15,2 √ null
extra_child_rate t_money 15,2 √ null
extra_infant_rate t_money 15,2 √ null
room_charge t_money 15,2 √ null
extra_charge t_money 15,2 √ null
other_charge t_money 15,2 √ null
total_charge t_money 15,2 √ null
promotion_id int4 10 √ null
promotion.id fk_rsv_pickup_promotion_id N
channel_id int4 10 √ null
channel.id fk_rsv_pickup_channel_id N
origin_id int4 10 √ null
origin.id fk_rsv_pickup_origin_id N
sales_id int4 10 √ null
sales_staff.id fk_rsv_pickup_sales_id N
market_id int4 10 √ null
market.id fk_rsv_pickup_market_id N
rsvtype_id int4 10 √ null
reservation_type.id fk_rsv_pickup_rsvtype_id N
lead_time int4 10 √ 0
return_guest bool 1 √ false
guest_id int4 10 √ null
guest_sex bpchar 1 √ null
guest_age int4 10 √ null
guest_nation_id int4 10 √ null
nationality.id fk_rsv_pickup_guest_nation_id N
guest_lang_id int4 10 √ null
language.id fk_rsv_pickup_guest_lang_id N
guest_country_id int4 10 √ null
country.id fk_rsv_pickup_guest_country_id N
guest_country_res_id int4 10 √ null
country.id fk_rsv_pickup_guest_country_res_id N
guest_city_id int4 10 √ null
city.id fk_rsv_pickup_guest_city_id N
guest_occupation_id int4 10 √ null
occupation.id fk_rsv_pickup_guest_occupation_id N
guest_vip_id int4 10 √ null
vip.id fk_rsv_pickup_guest_vip_id N
guest_name text 2147483647 √ null
guest_member_code text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_rsv_pickup Primary key Asc id
idx_rsv_pickup_bedtype_id Performance Asc bedtype_id
idx_rsv_pickup_channel_id Performance Asc channel_id
idx_rsv_pickup_date_ref Performance Asc date_ref
idx_rsv_pickup_guest_city_id Performance Asc guest_city_id
idx_rsv_pickup_guest_country_id Performance Asc guest_country_id
idx_rsv_pickup_guest_country_res_id Performance Asc guest_country_res_id
idx_rsv_pickup_guest_lang_id Performance Asc guest_lang_id
idx_rsv_pickup_guest_nation_id Performance Asc guest_nation_id
idx_rsv_pickup_guest_occupation_id Performance Asc guest_occupation_id
idx_rsv_pickup_guest_vip_id Performance Asc guest_vip_id
idx_rsv_pickup_market_id Performance Asc market_id
idx_rsv_pickup_mealtype_id Performance Asc mealtype_id
idx_rsv_pickup_origin_id Performance Asc origin_id
idx_rsv_pickup_promotion_id Performance Asc promotion_id
idx_rsv_pickup_rateplan_id Performance Asc rateplan_id
idx_rsv_pickup_roomtype_id Performance Asc roomtype_id
idx_rsv_pickup_rsvtype_id Performance Asc rsvtype_id
idx_rsv_pickup_sales_id Performance Asc sales_id
idx_rsv_pickup_status Performance Asc status
unq_rsv_pickup Must be unique Asc/Asc date_ref + booking_item

Relationships

Close relationships within degrees of separation