registration

12123 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
bill.register_id bill_register_id_fkey N
attachment.register_id fk_attachment_register_id C
booking_guests.register_id fk_booking_guests_register_id N
charge_schedule.register_id fk_charge_schedule_register_id C
deposit.register_id fk_deposit_register_id N
folio.register_id fk_folio_register_id C
guest_consent_logs.registration_id fk_consent_log_registration C
guest_messages.register_id fk_guest_messages_register_id C
guest_request.register_id fk_guest_request_register_id C
guest_signature.register_id guest_signature_register_id_fkey C
intf_keycard_logs.register_id intf_room_register_id_fk C
register_guests.register_id fk_register_guests_register_id C
registration.join_register_id fk_registration_join_register_id R
registration.shared_register_id fk_registration_shared_register_id R
registration_rates.register_id fk_registration_rates_register_id C
room_block.register_id fk_room_block_register_id N
wakeup_call.register_id wakeup_call_register_id_fkey C
status bpchar 1 √ 'I'::bpchar

I = In-house O = Checked out X = Cancel check-in
booking_id int4 10 √ null
booking_item int4 10 √ null
booking_items.item_id fk_registration_booking_items R
room_id int4 10 √ null
room.id fk_registration_room_id R
guest_id int4 10 √ null
guest.id fk_registration_guest_id R
group_id int4 10 √ null
group_info.id fk_registration_group_id R
arrival date 13 null
departure date 13 null
departure_time time 15,6 √ null
walk_in bool 1 false
adult int2 5 2
child int2 5 0
infant int2 5 0
extra_adult int2 5 0
extra_child int2 5 0
extra_infant int2 5 0
approved bool 1 false
approve_user citext 2147483647 √ null
approve_time timestamptz 35,6 √ null
checkin_user citext 2147483647 √ null
checkin_time timestamptz 35,6 √ CURRENT_TIMESTAMP
checkout_user citext 2147483647 √ null
checkout_time timestamptz 35,6 √ null
member_code citext 2147483647 √ null
channel_id int4 10 √ null
channel.id fk_registration_channel_id R
origin_id int4 10 √ null
origin.id fk_registration_origin_id R
arrive_by text 2147483647 √ null
arrive_from text 2147483647 √ null
depart_by text 2147483647 √ null
depart_to text 2147483647 √ null
folio_pattern_id int4 10 √ null
folio_pattern.id fk_registration_folpat_id R
voucher_no citext 2147483647 √ null
promo_code citext 2147483647 √ null
payment_method bpchar 3 √ null
sales_id int4 10 √ null
sales_staff.id fk_registration_sales_id N
market_id int4 10 √ null
market.id fk_registration_market_id N
stay_type bpchar 1 √ 'D'::bpchar
folio_id int4 10 √ null
credit_limit t_money 15,2 √ null
note text 2147483647 √ null
accno int4 10 √ null
msg_count int4 10 √ 0
flag_count int4 10 √ 0
rateplan_id int4 10 √ null
rate_plan.id fk_registration_rateplan_id N
room_posted bool 1 false
charge_to_booking bool 1 false
promotion_id int4 10 √ null
promotion.id fk_registration_promotion_id N
rate_id int4 10 √ null
modify_user text 2147483647 √ null
modify_time timestamptz 35,6 √ null
house_used bool 1 false
shared_register_id int4 10 √ null
registration.id fk_registration_shared_register_id R
share_room bool 1 √ (shared_register_id IS NOT NULL)
day_used bool 1 √ (arrival = departure)
nights int2 5 √ (departure - arrival)
join_register_id int4 10 √ null
registration.id fk_registration_join_register_id R
is_join_room bool 1 √ (join_register_id IS NOT NULL)
is_group bool 1 √ (group_id IS NOT NULL)
early_checkout bool 1 false
rsvtype_id int4 10 √ null
reservation_type.id fk_registration_rsvtype_id R
early_checkout_date date 13 √ null
mealtype_id int4 10 √ null
meal_type.id fk_registration_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))
total_deposit t_money 15,2 √ null
pax text 2147483647 √ fn_pax(adult, child, infant)
share_rate bool 1 false
split_folio bool 1 false

Indexes

Constraint Name Type Sort Column(s)
pk_registration Primary key Asc id
idx_registration_booking_id Performance Asc booking_id
idx_registration_booking_item Performance Asc booking_item
idx_registration_channel_id Performance Asc channel_id
idx_registration_folpat_id Performance Asc folio_pattern_id
idx_registration_group_id Performance Asc group_id
idx_registration_guest_id Performance Asc guest_id
idx_registration_market_id Performance Asc market_id
idx_registration_mealtype_id Performance Asc mealtype_id
idx_registration_origin_id Performance Asc origin_id
idx_registration_promotion_id Performance Asc promotion_id
idx_registration_rate_id Performance Asc rate_id
idx_registration_rateplan_id Performance Asc rateplan_id
idx_registration_room_id Performance Asc room_id
idx_registration_rsvtype_id Performance Asc rsvtype_id
idx_registration_sales_id Performance Asc sales_id

Check Constraints

Constraint Name Constraint
check_registration_status ((status)::text = ANY (ARRAY['I'::text, 'O'::text, 'X'::text]))

Relationships

Close relationships within degrees of separation