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`

board_file_seq

  • next_val — BIGINT

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