Constraints

217 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_tax_details_tax_code
tax_details.tax_code
tax.code
Cascade on delete
fk_tax_details_tax_item
tax_details.item_id
tax_item.id
Cascade on delete
fk_rates_rate_id
rate_daily.rate_id
rate_details.rate_id
Cascade on delete
fk_registration_rates_room_charge_dept
registration_rates.room_charge_dept
department.id
Null on delete
fk_registration_rates_mealtype_id
registration_rates.mealtype_id
meal_type.id
Restrict delete
fk_registration_rates_rateplan_id
registration_rates.rateplan_id
rate_plan.id
Restrict delete
fk_registration_rates_promotion_id
registration_rates.promotion_id
promotion.id
Null on delete
fk_registration_rates_register_id
registration_rates.register_id
registration.id
Cascade on delete
fk_registration_rates_tran_id
registration_rates.tran_id
transactions.id
Null on delete
fk_deposit_booking_id
deposit.booking_id
booking.id
Cascade on delete
fk_deposit_register_id
deposit.register_id
registration.id
Null on delete
fk_deposit_payment_type
deposit.payment_id
department.id
Restrict delete
fk_guest_request_register_id
guest_request.register_id
registration.id
Cascade on delete
fk_guest_request_booking_item
guest_request.booking_item
booking_items.item_id
Cascade on delete
fk_guest_request_inclusion_id
guest_request.inclusion_id
inclusion.id
Restrict delete
fk_guest_request_booking_id
guest_request.booking_id
booking.id
Cascade on delete
fk_guest_request_charge_dept
guest_request.charge_dept
department.id
Restrict delete
rate_channels_fk_1
rate_channels.rate_id
rate_details.rate_id
Cascade on delete
rate_channels_fk
rate_channels.channel_id
channel.id
Cascade on delete
inclusion_department_fk
inclusion.charge_dept
department.id
Restrict delete
inclusion_printform_fk
inclusion.printform_id
print_form.id
Restrict delete
fk_registration_origin_id
registration.origin_id
origin.id
Restrict delete
fk_registration_join_register_id
registration.join_register_id
registration.id
Restrict delete
fk_registration_folpat_id
registration.folio_pattern_id
folio_pattern.id
Restrict delete
fk_registration_group_id
registration.group_id
group_info.id
Restrict delete
fk_registration_rate_id
registration.rateplan_id
rate_plan.id
Null on delete
fk_registration_room_id
registration.room_id
room.id
Restrict delete
fk_registration_market_id
registration.market_id
market.id
Null on delete
fk_registration_rateplan_id
registration.rateplan_id
rate_plan.id
Null on delete
fk_registration_sales_id
registration.sales_id
sales_staff.id
Null on delete
fk_registration_channel_id
registration.channel_id
channel.id
Restrict delete
fk_registration_rsvtype_id
registration.rsvtype_id
reservation_type.id
Restrict delete
fk_registration_mealtype_id
registration.mealtype_id
meal_type.id
Restrict delete
fk_registration_booking_items
registration.booking_item
booking_items.item_id
Restrict delete
fk_registration_promotion_id
registration.promotion_id
promotion.id
Null on delete
fk_registration_shared_register_id
registration.shared_register_id
registration.id
Restrict delete
fk_registration_guest_id
registration.guest_id
guest.id
Restrict delete
fk_folio_details_folio_id
folio_details.folio_id
folio.id
Cascade on delete
fk_folio_details_dept_id
folio_details.dept_id
department.id
Cascade on delete
fk_room_type_group_id
room_type.group_id
room_group.id
Null on delete
fk_cash_sale_folio_id
cash_sale.folio_id
folio.id
Cascade on delete
fk_department_tax_code
department.tax_code
tax.code
Null on delete
department_group_id_fkey
department.group_id
department_group.id
Restrict delete
fk_channel_type_id
channel.type_id
channel_type.id
Restrict delete
fk_channel_origin_id
channel.origin_id
origin.id
Null on delete
fk_channel_nation_id
channel.nation_id
nationality.id
Null on delete
fk_channel_folpat_id
channel.folpat_id
folio_pattern.id
Null on delete
fk_channel_group_id
channel.group_id
channel_group.id
Null on delete
fk_channel_sales_id
channel.sales_id
sales_staff.id
Null on delete
fk_channel_contact_country_id
channel.contact_country_id
country.id
Null on delete
fk_room_restriction_roomtype_id
room_restriction.roomtype_id
room_type.id
Cascade on delete
rate_inclusion_fk
rate_inclusion.inclusion_id
inclusion.id
Cascade on delete
rate_inclusion_rateplan_id_fk
rate_inclusion.rateplan_id
rate_plan.id
Cascade on delete
rate_inclusion_dept_id_fk
rate_inclusion.charge_dept
department.id
Restrict delete
booking_msg_guests_fk
booking_msg_guests.booking_id
booking.id
Cascade on delete
nationality_lang_id_fk
nationality.default_lang_id
language.id
Null on delete
nationality_market_id_fk
nationality.default_market_id
market.id
Null on delete
fk_channel_rates_roomtype_id
channel_rates.roomtype_id
room_type.id
Cascade on delete
fk_channel_rates_rate_id
channel_rates.rate_id
rate_details.rate_id
Cascade on delete
fk_channel_rates_channel_id
channel_rates.channel_id
channel.id
Cascade on delete
fk_room_status_room_id
room_status.room_id
room.id
Cascade on delete
fk_guest_social_social_id
guest_social.social_id
social_media.id
Restrict delete
fk_guest_social_guest_id
guest_social.guest_id
guest.id
Cascade on delete
fk_room_block_room_id
room_block.room_id
room.id
Cascade on delete
fk_room_block_booking_items
room_block.booking_item
booking_items.item_id
Cascade on delete
fk_room_block_register_id
room_block.register_id
registration.id
Null on delete
fk_guest_document_photo_file
guest_document.photo_file
files.id
Restrict delete
fk_guest_document_id
guest_document.guest_id
guest.id
Cascade on delete
fk_guest_document_image_file
guest_document.image_file
files.id
Restrict delete
fk_guest_messages_register_id
guest_messages.register_id
registration.id
Cascade on delete
fk_guest_messages_booking_id
guest_messages.booking_id
booking.id
Cascade on delete
fk_charge_schedule_booking_id
charge_schedule.booking_id
booking.id
Cascade on delete
fk_charge_schedule_register_id
charge_schedule.register_id
registration.id
Cascade on delete
fk_charge_schedule_charge_dept
charge_schedule.charge_dept
department.id
Restrict delete
fk_charge_schedule_tran_id
charge_schedule.tran_id
transactions.id
Null on delete
fk_credit_card_guest_id
credit_card.guest_id
guest.id
Cascade on delete
fk_user_alerts_alert_page
user_alerts.alert_page
alert_page.id
Restrict delete
fk_user_alerts_followup_id
user_alerts.followup_id
followup.id
Cascade on delete
room_image_roomtype_id_fk
room_image.roomtype_id
room_type.id
Cascade on delete
fk_city_country
city.country_id
country.id
Cascade on delete
fk_rate_details_roomtype_id
rate_details.roomtype_id
room_type.id
Cascade on delete
fk_rate_details_rateplan_id
rate_details.rateplan_id
rate_plan.id
Cascade on delete
fk_rate_details_market_id
rate_details.market_id
market.id
Cascade on delete
fk_rate_details_origin_id
rate_details.origin_id
origin.id
Cascade on delete
fk_rate_details_link_rate_id
rate_details.link_rate_id
rate_details.rate_id
Restrict delete
fk_rate_restriction_rate_id
rate_restriction.rate_id
rate_details.rate_id
Cascade on delete
fk_booking_guests_register_id
booking_guests.register_id
registration.id
Null on delete
fk_booking_guests_booking_id
booking_guests.booking_id
booking.id
Cascade on delete
fk_booking_guests_guest_id
booking_guests.guest_id
guest.id
Restrict delete
fk_room_summary_building_id
room_summary.building_id
building.id
Null on delete
fk_room_summary_promotion_id
room_summary.promotion_id
promotion.id
Null on delete
fk_room_summary_channel_id
room_summary.channel_id
channel.id
Null on delete
fk_room_summary_rateplan_id
room_summary.rateplan_id
rate_plan.id
Null on delete
fk_room_summary_guest_city_id
room_summary.guest_city_id
city.id
Null on delete
fk_room_summary_location_id
room_summary.location_id
room_location.id
Null on delete
fk_room_summary_bedtype_id
room_summary.bedtype_id
bed_type.id
Null on delete
fk_room_summary_guest_occupation_id
room_summary.guest_occupation_id
occupation.id
Null on delete
fk_room_summary_guest_country_res_id
room_summary.guest_country_res_id
country.id
Null on delete
fk_room_summary_exposure_id
room_summary.exposure_id
room_exposure.id
Null on delete
fk_room_summary_guest_vip_id
room_summary.guest_vip_id
vip.id
Null on delete
fk_room_summary_guest_country_id
room_summary.guest_country_id
country.id
Null on delete
fk_room_summary_guest_lang_id
room_summary.guest_lang_id
language.id
Null on delete
fk_room_summary_market_id
room_summary.market_id
market.id
Null on delete
fk_room_summary_room_id
room_summary.room_id
room.id
Null on delete
fk_room_summary_roomtype_id
room_summary.roomtype_id
room_type.id
Null on delete
fk_room_summary_guest_nation_id
room_summary.guest_nation_id
nationality.id
Null on delete
fk_room_summary_sales_id
room_summary.sales_id
sales_staff.id
Null on delete
fk_room_summary_origin_id
room_summary.origin_id
origin.id
Null on delete
fk_room_summary_rsvtype_id
room_summary.rsvtype_id
reservation_type.id
Null on delete
fk_contact_category_id
contact.category_id
contact_category.id
Null on delete
fk_followup_comments_followup_id
followup_comments.followup_id
followup.id
Cascade on delete
fk_booking_rates_promotion_id
booking_rates.promotion_id
promotion.id
Null on delete
fk_booking_rates_rateplan_id
booking_rates.rateplan_id
rate_plan.id
Restrict delete
fk_booking_rates_mealtype_id
booking_rates.mealtype_id
meal_type.id
Restrict delete
fk_booking_rates_booking_items
booking_rates.booking_item
booking_items.item_id
Cascade on delete
fk_alert_alert_page_id
alert.alert_page_id
alert_page.id
Restrict delete
fk_group_info_vip_id
group_info.vip_id
vip.id
Null on delete
fk_group_info_lang_id
group_info.lang_id
language.id
Null on delete
fk_group_info_country_id
group_info.country_id
country.id
Null on delete
fk_group_info_nation_id
group_info.nation_id
nationality.id
Null on delete
fk_group_info_res_country_id
group_info.res_country_id
country.id
Null on delete
fk_followup_seen_followup_id
followup_seen.followup_id
followup.id
Cascade on delete
intf_room_register_id_fk
intf_keycard_logs.register_id
registration.id
Cascade on delete
intf_room_booking_id_fk
intf_keycard_logs.booking_id
booking.id
Cascade on delete
intf_room_room_id_fk
intf_keycard_logs.room_id
room.id
Cascade on delete
fk_booking_party_id
booking.party_id
party.id
Restrict delete
fk_booking_market_id
booking.market_id
market.id
Null on delete
fk_booking_sales_id
booking.sales_id
sales_staff.id
Null on delete
fk_booking_group_id
booking.group_id
group_info.id
Restrict delete
fk_booking_channel_id
booking.channel_id
channel.id
Restrict delete
fk_booking_guest_id
booking.guest_id
guest.id
Restrict delete
fk_booking_origin_id
booking.origin_id
origin.id
Restrict delete
fk_booking_rsvtype_id
booking.rsvtype_id
reservation_type.id
Restrict delete
fk_booking_folpat_id
booking.folio_pattern_id
folio_pattern.id
Restrict delete
fk_transaction_summary_dept_id
transaction_summary.dept_id
department.id
Restrict delete
fk_allotment_roomtype_id
allotment.roomtype_id
room_type.id
Cascade on delete
fk_allotment_channel_id
allotment.channel_id
channel.id
Cascade on delete
folio_pattern_seq_pattern_id_fk
folio_pattern_seq.pattern_id
folio_pattern.id
Cascade on delete
fk_guest_title_id
guest.title_id
title.id
Null on delete
fk_guest_vip_id
guest.vip_id
vip.id
Null on delete
fk_guest_country_id
guest.country_id
country.id
Null on delete
fk_guest_nation_id
guest.nation_id
nationality.id
Null on delete
fk_guest_city_id
guest.city_id
city.id
Null on delete
fk_guest_doc_id
guest.doc_id
guest_document.id
Restrict delete
fk_guest_res_country_id
guest.country_res_id
country.id
Null on delete
fk_guest_lang_id
guest.lang_id
language.id
Null on delete
fk_meal_inclusion_inclusion
meal_inclusion.inclusion_id
inclusion.id
Cascade on delete
fk_meal_inclusion_meal_type
meal_inclusion.meal_type_id
meal_type.id
Cascade on delete
fk_followup_followup_category_id
followup.followup_category_id
followup_category.id
Restrict delete
fk_followup_followup_status_id
followup.followup_status_id
followup_status.id
Restrict delete
fk_rsv_pickup_sales_id
rsv_pickup.sales_id
sales_staff.id
Null on delete
fk_rsv_pickup_market_id
rsv_pickup.market_id
market.id
Null on delete
fk_rsv_pickup_guest_nation_id
rsv_pickup.guest_nation_id
nationality.id
Null on delete
fk_rsv_pickup_guest_occupation_id
rsv_pickup.guest_occupation_id
occupation.id
Null on delete
fk_rsv_pickup_mealtype_id
rsv_pickup.mealtype_id
meal_type.id
Null on delete
fk_rsv_pickup_roomtype_id
rsv_pickup.roomtype_id
room_type.id
Null on delete
fk_rsv_pickup_rateplan_id
rsv_pickup.rateplan_id
rate_plan.id
Null on delete
fk_rsv_pickup_guest_lang_id
rsv_pickup.guest_lang_id
language.id
Null on delete
fk_rsv_pickup_channel_id
rsv_pickup.channel_id
channel.id
Null on delete
fk_rsv_pickup_promotion_id
rsv_pickup.promotion_id
promotion.id
Null on delete
fk_rsv_pickup_origin_id
rsv_pickup.origin_id
origin.id
Null on delete
fk_rsv_pickup_guest_vip_id
rsv_pickup.guest_vip_id
vip.id
Null on delete
fk_rsv_pickup_bedtype_id
rsv_pickup.bedtype_id
bed_type.id
Null on delete
fk_rsv_pickup_guest_country_id
rsv_pickup.guest_country_id
country.id
Null on delete
fk_rsv_pickup_guest_country_res_id
rsv_pickup.guest_country_res_id
country.id
Null on delete
fk_rsv_pickup_rsvtype_id
rsv_pickup.rsvtype_id
reservation_type.id
Null on delete
fk_rsv_pickup_guest_city_id
rsv_pickup.guest_city_id
city.id
Null on delete
intf_room_agent_code_fk
intf_room.agent_code
intf_agent.code
Cascade on delete
intf_room_room_id_fk
intf_room.room_id
room.id
Cascade on delete
fk_channel_restriction_channel_id
channel_restriction.channel_id
channel.id
Cascade on delete
fk_channel_restriction_rateplan_id
channel_restriction.rateplan_id
rate_plan.id
Cascade on delete
fk_channel_restriction_roomtype_id
channel_restriction.roomtype_id
room_type.id
Cascade on delete
fk_rate_plan_channels_channel_id
rate_plan_channels.rateplan_id
rate_plan.id
Cascade on delete
fk_rate_plan_channels_rateplan_id
rate_plan_channels.channel_id
channel.id
Cascade on delete
fk_attachment_register_id
attachment.register_id
registration.id
Cascade on delete
fk_attachment_booking_id
attachment.booking_id
booking.id
Cascade on delete
fk_attachment_file_id
attachment.file_id
files.id
Restrict delete
fk_transactions_dept_id
transactions.dept_id
department.id
Restrict delete
fk_transactions_tax_code
transactions.tax_code
tax.code
Restrict delete
fk_transactions_transfer_src
transactions.transfer_src
transactions.id
Restrict delete
fk_transactions_transfer_des
transactions.transfer_des
transactions.id
Restrict delete
fk_transactions_card_id
transactions.card_id
credit_card.id
Restrict delete
fk_transactions_folio_id
transactions.folio_id
folio.id
Cascade on delete
fk_transactions_folio_item
transactions.folio_item
folio_items.item_id
Restrict delete
fk_alert_user_alert_id
alert_user.alert_id
alert.id
Cascade on delete
fk_folio_items_folio_id
folio_items.folio_id
folio.id
Cascade on delete
fk_folio_items_charge_to_folio
folio_items.charge_to_folio
folio.id
Null on delete
fk_booking_items_rateplan_id
booking_items.rateplan_id
rate_plan.id
Restrict delete
fk_booking_items_bedtype_id
booking_items.bedtype_id
bed_type.id
Null on delete
fk_booking_items_booking_id
booking_items.booking_id
booking.id
Cascade on delete
fk_booking_items_rate_id
booking_items.rate_id
rate_details.rate_id
Null on delete
fk_booking_items_mealtype_id
booking_items.mealtype_id
meal_type.id
Restrict delete
fk_booking_items_promotion_id
booking_items.promotion_id
promotion.id
Null on delete
fk_booking_items_roomtype_id
booking_items.roomtype_id
room_type.id
Restrict delete
fk_rate_plan_rategroup_id
rate_plan.rategroup_id
rate_group.id
Null on delete
rate_plan_link_plan_id_fk
rate_plan.link_plan_id
rate_plan.id
Restrict delete
fk_rate_plan_market_id
rate_plan.market_id
market.id
Cascade on delete
fk_rate_plan_mealtype_id
rate_plan.mealtype_id
meal_type.id
Null on delete
fk_rate_plan_origin_id
rate_plan.origin_id
origin.id
Cascade on delete
fk_register_guests_guest_id
register_guests.guest_id
guest.id
Restrict delete
fk_register_guests_register_id
register_guests.register_id
registration.id
Cascade on delete
channel_market_market_id_fkey
channel_market.market_id
market.id
Cascade on delete
channel_market_channel_id_fkey
channel_market.channel_id
channel.id
Cascade on delete
fk_folio_booking_id
folio.booking_id
booking.id
Restrict delete
fk_folio_register_id
folio.register_id
registration.id
Cascade on delete
fk_folio_folio_pattern_id
folio.folio_pattern_id
folio_pattern.id
Null on delete
fk_out_of_order_room_id
out_of_order.room_id
room.id
Cascade on delete
fk_out_of_order_ooo_reason
out_of_order.reason_id
ooo_reason.id
Restrict delete
fk_folio_pattern_details_folio_pattern_seq
folio_pattern_details.pattern_id
folio_pattern_details.folio_seq
folio_pattern_seq.pattern_id
folio_pattern_seq.folio_seq
Cascade on delete
fk_folio_pattern_details_dept_id
folio_pattern_details.dept_id
department.id
Cascade on delete
fk_room_building_id
room.building_id
building.id
Null on delete
fk_room_connecting_room
room.connecting_room
room.id
Null on delete
fk_room_roomtype_id
room.roomtype_id
room_type.id
Restrict delete
fk_room_exposure_id
room.exposure_id
room_exposure.id
Null on delete
fk_room_location_id
room.location_id
room_location.id
Null on delete
fk_room_bedtype_id
room.bedtype_id
bed_type.id
Null on delete
room_rate_roomtype_id_fk
room_rate.roomtype_id
room_type.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
registration_history check_registration_status ((status)::text = ANY (ARRAY['I'::text, 'O'::text, 'X'::text]))
registration_history chk_departure ((departure + fn_sys_param('BACKUP'::text, 'BACKUPDAY'::text, 90)) > fn_system_date())
channel_type channel_type_id_not_null1 id IS NOT NULL
registration check_registration_status ((status)::text = ANY (ARRAY['I'::text, 'O'::text, 'X'::text]))
department department_dept_type_check (dept_type = ANY (ARRAY['D'::bpchar, 'C'::bpchar]))
department department_post_type_check (post_type = ANY (ARRAY['P'::bpchar, 'S'::bpchar]))
registration_recent check_registration_status ((status)::text = ANY (ARRAY['I'::text, 'O'::text, 'X'::text]))
registration_recent chk_departure ((departure + fn_sys_param('BACKUP'::text, 'BACKUPDAY'::text, 90)) > fn_system_date())
regis check_registration_status ((status)::text = ANY (ARRAY['I'::text, 'O'::text, 'X'::text]))
charge_schedule charge_schedule_charge_type_check (charge_type = ANY (ARRAY['room'::text, 'inclusion'::text, 'requirement'::text]))
department_group department_group_group_type_check ((post_type = 'P'::bpchar) OR (category = ANY (ARRAY['cash'::text, 'card'::text, 'bank'::text, 'city'::text, 'deposit'::text, 'other'::text])))
record_lock record_lock_lock_type_check (lock_type = ANY (ARRAY['booking'::text, 'registration'::text]))
room_upgrade room_upgrade_upgrade_type_check (upgrade_type = ANY (ARRAY['upgrade'::text, 'upsell'::text, 'none'::text]))