{"publication": {"columns": [[0, "Publication_ID", "INT", 0, null, 1], [1, "Book_ID", "INT", 0, null, 0], [2, "Publisher", "TEXT", 0, null, 0], [3, "Publication_Date", "TEXT", 0, null, 0], [4, "Price", "REAL", 0, null, 0]], "primary_keys": ["Publication_ID"], "foreign_keys": [[0, 0, "book", "Book_ID", "Book_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Publication_ID"]]], "check_constraints": []}, "book": {"columns": [[0, "Book_ID", "INT", 0, null, 1], [1, "Title", "TEXT", 0, null, 0], [2, "Issues", "REAL", 0, null, 0], [3, "Writer", "TEXT", 0, null, 0]], "primary_keys": ["Book_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Book_ID"]]], "check_constraints": []}}
CREATE TABLE publication (
    Publication_ID INT   PRIMARY KEY,
    Book_ID INT,
    Publisher TEXT,
    Publication_Date TEXT,
    Price REAL,
    UNIQUE (Publication_ID),
    FOREIGN KEY (Book_ID) REFERENCES book(Book_ID)
);

CREATE TABLE book (
    Book_ID INT   PRIMARY KEY,
    Title TEXT,
    Issues REAL,
    Writer TEXT,
    UNIQUE (Book_ID)
);