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