imdb

Create SQL

CREATE TABLE companies (
    uuid TEXT PRIMARY KEY,
    imdb_id TEXT UNIQUE, -- co0191087
    name TEXT NOT NULL,
    -- From companies_details
    bio TEXT,
    country TEXT,
    -- Meter ranking
    meter_current_rank INTEGER,
    meter_rank_change INTEGER,
    meter_rank_direction TEXT, -- 'UP', 'DOWN', 'SAME'
    -- Primary contact (from contact.url)
    primary_website TEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

Columns

Sample Data

Create SQL

CREATE TABLE company_affiliations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_a_uuid TEXT NOT NULL,
    company_b_uuid TEXT NOT NULL,
    relationship_type TEXT, -- 'Parent of', 'Subsidiary of', 'Client of', 'Production Deal with'
    UNIQUE (company_a_uuid, company_b_uuid, relationship_type),
    FOREIGN KEY (company_a_uuid) REFERENCES companies (uuid) ON DELETE CASCADE,
    FOREIGN KEY (company_b_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_branches (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_uuid TEXT NOT NULL,
    branch_name TEXT, -- 'Burbank, CA', 'London, England'
    address1 TEXT,
    address2 TEXT,
    city TEXT,
    state TEXT,
    zip TEXT,
    country TEXT,
    email TEXT,
    phone TEXT,
    phone_alt TEXT,
    fax TEXT,
    website TEXT,
    map_url TEXT,
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_collaborations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_a_uuid TEXT NOT NULL,
    company_b_uuid TEXT NOT NULL,
    film_uuid TEXT NOT NULL,
    role_a TEXT, -- 'production', 'distribution', etc
    role_b TEXT,
    FOREIGN KEY (company_a_uuid) REFERENCES companies (uuid) ON DELETE CASCADE,
    FOREIGN KEY (company_b_uuid) REFERENCES companies (uuid) ON DELETE CASCADE,
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    UNIQUE (company_a_uuid, company_b_uuid, film_uuid)
)

Columns

Sample Data

Create SQL

CREATE TABLE company_dev_projects (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_uuid TEXT NOT NULL,
    project_imdb_id TEXT,
    title TEXT,
    year INTEGER,
    project_type TEXT,
    image_url TEXT,
    role TEXT,
    movie_meter INTEGER,
    status TEXT, -- 'Development Unknown', 'Script', 'Pre-Prod', etc
    budget TEXT,
    opening_weekend TEXT,
    domestic_gross TEXT,
    worldwide_gross TEXT,
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_known_client_professions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    known_client_id INTEGER NOT NULL,
    profession TEXT,
    FOREIGN KEY (known_client_id) REFERENCES company_known_clients (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_known_client_representations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    known_client_id INTEGER NOT NULL,
    representation_type TEXT, -- 'manager', 'publicist'
    total INTEGER,
    FOREIGN KEY (known_client_id) REFERENCES company_known_clients (id) ON DELETE CASCADE
)

Columns

Sample Data

No sample rows available.

Create SQL

CREATE TABLE company_known_clients (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_uuid TEXT NOT NULL,
    client_imdb_id TEXT, -- nm3025399
    client_name TEXT,
    client_person_uuid TEXT, -- Linked if person exists in DB
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE,
    FOREIGN KEY (client_person_uuid) REFERENCES people (uuid) ON DELETE SET NULL
)

Columns

Sample Data

Create SQL

CREATE TABLE company_known_title_jobs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    known_title_id INTEGER NOT NULL,
    job TEXT, -- 'Distributors', 'Production Companies'
    FOREIGN KEY (known_title_id) REFERENCES company_known_titles (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_known_titles (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    company_uuid TEXT NOT NULL,
    title_imdb_id TEXT, -- tt26584495
    title TEXT,
    title_type TEXT, -- 'movie', 'tvSeries'
    release_year INTEGER,
    awards_nominated INTEGER DEFAULT 0,
    awards_won INTEGER DEFAULT 0,
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_type_links (
    company_uuid TEXT NOT NULL,
    type_id INTEGER NOT NULL,
    PRIMARY KEY (company_uuid, type_id),
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE,
    FOREIGN KEY (type_id) REFERENCES company_types (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE company_types (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT UNIQUE NOT NULL -- 'Distributor', 'Production', etc
)

Columns

Sample Data

Create SQL

CREATE TABLE film_awards (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_uuid TEXT NOT NULL,
    award_name TEXT,
    award_category TEXT,
    award_year INTEGER,
    award_status TEXT, -- 'Won', 'Nominated', etc.
    winner_name TEXT,
    won INTEGER DEFAULT 0, -- 0 = nominated, 1 = won (derived for easy querying)
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_cast (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_uuid TEXT NOT NULL,
    person_uuid TEXT NOT NULL,
    billing_order INTEGER, -- Derived from array position
    star_meter_at_time INTEGER, -- Rank at time of movie release/scrape
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_companies (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_uuid TEXT NOT NULL,
    company_uuid TEXT NOT NULL,
    role_type TEXT NOT NULL, -- 'production', 'distribution', 'fx', 'other'
    -- Context fields from the film's company entry
    branch TEXT, -- 'Branch: Sherman Oaks, CA'
    region TEXT, -- For distribution: 'Russia', 'United States'
    format TEXT, -- For distribution: 'Theatrical'
    services TEXT, -- For other: 'Camera rental', 'Production financing'
    -- Inline contact from film scrape (may differ from company_branches)
    contact_website TEXT,
    contact_phone TEXT,
    contact_fax TEXT,
    contact_email TEXT,
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_company_contact_other (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_company_id INTEGER NOT NULL,
    value TEXT,
    FOREIGN KEY (film_company_id) REFERENCES film_companies (id) ON DELETE CASCADE
)

Columns

Sample Data

No sample rows available.

Create SQL

CREATE TABLE film_crew (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_uuid TEXT NOT NULL,
    person_uuid TEXT NOT NULL,
    department TEXT NOT NULL, -- 'Director', 'Writer', 'Producer', 'Composer', 'Editor', etc
    role TEXT, -- Specific role: 'Writer (story by)', 'Executive Producer', etc
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_genres (
    film_uuid TEXT NOT NULL,
    genre_id INTEGER NOT NULL,
    PRIMARY KEY (film_uuid, genre_id),
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_languages (
    film_uuid TEXT NOT NULL,
    language_id INTEGER NOT NULL,
    PRIMARY KEY (film_uuid, language_id),
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (language_id) REFERENCES languages (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_locations (
    film_uuid TEXT NOT NULL,
    location_id INTEGER NOT NULL,
    PRIMARY KEY (film_uuid, location_id),
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    FOREIGN KEY (location_id) REFERENCES locations (id) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE film_plot_summaries (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    film_uuid TEXT NOT NULL,
    summary TEXT NOT NULL,
    author TEXT,
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE
)

Columns

Sample Data

No sample rows available.

Create SQL

CREATE TABLE films (
    uuid TEXT PRIMARY KEY,
    imdb_id TEXT UNIQUE NOT NULL, -- tt9567458
    imdb_url TEXT,
    title TEXT NOT NULL,
    -- Box Office
    box_office_date TEXT,
    budget TEXT,
    opening_weekend TEXT,
    gross_us_canada TEXT,
    gross_world TEXT,
    release_date TEXT,
    release_year INTEGER,
    -- Details
    release_country TEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

Columns

Sample Data

Create SQL

CREATE TABLE genres (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT UNIQUE NOT NULL
)

Columns

Sample Data

Create SQL

CREATE TABLE languages (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT UNIQUE NOT NULL
)

Columns

Sample Data

Create SQL

CREATE TABLE locations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    address TEXT, -- from details.filmingLocations[].specificLocation
    city TEXT,
    province TEXT,
    country TEXT,
    UNIQUE (address, city, province, country)
)

Columns

Sample Data

Create SQL

CREATE TABLE people (
    uuid TEXT PRIMARY KEY,
    imdb_id TEXT UNIQUE NOT NULL, -- nm1729303
    name TEXT NOT NULL,
    -- From people_details.about
    bio TEXT,
    height TEXT,
    -- Image from cast[] or people_details
    image_url TEXT,
    -- Star meter from cast[] or people_details
    star_meter INTEGER,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

Columns

Sample Data

Create SQL

CREATE TABLE people_performer_details (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_uuid TEXT NOT NULL UNIQUE,
    height TEXT,
    locations TEXT,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE person_aka (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_uuid TEXT NOT NULL,
    name TEXT NOT NULL,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE,
    UNIQUE (person_uuid, name)
)

Columns

Sample Data

Create SQL

CREATE TABLE person_collaborations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_a_uuid TEXT NOT NULL,
    person_b_uuid TEXT NOT NULL,
    film_uuid TEXT NOT NULL,
    dept_a TEXT,
    dept_b TEXT,
    FOREIGN KEY (person_a_uuid) REFERENCES people (uuid) ON DELETE CASCADE,
    FOREIGN KEY (person_b_uuid) REFERENCES people (uuid) ON DELETE CASCADE,
    FOREIGN KEY (film_uuid) REFERENCES films (uuid) ON DELETE CASCADE,
    UNIQUE (person_a_uuid, person_b_uuid, film_uuid)
)

Columns

Sample Data

Create SQL

CREATE TABLE person_companies (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_uuid TEXT NOT NULL,
    company_uuid TEXT NOT NULL,
    -- From keyStaff/staff employment
    branch TEXT, -- 'Burbank, CA'
    occupation TEXT, -- 'Executive'
    job_title TEXT, -- 'Chairman, Warner Bros. Pictures Group'
    job_type TEXT, -- 'Executive', 'Producer', etc
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE,
    FOREIGN KEY (company_uuid) REFERENCES companies (uuid) ON DELETE CASCADE
)

Columns

Sample Data

Create SQL

CREATE TABLE person_known_titles (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_uuid TEXT NOT NULL,
    title_imdb_id TEXT,
    title TEXT,
    role TEXT,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE
)

Columns

Sample Data

No sample rows available.

Create SQL

CREATE TABLE person_socials (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    person_uuid TEXT NOT NULL,
    site TEXT NOT NULL, -- 'instagram', 'twitter', etc
    url TEXT NOT NULL,
    FOREIGN KEY (person_uuid) REFERENCES people (uuid) ON DELETE CASCADE,
    UNIQUE (person_uuid, site, url)
)

Columns

Sample Data