country

253 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
channel.contact_country_id fk_channel_contact_country_id N
city.country_id fk_city_country C
group_info.country_id fk_group_info_country_id N
group_info.res_country_id fk_group_info_res_country_id N
guest.country_id fk_guest_country_id N
guest.country_res_id fk_guest_res_country_id N
room_summary.guest_country_id fk_room_summary_guest_country_id N
room_summary.guest_country_res_id fk_room_summary_guest_country_res_id N
rsv_pickup.guest_country_id fk_rsv_pickup_guest_country_id N
rsv_pickup.guest_country_res_id fk_rsv_pickup_guest_country_res_id N
code bpchar 3 √ null
currencies.code Implied Constraint R
name text 2147483647 √ null
enabled bool 1 √ true
code2 bpchar 2 √ null
tm_code text 2147483647 √ null
rr_code text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
country_pkey Primary key Asc id
country_code_key Must be unique Asc code

Relationships

Close relationships within degrees of separation