Final_Project

Tables (19)

Actor

  • id (Key) — Primary key — NOT NULL
  • name (Field) — char(30)
  • gender (Field2) — int
  • birthday (Field3) — date
  • deathday (Field4) — date
  • profile_img (Field5) — image
  • biography (Field6) — text

Actor_Movie

  • id (Key) — Primary key — NOT NULL
  • actor_id (Key2) — Foreign key → Actor.id — NOT NULL
  • movie_id (Key3) — Foreign key → Movie.id — NOT NULL

Challenge (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field5) — Char(100)
  • reward (Field2) — int
  • created_at (Field3) — date
  • expirated_at (Field4) — date

Challenge_Complete

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • chalenge_id (Key3) — Foreign key → Challenge.id — NOT NULL

Challenge_Movie (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • Movie_id (Key2) — Foreign key → Movie.id — NOT NULL
  • Chalenge_id (Key3) — Foreign key → Challenge.id — NOT NULL

Co-Comment

  • id (Key) — Primary key — NOT NULL
  • comment_id (Key2) — Foreign key → Comment.id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — date

Comment

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • review_id (Key3) — Foreign key → Review.id — NOT NULL
  • comment (Field) — text
  • created_at (Field2) — date

Director

  • id (Key) — Primary key — NOT NULL
  • name (Field) — char(30)
  • gender (Field2) — int
  • birthday (Field3) — date
  • deathday (Field4) — date
  • profile_img (Field5) — image
  • biography (Field6) — text

Director_Movie

  • id (Key) — Primary key — NOT NULL
  • director_id (Key2) — Foreign key → Director.id — NOT NULL
  • movie_id (Key3) — Foreign key → Movie.id — NOT NULL

Followed_Following

  • id (Key) — Primary key — NOT NULL
  • follower_id (Key2) — Foreign key → User.id — NOT NULL
  • following_id (Key3) — Foreign key → User.id — NOT NULL

Genre

  • id (Key) — Primary key — NOT NULL
  • name (Field) — char(30)

Genre_Like

  • id (Key) — Primary key — NOT NULL
  • genre_id (Key2) — Foreign key → Genre.id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL

Movie

  • id (Key) — Primary key — NOT NULL
  • title (Field) — char(100)
  • release_date (Field2) — date
  • poseter_url (Field3) — url(200)
  • overview (Field4) — text

Movie_Genre

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.id — NOT NULL
  • genre_id (Key3) — Foreign key → Genre.id — NOT NULL

Movie_Like

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL

Rating

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • movie_id (Key3) — Foreign key → Movie.id — NOT NULL
  • score (Field) — int

Review

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL
  • title (Field) — char(30)
  • content (Field2) — text
  • created_at (Field3) — datefiled

Review_Like

  • id (Key) — Primary key — NOT NULL
  • review_id (Key2) — Foreign key → Review.id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL

User

  • id (Key) — Primary key — NOT NULL
  • email (Field4) — text
  • password (Field3) — int
  • name (Field2) — Char
  • profile_img (Field5) — img
  • level (Field6) — int
  • exp (Field7) — int
  • bio (Field8) — text