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