re_VANILLA
Tables (14)
Comment (Untitled4)
- pk (Key) — integeer — Primary key — NOT NULL
- content (Field) — varchar
- user (Key2) — integer — Foreign key → User.pk — NOT NULL
- review (Key3) — integer — Foreign key → Review.pk — NOT NULL
- created_at (Field2) — date
- is_bad (Field3) — boolea
Following (Untitled11)
- pk (Key2) — integer — Primary key — NOT NULL
- following (Key) — integer — Foreign key → User.pk — NOT NULL
- follower (Key3) — integer — Foreign key → User.pk — NOT NULL
Genre (Untitled7)
- pk (Key) — Primary key — NOT NULL
- kname (Field) — varchar
- ename (Field2) — varchar
Genre Counter (Untitled8)
- pk (Key) — integer — Primary key — NOT NULL
- counter (Field) — float
- genre (Key2) — integer — Foreign key → Genre.pk — NOT NULL
- user (Key3) — integer — Foreign key → User.pk — NOT NULL
Liked_review (Untitled6)
- pk (Key3) — integer — Primary key — NOT NULL
- liked_review (Key2) — integer — Foreign key → Review.pk — NOT NULL
- liked_user (Key) — integer — Foreign key → User.pk — NOT NULL
Movie (Untitled9)
- pk (Key) — integer — Primary key — NOT NULL
- genre (Key2) — integer — Foreign key → Genre.pk — NOT NULL
- ktitle (Field) — varchar
- etitle (Field2) — varchar
- koverview (Field3) — varchar
- eoverview (Field4) — varchar
- release_date (Field5) — date
- popularity (Field6) — float
- vote_count (Field7) — integer
- vote_average (Field8) — float
- poster_path (Field9) — varchar
- backdrop_path (Field10) — varchar
- original_title (Field11) — varchar
- adult (Field12) — boolean
Recomment (Untitled5)
- pk (Key) — integer — Primary key — NOT NULL
- content (Field) — varchar
- comment (Key2) — integeer — Foreign key → Comment.pk — NOT NULL
- user (Key3) — integer — Foreign key → User.pk — NOT NULL
- created_at (Field2) — date
- is_bad (Field3) — boolean
Report (Untitled12)
- pk (Key) — integer — Primary key — NOT NULL
- sort (Field) — varchar
- r_id (Field2) — integer
- reported_at (Field3) — date
- isresolved (Field4) — boolean
- user (Key2) — integer — Foreign key → User.pk — NOT NULL
Review (Untitled2)
- pk (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar
- content (Field2) — varchar
- rating (Field3) — integer
- user (Key2) — integer — Foreign key → User.pk — NOT NULL
- Field4
- movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
- genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
- created_at (Field5) — date
- updated_at (Field6) — date
- is_bad (Field7) — boolean
ShortReview (Untitled3)
- pk (Key) — integer — Primary key — NOT NULL
- content (Field) — varchar
- rating (Field2) — integer
- user (Key2) — integer — Foreign key → User.pk — NOT NULL
- movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
- genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
- created_at (Field3) — date
- is_bad (Field4) — boolean
User (Untitled)
- pk (Key) — integer — Primary key — NOT NULL
- username (Field) — varchar
- nickname (Field2) — varchar
- password (Field3) — varchar
- gender (Field4) — varchar
- date_of_birth (Field5) — date
- email (Field6) — email
gender age counter (Untitled10)
- pk (Key) — integer — Primary key — NOT NULL
- counter (Field) — integer
- gender (Field2) — varchar
- ages (Field3) — varchar
- movie (Key2) — integer — Foreign key → Movie.pk — NOT NULL
- genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
liked_movies (Untitled13)
- pk (Key) — integer — Primary key — NOT NULL
- liked_user (Key2) — integer — Foreign key → User.pk — NOT NULL
- liked_movie (Key3) — integer — Foreign key → Movie.pk — NOT NULL
- genre (Key22) — integer — Foreign key → Movie.genre — NOT NULL
liked_shortreview (Untitled14)
- pk (Key) — integer — Primary key — NOT NULL
- liked_user (Key2) — integer — Foreign key → User.pk — NOT NULL
- liked_sr (Key3) — integer — Foreign key → ShortReview.pk — NOT NULL