ㅊㄱㄷ
Tables (6)
concerts
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- running_time — INT — NOT NULL
- price — INT — NOT NULL
- limit_age — INT — NOT NULL
- performance_date — DATETIME — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
payments
- id — BIGINT
- reservation_id — BIGINT — NOT NULL
- total_amount — INT — NOT NULL
- method — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
reservations
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- concert_id — BIGINT — NOT NULL
- status — VARCHAR(20)
- amount — INT — NOT NULL
- reserved_at — DATETIME
- cancelled_at — DATETIME
- id (id2) — BIGINT — Foreign key → concerts.id — NOT NULL
reservations_seats
- id — BIGINT
- reservation_id — BIGINT — NOT NULL
- seat_id — BIGINT — NOT NULL
- reservation_number — VARCHAR(50) — NOT NULL
seats
- id — BIGINT
- seat_number — INT — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- birth — DATE — NOT NULL
- password — VARCHAR(255) — NOT NULL
- balance — BIGINT — NOT NULL
- user_role — VARCHAR(20) — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME