ml-100k

Tables (7)

Data

  • ID — int — Primary key — NOT NULL
  • U_id (userid) — int — Foreign key → User.U_id — NOT NULL
  • movie_id — int — Foreign key → Item.movie_id — NOT NULL
  • MyUnkownColumn (myunknowncolumn) — int — Foreign key → Item.MyUnkownColumn
  • item_id — int
  • rating — int
  • timestamp_utc — int

Genre

  • genre — varchar — Primary key — NOT NULL
  • ID (ID2) — int — Foreign key → Info.ID — NOT NULL
  • MyUnkownColumn (myunknowncolumn2) — int — Foreign key → Info.MyUnkownColumn
  • movie_id — int — Foreign key → Item.movie_id — NOT NULL
  • MyUnkownColumn (myunknowncolumn) — int — Foreign key → Item.MyUnkownColumn
  • g_cd — int

Info

  • ID (ID2) — int — Foreign key → Data.ID — NOT NULL
  • movie_id — int — Foreign key → Data.movie_id — NOT NULL
  • MyUnkownColumn (myunknowncolumn) — int — Foreign key → Data.MyUnkownColumn
  • value — int
  • variable — varchar

Item (item)

  • movie_id — int — Primary key — NOT NULL
  • MyUnkownColumn (myunknowncolumn) — int — Primary key
  • movie_title — varchar
  • release_date — varchar
  • video_release_date — varchar
  • IMDb_url — varchar
  • unknown — int
  • Action (action) — int
  • Adventure (adventure) — int
  • Animation (animation) — int
  • children — int
  • Comedy (comedy) — int
  • Crime (crime) — int
  • Docu (Field) — int
  • Drame (drame) — int
  • Fantasy (fantasy) — int
  • Noir (noir) — int
  • Horror (horror) — int
  • Musical (musical) — int
  • Mystery (mystery) — int
  • Romance (romance) — int
  • Scifi (scifi) — int
  • Thriler (thriller) — int
  • War (war) — int
  • Western (western) — int

Occupation

  • ID — varchar — Primary key — NOT NULL
  • Occupation (occupation) — varchar — Primary key — NOT NULL
  • MuUnknownColumn (myunkowncolumn) — int

Untitled

    User

    • U_id (userid) — int — Primary key — NOT NULL
    • Occupation (occupation) — varchar — Foreign key → Occupation.Occupation — NOT NULL
    • Age (age) — int
    • Gender (gender) — varchar
    • zip_code — varchar