text: CREATE TABLE countries (
    country_code char(2) PRIMARY KEY,
    country_name text UNIQUE
  );
  
  CREATE TABLE cities (
    name text NOT NULL,
    postal_code varchar(9) CHECK (postal_code <> ''),
    country_code char(2) REFERENCES countries,
    PRIMARY KEY (country_code, postal_code)
  );