movie-pjt

Tables (11)

Actor

  • actor_id — INT
  • name — VARCHAR(255) — NOT NULL

Actors

  • actor_id — INTEGER
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

Admins

  • admin_id — INT
  • user_id — INT

Comment_Likes

  • user_id — INTEGER — Foreign key — NOT NULL
  • comment_id — INTEGER — Foreign key — NOT NULL
  • created_at — TIMESTAMP

Comments

  • comment_id — INT
  • user_id — INT
  • movie_id — INT
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Follows

  • following_user_id — INT
  • followed_user_id — INT
  • created_at — TIMESTAMP

Likes

  • like_id — INT
  • user_id — INT
  • movie_id — INT
  • comment_id — INT
  • created_at — TIMESTAMP

Movie_Actors

  • movie_id — INTEGER — Foreign key — NOT NULL
  • actor_id — INTEGER — Foreign key → Actors.actor_id — NOT NULL
  • created_at — TIMESTAMP

Movies

  • movie_id — INT
  • title — VARCHAR(255) — NOT NULL
  • overview — TEXT
  • release_date — DATE
  • poster_path — VARCHAR(255)
  • like_count — INT
  • rating — FLOAT
  • created_at — TIMESTAMP
  • actor_id — INT

User_Movie_Likes

  • user_id — INTEGER — Foreign key — NOT NULL
  • movie_id — INTEGER — Foreign key — NOT NULL
  • created_at — TIMESTAMP

Users

  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP