CREATE SEQUENCE number_seq;
CREATE TABLE number (
    id int4 PRIMARY KEY DEFAULT NEXTVAL( 'number_seq' ),
    name varchar,
    number varchar,
    phone_type varchar
);

CREATE TABLE bday (
    id SERIAL PRIMARY KEY,
    contact int4,
    bday date,
    anniversary date,
    known_since date
);

CREATE TABLE tshirt (
    id SERIAL PRIMARY KEY,
    ident varchar
);

CREATE TABLE color (
    id SERIAL PRIMARY KEY,
    ident varchar,
    foreigner int4
);

CREATE TABLE tshirt_color (
    id SERIAL PRIMARY KEY,
    tshirt int4 REFERENCES tshirt(id),
    color int4 REFERENCES color(id)
);
CREATE TABLE tshirt_author (
    id SERIAL PRIMARY KEY,
    tshirt int4 REFERENCES tshirt(id),
    author int4 REFERENCES author(id)
);
CREATE TABLE author (
    id SERIAL PRIMARY KEY,
    ident varchar
);

CREATE TABLE book (
    id SERIAL PRIMARY KEY,
    ident varchar
);

CREATE TABLE author_book (
    id SERIAL PRIMARY KEY,
    author int4 REFERENCES author(id),
    book int4 REFERENCES book(id),
    extra_field varchar,
    second_extra boolean
);

INSERT INTO author_book ( author, book, extra_field )
    VALUES ( 1, 1, 'hello' );

CREATE SEQUENCE sch.name_seq;
CREATE TABLE sch.name (
    id int4 PRIMARY KEY DEFAULT NEXTVAL( 'sch.name_seq' ),
    name varchar,
    number varchar
);