movielens project

Tables (4)

Data

  • mid — INT — Foreign key → Movie.mid — NOT NULL
  • uid — INT — Foreign key → User.uid — NOT NULL
  • rating — INT
  • timestamp — TIMESTAMP

Genre

  • genre — VARCHAR(20) — Primary key — NOT NULL
  • mid — INT — Foreign key → Movie.mid — NOT NULL

Movie

  • mid — INT — Primary key — NOT NULL
  • titleName — VARCHAR(100)
  • releaseDate — DATE
  • IMDbUrl — VARCHAR(100)

User

  • uid — INT — Primary key — NOT NULL
  • age — INT
  • gender — CHAR(1)
  • zipcode — INT