hhplus-concert-server-java
Tables (9)
Concert (Untitled5)
- id — int — Primary key — NOT NULL
- title — varchar
- status — int
- createdAt — datetime
- updatedAt — datetime
ConcertSeat (Untitled7)
- id — int — Primary key — NOT NULL
- concet_time_id (concert_time_id) — int — Foreign key → ConcertTime.id — NOT NULL
- status — int
- createdAt — datetime
- updatedAt — datetime
ConcertTime (Untitled6)
- id — int — Primary key — NOT NULL
- concert_id — int — Foreign key → Concert.id — NOT NULL
- start_time — datetime
- end_time — datetime
- max_cnt — int
- left_cnt — int
- price (Field) — int
- Field2
Point (Untitled3)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- balance — int
PointHistory (Untitled4)
- id — int — Primary key — NOT NULL
- point_id — int — Foreign key → Point.id — NOT NULL
- status — int
- createdAt — int
- updatedAt — int
User (Untitled)
- id — int — Primary key — NOT NULL
- name — int
WaitQueue (Untitled2)
- id — int — Primary key — NOT NULL
- uuid (Field) — string
- status — int
- createdAt — datetime
- updatedAt — datetime
payment (Untitled9)
- id (Key) — 결제ID — Primary key — NOT NULL
- reservation_id (id) — int — Foreign key → reservation.id — NOT NULL
- status (Field) — String
- use_point (Field2)
- pointHistory (id2) — int — Foreign key → PointHistory.id — NOT NULL
reservation (Untitled8)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- Field
- concet_seat_id (id2) — int — Foreign key → ConcertSeat.id — NOT NULL