CountryCities

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CountryCode

varchar

255

√

null

CountryName

varchar

255

√

null

CountryCreatedAt

timestamptz

35,6

√

null

CountryUpdatedAt

timestamptz

35,6

√

null

CountryDemonym

varchar

255

√

null

CountryCurrency

jsonb

2147483647

√

null

CountryLanguages

jsonb

2147483647

√

null

CountryCallingCode

jsonb

2147483647

√

null

CityId

int4

√

null

CityName

varchar

2147483647

√

null

CityCreatedAt

timestamptz

35,6

√

null

CityUpdatedAt

timestamptz

35,6

√

null

fullName

varchar

2147483647

√

null

unaccentedFullName

varchar

255

√

null

unaccentedReversedFullName

varchar

255

√

null

unaccentedFullNameTsv

tsvector

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT countries.code AS "CountryCode",
    countries.name AS "CountryName",
    countries."createdAt" AS "CountryCreatedAt",
    countries."updatedAt" AS "CountryUpdatedAt",
    countries.demonym AS "CountryDemonym",
    countries.currency AS "CountryCurrency",
    countries.languages AS "CountryLanguages",
    countries."callingCode" AS "CountryCallingCode",
    NULL::integer AS "CityId",
    NULL::character varying AS "CityName",
    NULL::timestamp with time zone AS "CityCreatedAt",
    NULL::timestamp with time zone AS "CityUpdatedAt",
    countries.name AS "fullName",
    (unaccent((countries.name)::text))::character varying(255) AS "unaccentedFullName",
    (unaccent((countries.name)::text))::character varying(255) AS "unaccentedReversedFullName",
    setweight(to_tsvector('english'::regconfig, unaccent((countries.name)::text)), 'A'::"char") AS "unaccentedFullNameTsv"
   FROM "Countries" countries
UNION ALL
 SELECT countries.code AS "CountryCode",
    countries.name AS "CountryName",
    countries."createdAt" AS "CountryCreatedAt",
    countries."updatedAt" AS "CountryUpdatedAt",
    countries.demonym AS "CountryDemonym",
    countries.currency AS "CountryCurrency",
    countries.languages AS "CountryLanguages",
    countries."callingCode" AS "CountryCallingCode",
    cities.id AS "CityId",
    cities.name AS "CityName",
    cities."createdAt" AS "CityCreatedAt",
    cities."updatedAt" AS "CityUpdatedAt",
    (((cities.name)::text || ', '::text) || (countries.name)::text) AS "fullName",
    (unaccent((((cities.name)::text || ' '::text) || (countries.name)::text)))::character varying(255) AS "unaccentedFullName",
    (unaccent((((countries.name)::text || ' '::text) || (cities.name)::text)))::character varying(255) AS "unaccentedReversedFullName",
    setweight(to_tsvector('english'::regconfig, unaccent((((cities.name)::text || ', '::text) || (countries.name)::text))), 'A'::"char") AS "unaccentedFullNameTsv"
   FROM ("Countries" countries
     JOIN "Cities" cities ON (((cities."CountryCode")::text = (countries.code)::text)));

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views