nationality

263 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
channel.nation_id fk_channel_nation_id N
group_info.nation_id fk_group_info_nation_id N
guest.nation_id fk_guest_nation_id N
room_summary.guest_nation_id fk_room_summary_guest_nation_id N
rsv_pickup.guest_nation_id fk_rsv_pickup_guest_nation_id N
code citext 2147483647 null
name citext 2147483647 √ null
default_lang_id int4 10 √ null
language.id nationality_lang_id_fk N
default_market_id int4 10 √ null
market.id nationality_market_id_fk N
enabled bool 1 √ true
geocode varchar 3 √ null
iso_code text 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
tm_code text 2147483647 √ null
rr_code text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
nationality_pkey Primary key Asc id
nationality_code_key Must be unique Asc code
nationality_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation