5jodda
Tables (5)
Genre
- Key (id) — Integer — Primary key — NOT NULL
- name — VARCHAR(20)
Movie
- id — Integer — Primary key — NOT NULL
- title — VARCHAR(30)
- audience — Integer
- poster_url — VARCHAR(140)
- description — Text
Untitled (Movie-Genre)
- id (movie_id) — Integer — Foreign key → Movie.id — NOT NULL
- Key (genre_id) — Integer — Foreign key → Genre.Key — NOT NULL
Untitled (User)
- Key (id) — Integer — Primary key — NOT NULL
- Field (username) — VARCHAR(150)
- Field (password) — VARCHAR(128)
- Field (email) — VARCHAR
Untitled (Review)
- Key (user_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- id (movie_id) — Integer — Foreign key → Movie.id — NOT NULL
- Field (content) — VARCHAR(140)
- Field (score) — Float