movie_erd

Tables (13)

cast_member

  • cast_member_id — INT
  • name — VARCHAR(255)
  • bio — TEXT
  • birthdate — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

genres

  • genre_id — INT
  • name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

genres_movies

  • movie_id — INT
  • genre_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

movie_cast_member

  • movie_id — INT
  • cast_member_id — INT
  • role_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

movie_metadata

  • movie_metadata_id — INT
  • movie_id — INT
  • keywords — TEXT
  • production_country — VARCHAR(255)
  • language — VARCHAR(100)
  • budget — BIGINT
  • revenue — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

movies

  • movie_id — INT
  • title — VARCHAR(255)
  • release_date — DATE
  • runtime — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ratings

  • rating_id — INT
  • user_id — INT
  • movie_id — INT
  • score — DECIMAL(2, 1)
  • description — TEXT
  • rating_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

recommendations

  • recommendation_id — INT
  • user_id — INT
  • recommended_movies — TEXT
  • recommendation_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

role

  • role_id — INT
  • role_name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_feedback

  • feedback_id — INT
  • user_id — INT
  • movie_id — INT
  • feedback — TEXT
  • feedback_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — INT
  • name — VARCHAR(255)
  • email — VARCHAR(255)
  • gender — gender_type
  • age — INT
  • join_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users_genre

  • users_genre_id — INT
  • user_id — INT
  • genre_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

viewing_history

  • history_id — INT
  • user_id — INT
  • movie_id — INT
  • view_date — DATE
  • view_duration — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP