1인프로젝트
테이블 (3)
공연 (performanceinfo)
- performance_id (perf_id) — varchar2(30) — 기본 키 — NOT NULL
- title (perf_title) — varchar2(30)
- category (perf_cate) — varchar2(30)
- price — number
- total_seat — number
- remaining_seat (remain_seat) — number
- location (perf_loc) — varchar2(50)
- performance_date (perf_date) — date
사용자 (userinfo)
- user_id — varchar2(30) — 기본 키 — NOT NULL
- user_pw — varchar2(30)
- user_name — varchar2(30)
- user_email — varchar2(30)
- user_address — varchar2(50)
- user_phone — varchar2(30)
예매정보 (reservation)
- reservation_id (res_id) — number — 기본 키 — NOT NULL
- reservation_date (res_date) — date
- performance_seat (perf_seat) — varchar2(20)
- performance_id (perf_id) — varchar2(30) — 외래 키 → 공연.performance_id — NOT NULL
- user_id — varchar2(30) — 외래 키 → 사용자.user_id — NOT NULL