CREATE TABLE phone
(
    phone_id SERIAL PRIMARY KEY,
    phone    CHAR(15),
    sub_id   INT,   -- subscriber id --
    cat_id   INT    -- category id --
);
 
CREATE TABLE category
(
    cat_id   SERIAL PRIMARY KEY,    -- category id --
    cat_name CHAR(15)       -- category name --
);
 
CREATE TABLE  subscriber
(
    sub_id  SERIAL PRIMARY KEY,
    name    CHAR(20),
    fname   CHAR(20),   -- first name --
    lname   CHAR(20),   -- last name --
);
 
CREATE TABLE address
(
    addr_id       SERIAL PRIMARY KEY,
    country       CHAR(20),
    city          CHAR(20),
    street        CHAR(20),
    house_num     INT,
    apartment_num INT
);
 
-- many-to-many relation --
CREATE TABLE sub_link
(
    sub_id   INT REFERENCES subscriber(sub_id),
    addr_id  INT
);

CREATE TABLE address
(
        addr_id       SERIAL PRIMARY KEY,
        country       CHAR(20),
        city          CHAR(20),
        street        CHAR(20),
        house_num     INT,
        apartment_num INT,
        UNIQUE (country, city, street, house_num, apartment_num)
);

WITH t AS (
        INSERT INTO subscriber(name, fname, lname) VALUES ("xxx", "yyy", "zzz")
        RETURNING *
)