데베설

테이블 (16)

Admin

  • admin_id — VARCHAR2(50) — 기본 키
  • username — VARCHAR2(100)
  • password — VARCHAR2(100) — NOT NULL

CodeDetail

  • code_detail_id — NUMBER — 기본 키
  • code_group_id — NUMBER — NOT NULL
  • code_name — VARCHAR2(100) — NOT NULL
  • code_value — VARCHAR2(50) — NOT NULL

CodeGroup

  • code_group_id — NUMBER — 기본 키
  • code_group_name — VARCHAR2(100) — NOT NULL

Discount

  • discount_id — NUMBER — 기본 키
  • discount_type — VARCHAR2(50)
  • discount_rate — NUMBER
  • discount_amount — NUMBER

Guest

  • guest_id — NUMBER — 기본 키
  • phone — VARCHAR2(20) — NOT NULL
  • name — VARCHAR2(50)
  • registration_number — VARCHAR2(14)

Member

  • member_id — NUMBER — 기본 키
  • username — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(100) — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • point — NUMBER
  • grade — VARCHAR2(20)
  • birthdate — DATE

Movie

  • movie_id — NUMBER — 기본 키
  • title — VARCHAR2(100) — NOT NULL
  • runtime — NUMBER
  • genre — VARCHAR2(50)
  • rating — VARCHAR2(10)
  • description — CLOB

MoviePerson

  • movie_id — NUMBER — 기본 키 — NOT NULL
  • person_id — NUMBER — 기본 키 — NOT NULL
  • role — VARCHAR2(50) — 기본 키 — NOT NULL

Payment

  • payment_id — NUMBER — 기본 키
  • payment_type — VARCHAR2(20)
  • payment_date — DATE
  • payment_status — VARCHAR2(20)
  • payment_point — NUMBER
  • ticket_id — NUMBER — NOT NULL
  • amount — NUMBER — NOT NULL
  • approval_id — VARCHAR2(50)

PaymentDiscount

  • payment_id — NUMBER — 기본 키 — NOT NULL
  • discount_id — NUMBER — 기본 키 — NOT NULL

Person

  • person_id — NUMBER — 기본 키
  • name — VARCHAR2(100) — NOT NULL

Screening

  • screening_id — NUMBER — 기본 키
  • start_time — TIMESTAMP — NOT NULL
  • round — NUMBER — NOT NULL
  • movie_id — NUMBER — NOT NULL
  • theater_id — NUMBER — NOT NULL

ScreeningSeat

  • seat_id — NUMBER — 기본 키 — NOT NULL
  • screening_id — NUMBER — 기본 키 — NOT NULL
  • ticket_id — NUMBER

Seat

  • seat_id — NUMBER — 기본 키
  • row_num — NUMBER — NOT NULL
  • col_num — NUMBER — NOT NULL
  • theater_id — NUMBER — NOT NULL

Theater

  • theater_id — NUMBER — 기본 키
  • location — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(100)

Ticket

  • ticket_id — NUMBER — 기본 키
  • base_price — NUMBER — NOT NULL
  • buyer_member_id — NUMBER
  • buyer_guest_id — NUMBER
  • screening_id — NUMBER