{"book_club": {"columns": [[0, "book_club_id", "INT", 0, null, 1], [1, "Year", "INT", 0, null, 0], [2, "Author_or_Editor", "TEXT", 0, null, 0], [3, "Book_Title", "TEXT", 0, null, 0], [4, "Publisher", "TEXT", 0, null, 0], [5, "Category", "TEXT", 0, null, 0], [6, "Result", "TEXT", 0, null, 0]], "primary_keys": ["book_club_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "book_club_id"]]], "check_constraints": []}, "movie": {"columns": [[0, "movie_id", "INT", 0, null, 1], [1, "Title", "TEXT", 0, null, 0], [2, "Year", "INT", 0, null, 0], [3, "Director", "TEXT", 0, null, 0], [4, "Budget_million", "REAL", 0, null, 0], [5, "Gross_worldwide", "INT", 0, null, 0]], "primary_keys": ["movie_id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "movie_id"]]], "check_constraints": []}, "culture_company": {"columns": [[0, "Company_name", "TEXT", 0, null, 1], [1, "Type", "TEXT", 0, null, 0], [2, "Incorporated_in", "TEXT", 0, null, 0], [3, "Group_Equity_Shareholding", "REAL", 0, null, 0], [4, "book_club_id", "TEXT", 0, null, 0], [5, "movie_id", "TEXT", 0, null, 0]], "primary_keys": ["Company_name"], "foreign_keys": [[0, 0, "movie", "movie_id", "movie_id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "book_club", "book_club_id", "book_club_id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Company_name"]]], "check_constraints": []}}
CREATE TABLE book_club (
    book_club_id INT   PRIMARY KEY,
    Year INT,
    Author_or_Editor TEXT,
    Book_Title TEXT,
    Publisher TEXT,
    Category TEXT,
    Result TEXT,
    UNIQUE (book_club_id)
);

CREATE TABLE movie (
    movie_id INT   PRIMARY KEY,
    Title TEXT,
    Year INT,
    Director TEXT,
    Budget_million REAL,
    Gross_worldwide INT,
    UNIQUE (movie_id)
);

CREATE TABLE culture_company (
    Company_name TEXT   PRIMARY KEY,
    Type TEXT,
    Incorporated_in TEXT,
    Group_Equity_Shareholding REAL,
    book_club_id TEXT,
    movie_id TEXT,
    UNIQUE (Company_name),
    FOREIGN KEY (movie_id) REFERENCES movie(movie_id),
    FOREIGN KEY (book_club_id) REFERENCES book_club(book_club_id)
);