guest

211612 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
booking.guest_id fk_booking_guest_id R
booking_guests.guest_id fk_booking_guests_guest_id R
credit_card.guest_id fk_credit_card_guest_id C
guest_document.guest_id fk_guest_document_id N
guest_history.guest_id fk_guest_history_guest_id C
guest_signature.guest_id guest_signature_guest_id_fkey R
guest_social.guest_id fk_guest_social_guest_id C
precheckin_consent_logs.guest_id precheckin_consent_logs_guest_id_fkey R
precheckin_legal_acceptance.guest_id precheckin_legal_acceptance_guest_id_fkey R
register_guests.guest_id fk_register_guests_guest_id R
registration.guest_id fk_registration_guest_id R
first_name text 2147483647 null
last_name text 2147483647 null
middle_name text 2147483647 √ null
full_name citext 2147483647 √ null
sex bpchar 1 √ null
birthdate date 13 √ null
nation_id int4 10 √ null
nationality.id fk_guest_nation_id N
lang_id int4 10 √ null
language.id fk_guest_lang_id N
vip_id int4 10 √ null
vip.id fk_guest_vip_id N
address1 text 2147483647 √ null
address2 text 2147483647 √ null
country_id int4 10 √ null
country.id fk_guest_country_id N
country_res_id int4 10 √ null
country.id fk_guest_res_country_id N
telephone text 2147483647 √ null
fax text 2147483647 √ null
mobile text 2147483647 √ null
email text 2147483647 √ null
company text 2147483647 √ null
occupation_id int4 10 √ null
doc_number citext 2147483647 √ null
doc_type int2 5 √ null

1 = Passport , 2 = ID Card, 3 = Driving License
credit_limit t_money 15,2 √ null
confidential bool 1 √ null
member_code citext 2147483647 √ null
carplate_no text 2147483647 √ null
photo bytea 2147483647 √ null
remark text 2147483647 √ null
image_count int4 10 √ 0
visit_count int4 10 √ 0
visit_nights int4 10 √ 0
last_arrival date 13 √ null
last_departure date 13 √ null
phone_numbersXXX _text 2147483647 √ null
emails _text 2147483647 √ null
doc_country int4 10 √ null
doc_expire date 13 √ null
city_id int4 10 √ null
city.id fk_guest_city_id N
title_id int4 10 √ null
title.id fk_guest_title_id N
likes _text 2147483647 √ null
dislikes _text 2147483647 √ null
credit_cards _int4 10 √ null
telephones _text 2147483647 √ null
mobiles _text 2147483647 √ null
photo_id int8 19 √ null
doc_id int4 10 √ null
guest_document.id fk_guest_doc_id R
photo_url text 2147483647 √ null
revenues jsonb 2147483647 √ null
total_revenue t_money 15,2 √ null
is_dummy bool 1 false
created_at timestamptz 35,6 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
pk_guest Primary key Asc id
idx_guest_city_id Performance Asc city_id
idx_guest_country_id Performance Asc country_id
idx_guest_created_at Performance Asc created_at
idx_guest_doc_id Performance Asc doc_id
idx_guest_document_identity Performance Asc doc_type
idx_guest_full_name Performance Asc full_name
idx_guest_is_dummy Performance Asc is_dummy
idx_guest_lang_id Performance Asc lang_id
idx_guest_last_departure Performance Asc last_departure
idx_guest_nation_id Performance Asc nation_id
idx_guest_res_country_id Performance Asc country_res_id
idx_guest_title_id Performance Asc title_id
idx_guest_vip_id Performance Asc vip_id

Relationships

Close relationships within degrees of separation