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