데베설
테이블 (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