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
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