deepseek 영화예매사이트

테이블 (9)

movie

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • summary — TEXT
  • open_date — TIMESTAMP

movie_genre

  • id — BIGINT
  • movie_id — BIGINT — 외래 키 → movie.id — NOT NULL
  • genre — VARCHAR(20) — NOT NULL

reservation

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • screen_info_id — BIGINT — 외래 키 → screen_info.id — NOT NULL
  • seat_id — BIGINT — 외래 키 → seat.id — NOT NULL
  • reserve_name — VARCHAR(30) — NOT NULL

screen

  • id — BIGINT
  • theater_id — BIGINT — 외래 키 → theater.id — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • price — BIGINT

screen_info

  • id — BIGINT
  • movie_id — BIGINT — 외래 키 → movie.id — NOT NULL
  • show_time_id — BIGINT — 외래 키 → show_time.id — NOT NULL

seat

  • id — BIGINT
  • screen_id — BIGINT — 외래 키 → screen.id — NOT NULL
  • seat_number — VARCHAR(10) — NOT NULL
  • reserve_status — BOOLEAN

show_time

  • id — BIGINT
  • theater_id — BIGINT — 외래 키 → theater.id — NOT NULL
  • screen_id — BIGINT — 외래 키 → screen.id — NOT NULL
  • start_time — TIMESTAMP — NOT NULL
  • end_time — TIMESTAMP — NOT NULL

theater

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • location — VARCHAR(100) — NOT NULL

users

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20)
  • birth_date — DATE
  • email — VARCHAR(100)
  • created_at — TIMESTAMP
  • grade — VARCHAR(20)
  • password — VARCHAR(255) — NOT NULL