ticketsystem
Tables (6)
Category (공연카테고리)
- id (category_id) — bigInt — Primary key — NOT NULL
- 종류 (type) — varchar(100)
Member (member)
- 회원id (member_id) — bigInt — Primary key — NOT NULL
- 닉네임 (username) — varchar(255)
Reservation (예약)
- 예약id (id) — bigInt — Primary key — NOT NULL
- 공연id (show_id) — bigInt — Foreign key → Show.공연id — NOT NULL
- 회원id (member_id) — bigInt — Foreign key → Member.회원id — NOT NULL
- 예약일시 (Field2)
- 상태 (statud) — boolean
ReservationSeats (예약좌석)
- id — bigInt — Primary key — NOT NULL
- 좌석id (seat_id) — bigInt — Foreign key → Seats.좌석id — NOT NULL
- 예약id (Key) — bigInt — Foreign key → Reservation.예약id — NOT NULL
- 상태 (status) — boolean
Seats (좌석)
- 좌석id (seat_id) — bigInt — Primary key — NOT NULL
- 공연id (show_id) — bigInt — Foreign key → Show.공연id — NOT NULL
- 좌석번호 (num) — varchar
- 상태 (status) — boolean
Show (공연)
- 공연id (show_id) — bigInt — Primary key — NOT NULL
- 카테고리 (category_id) — bigInt — Foreign key → Category.id — NOT NULL
- 공연이름 (title) — varchar(255)
- 공연장소 (place) — varchar(255)
- 공연날짜 (showDate) — date
- 가격 (price) — int