pocha
Tables (7)
Untitled (collaborative)
- Key (id) — Primary key — NOT NULL
- id (customer_id) — Foreign key → customer.id — NOT NULL
- Field (item_id_list)
Untitled (contents_based)
- Key (id) — Primary key — NOT NULL
- id (item_id) — Foreign key → inventory.id — NOT NULL
- Field (feature)
- Field2 (item_id_list)
customer
- id — Primary key — NOT NULL
- Field (gender)
- Field2 (age)
- Field (age_group)
- Field (married)
- Field2 (kids_under12)
- Field3 (area)
- Field (subs_start_year)
down (download)
- Key (id) — Primary key — NOT NULL
- id (customer_id) — Foreign key → customer.id — NOT NULL
- Key (item_id) — Foreign key → inventory.Key — NOT NULL
- Field (down_date)
- Field2 (down_year)
- Field3 (down_month)
- Field4 (down_weekday)
inventory (item)
- Key (id) — Primary key — NOT NULL
- id (movie_id) — Foreign key → movie.id — NOT NULL
- Field (contract_year)
movie
- id — Primary key — NOT NULL
- Field (imdb_id)
- Field2 (title)
- Field3 (release_year)
- Field4 (release_date)
- Field5 (runtime)
- Field6 (mpa_rating)
- Field (imdb_score)
- Field2 (votes)
- Field3 (reviews_users)
- Field4 (reviews_critics)
- Field5 (budget)
- Field6 (income_usa)
- Field7 (income_ww)
- Field8 (theater_opening)
- Field9 (theater_total)
- Field10 (country_1)
- Field (country_2)
- Field (country_3)
- Field (studio)
- Field (director)
- Field (Genre_1)
- Field (Genre_2)
- Field (Genre_3)
- Field (Genre_4)
- Field (Genre_5)
- Field (Genre_6)
- Field (Genre_7)
- Field (Genre_8)
- Field (awards)
- Field (contract_price)
- Field (studio_score)
- Field (price_class)
- Field (writer_1)
- Field (writer_2)
- Field (actor_1)
- Field (actor_2)
- Field (actor_3)
- Field (description)
- Field (storyline)
recommend (association)
- Key (id) — Primary key — NOT NULL
- id (item_id) — Foreign key → inventory.id — NOT NULL
- Field (item_id_list)