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)