city

4057 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
guest.city_id fk_guest_city_id N
room_summary.guest_city_id fk_room_summary_guest_city_id N
rsv_pickup.guest_city_id fk_rsv_pickup_guest_city_id N
country_id int4 10 null
country.id fk_city_country C
name text 2147483647 √ null
enabled bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
pk_city Primary key Asc id
idx_city_country_id Performance Asc country_id

Relationships

Close relationships within degrees of separation