tickeSync
Tables (5)
performances (공연)
- id — Long — Primary key — NOT NULL
- title — String
- venue — String
- performance_start_data (performance_start_date) — TIMESTAMP
- performance_end_data — TIMESTAMP
- performance_time — TIMESTAMP
- created_at — TIMESTAMP
reservation_seats (Untitled)
- reservation_id — LONG — Foreign key → reservations.id — NOT NULL
- seat_id — LONG — Foreign key → seats.id — NOT NULL
- status — enum
- reservation_date — TIMESTAMP
reservations (예약)
- id — Long — Primary key — NOT NULL
- id (user_id) — LONG — Foreign key → users.id — NOT NULL
- id (performance_id) — LONG — Foreign key → performances.id — NOT NULL
- status — enum
- total_amount — int
- created_at — TIMESTAMP
seats (좌석)
- id — Long — Primary key — NOT NULL
- id (performance_id) — LONG — Foreign key → performances.id — NOT NULL
- section — enum
- row_no — int
- seat_no — int
- price — int
- created_at — TIMESTAMP
users (사용자)
- id — Long — Primary key — NOT NULL
- email — String
- password — String
- name — String
- created_at — TIMESTAMP