테스트

테이블 (8)

member

  • member_id — varchar2(50) — 기본 키 — NOT NULL
  • password — varchar2(50) — NOT NULL
  • member_name — varchar2(50) — NOT NULL
  • member_ssn — char(7) — NOT NULL
  • email — varchar2(50)
  • phone — char(11)
  • preference_genre — varchar2(255)
  • member_status — char(1)
  • member_grade — varchar2(50)
  • enroll_date — date
  • point — number

movie

  • movie_title — varchar2(255) — 기본 키 — NOT NULL
  • movie_link — varchar2(255)
  • movie_img — varchar2(255)
  • movie_subtitle — varchar2(1000)
  • opening_date — varchar2(50)
  • movie_director — varchar2(50)
  • movie_actor — varchar2(1000)
  • movie_rate — number

product

  • product_no — number — 기본 키 — NOT NULL
  • pd_category — char(1)
  • product_name — varchar2(50)
  • product_price — number
  • stock — number
  • accumulate_sale — number
  • pd_status — char(1)
  • pd_img — varchar2(255)
  • pd_info — varchar2(255)

screen_info

  • screen_no — varchar2(50) — 기본 키 — NOT NULL
  • movie_title — varchar2(255) — NOT NULL
  • manager_id — varchar2(50)
  • theater_no — varchar2(50) — NOT NULL
  • start_time — timestamp
  • end_time — timestamp
  • total_ticket — number
  • sold_ticket — number

screen_movie

  • movie_title — varchar2(255) — 기본 키 — NOT NULL
  • genre — varchar2(500)
  • main_poster — varchar2(255)
  • poster — varchar2(255)
  • steel_cut — varchar2(255)
  • trailer — varchar2(255)
  • synopsis — varchar2(1000)
  • purchase_rate — number
  • screening_rate — char(1)
  • screnn_status — char(1)

seat

  • seat_no — varchar2(50) — 기본 키 — NOT NULL
  • theater_no — varchar2(50) — NOT NULL
  • seat_status — char(1)

theater

  • theater_no — varchar2(50) — 기본 키 — NOT NULL
  • theater_seat — number
  • theater_status — char(1)

ticket

  • ticket_no — varchar2(50) — 기본 키 — NOT NULL
  • member_id — varchar2(50)
  • screen_no — varchar2(50) — NOT NULL
  • seat_no — varchar2(50)
  • ticket_price — number
  • ticket_status — char(1)