test

테이블 (4)

예매 정보 (reservation)

  • reservationNumber — VARCHAR(50) — 기본 키 — NOT NULL
  • performanceId — VARCHAR(50) — NOT NULL
  • memberId — varchar(15) — 외래 키 → 회원 정보.memberId — NOT NULL
  • performanceName — VARCHAR(255) — NOT NULL
  • runtime — TIME — NOT NULL
  • venue — VARCHAR(50) — NOT NULL
  • selectedTime — TIME — NOT NULL
  • selectedDay — DATE — NOT NULL
  • selectedPrice — VARCHAR(20) — NOT NULL

예매 취소 정보 (refund)

  • refundNumber — VARCHAR(50) — 기본 키 — NOT NULL
  • reservationNumber — VARCHAR(50) — NOT NULL
  • memberId — VARCHAR(15) — 외래 키 → 회원 정보.memberId — NOT NULL
  • performanceName — VARCHAR(50) — NOT NULL
  • refundPrice — VARCHAR(20) — NOT NULL
  • refundDate — DATE — NOT NULL

회원 정보 (member)

  • memberId — varchar(15) — 기본 키 — NOT NULL
  • memberName — varchar(20) — NOT NULL
  • memberPw — varchar(255) — NOT NULL
  • gender — char(1) — NOT NULL
  • email — varchar(30) — NOT NULL
  • phone — char(11) — NOT NULL

후기 (review)

  • reviewId — INT — NOT NULL
  • memberId — VARCHAR(15) — NOT NULL
  • performanceId — VARCHAR(50) — NOT NULL
  • reviewTitle — VARCHAR(255) — NOT NULL
  • reviewContent — TEXT — NOT NULL
  • reviewDate — DATE — NOT NULL