finalPJT
Tables (4)
Comment (Untitled3)
- Key — Primary key — NOT NULL
- user (Key2) — integer — Foreign key → Review.Key — NOT NULL
- movie (Key22) — text — Foreign key → Review.user — NOT NULL
- review (Key3) — text — Foreign key → Review.movie_title — NOT NULL
- content (Field) — text
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
Movie (Untitled4)
- Key — integer — Primary key — NOT NULL
- title (Field) — text
- overview (Field2) — text
- release_date (Field3) — date
- poster_path (Field4) — text
- Field5
Review (Untitled2)
- Key — Primary key — NOT NULL
- user (Key2) — text — Foreign key → User.id — NOT NULL
- movie_title (Key3) — text — Foreign key → Movie.Key — NOT NULL
- title (Field) — text
- content (Field2) — text
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
- rank (Field5) — integer
User (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- email (Field2) — text
- password (Field3) — text
- is_staff (Field4) — bool
- is_superuser (Field5) — bool