ROCK_DB
테이블 (23)
actors (배우)
- actor_id — BIGINT — 기본 키 — NOT NULL
- actor_name — VARCHAR(255)
- actor_birth — INT
actors_photos (배우 사진)
- photo_id — BIGINT — 기본 키 — NOT NULL
- actor_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `actor_id`
b (board)
- board_id — BIGINT — 기본 키 — NOT NULL
- create_date — VARCHAR(255)
- modify_date — VARCHAR(255)
- board_content — VARCHAR(255) — NOT NULL
- board_title — VARCHAR(255) — NOT NULL
- board_view_count — INT — NOT NULL
- mem_num — BIGINT
- INDEX — `FKr2o1ku8wdunohritdfecbk8t3`
directors_photos (감독_사진)
- photo_id — BIGINT — 기본 키 — NOT NULL
- director_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `director_id`
email_verifications (이메일 인증)
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- expiry_date — DATETIME(6) — NOT NULL
- token — VARCHAR(255)
- verification_code — VARCHAR(255)
- verified — BIT(1) — NOT NULL
member (회원)
- mem_num — BIGINT — 기본 키 — NOT NULL
- mem_birth — DATE — NOT NULL
- mem_email — VARCHAR(255) — NOT NULL
- mem_gender — VARCHAR(255) — NOT NULL
- mem_id — VARCHAR(255) — NOT NULL
- mem_name — VARCHAR(255) — NOT NULL
- mem_password — VARCHAR(255) — NOT NULL
- mem_role — ENUM('ADMIN', 'USER') — NOT NULL
- mem_tel — VARCHAR(255) — NOT NULL
movie_directors
- movie_id — BIGINT — 기본 키 — NOT NULL
- director_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `director_id`
movie_favor
- mem_num — BIGINT — 기본 키 — NOT NULL
- movie_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `FKnx7britwk7ojua8u4iow8uhjl`
movie_films
- film_id — BIGINT — 기본 키 — NOT NULL
- movie_film — VARCHAR(255)
- movie_id — BIGINT
movie_genres
- movie_id — BIGINT — 기본 키 — NOT NULL
- genre_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `genre_id`
movie_posters
- poster_id — BIGINT — 기본 키 — NOT NULL
- movie_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `movie_id`
movie_trailers
- trailer_id — BIGINT — 기본 키 — NOT NULL
- movie_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `movie_id`
password_reset_token
- id — BIGINT — 기본 키 — NOT NULL
- expiry_date — DATETIME(6) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- mem_id — BIGINT — NOT NULL
photos (사진)
- photo_id — BIGINT — 기본 키 — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- photo_type — ENUM('ACTOR', 'DIRECTOR') — NOT NULL
posters
- poster_id — BIGINT — 기본 키 — NOT NULL
- poster_url — VARCHAR(255)
reviews
- review_id — BIGINT — 기본 키 — NOT NULL
- create_date — VARCHAR(255)
- modify_date — VARCHAR(255)
- review_content — VARCHAR(255) — NOT NULL
- review_rating — DOUBLE — NOT NULL
- mem_num — BIGINT — NOT NULL
- movie_id — BIGINT — NOT NULL
- INDEX — `FKnp7fbfa9s2gfpdpt19l96fqcv`
- INDEX — `FK87tlqya0rq8ijfjscldpvvdyq`
trailers
- trailer_id — BIGINT — 기본 키 — NOT NULL
- trailer_url — VARCHAR(255)
감독 (directors)
- director_id — BIGINT — 기본 키 — NOT NULL
- director_name — VARCHAR(255)
- director_birth — INT
공지사항_첨부파일 (board_file)
- board_file_id — BIGINT — 기본 키 — NOT NULL
- board_file_path — VARCHAR(255)
- board_file_type — VARCHAR(255)
- board_origin_file_name — VARCHAR(255)
- board_id — BIGINT
- INDEX — `FK7y5mp0lksehqt19ibjdx5xufo`
영화 (movies)
- movie_id — BIGINT — 기본 키 — NOT NULL
- movie_name — VARCHAR(255)
- run_time — INT
- open_year — INT
- movie_rating — VARCHAR(50)
- movie_description — TEXT
영화_배우 (movie_actors)
- movie_id — BIGINT — 기본 키 — NOT NULL
- actor_id — BIGINT — 기본 키 — NOT NULL
- INDEX — `actor_id`
장르 (genres)
- genre_id — BIGINT — 기본 키 — NOT NULL
- genre_name — VARCHAR(100) — NOT NULL