CREATE TABLE seriestitle (

    seriestitle     text        PRIMARY KEY
);

CREATE TABLE storyline (

    storyline       text        PRIMARY KEY
    );

CREATE TABLE bookcover (

    bookcover       OID     PRIMARY KEY
    );

CREATE TABLE style (

    style           text        PRIMARY KEY
    );

CREATE TABLE isbn (

    isbn            text        PRIMARY KEY
    );

CREATE TABLE characters (

    name            text        PRIMARY KEY
    );

CREATE TABLE writer (

    writer          text        PRIMARY KEY
    );

CREATE TABLE ink (

    ink         text        PRIMARY KEY
    );

CREATE TABLE pencils (

    pencils         text        PRIMARY KEY
    );

CREATE TABLE coverartist (

    coverartist     text        PRIMARY KEY
    );

CREATE TABLE artist (

    artist          text        PRIMARY KEY
    );

CREATE TABLE letters (

    letters         text        PRIMARY KEY
    );

CREATE TABLE colors (

    colors          text        PRIMARY KEY
    );

CREATE TABLE compilation (

    compilation text    PRIMARY KEY,
    c_date      text    NOT NULL,
    isbn        text    REFERENCES isbn NOT NULL,
    style       text    REFERENCES style NOT NULL,
    seriestitle text    REFERENCES seriestitle DEFAULT '_default_',
    price       float   NOT NULL
    );


CREATE TABLE storytitle (
    storytitle  text        PRIMARY KEY,
    characters  text        REFERENCES characters (name) NOT NULL,
    notes       text        DEFAULT '_default_',
    writer      text        REFERENCES writer(writer) DEFAULT '_default_',
    ink     text        REFERENCES ink(ink) DEFAULT '_default_',
    pencils     text        REFERENCES pencils(pencils) DEFAULT '_default_',
    coverartist text        REFERENCES coverartist(coverartist) DEFAULT '_default_',
    artist      text        REFERENCES artist(artist) DEFAULT '_default_',
    letters     text        REFERENCES letters(letters) DEFAULT '_default_',
    colors      text        REFERENCES colors(colors) DEFAULT '_default_'
    );

CREATE TABLE booktitle (
    booktitle       text        NOT NULL,
    storytitle      text        REFERENCES storytitle(storytitle) NOT NULL,
    isbn            text        REFERENCES isbn (isbn) NOT NULL DEFAULT '_default_',
    i_date          text        NOT NULL,
    price           float       NOT NULL,
    style           text        REFERENCES style (style) NOT NULL DEFAULT 'Single Issue',
    seriestitle     text        REFERENCES seriestitle(seriestitle) DEFAULT '_default_',
    storyline       text        REFERENCES storyline(storyline) DEFAULT '_default_',
    bookcover       OID     REFERENCES bookcover(bookcover),
    compilation     text        REFERENCES compilation(compilation) DEFAULT '_default_',
    PRIMARY KEY (booktitle, storytitle)
    );