티켓팅
테이블 (14)
Concerts
- id — UUID — 기본 키 — NOT NULL
- venue_id — UUID — NOT NULL
- concert_name — VARCHAR(255) — NOT NULL
- concert_start_time — TIMESTAMP — NOT NULL
- playtime — INTEGER — NOT NULL — 분 단위
- description — TEXT
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
Coupon_concerts
- id — VARCHAR(255) — 기본 키 — NOT NULL
- coupon_id — UUID — NOT NULL
- concert_id — UUID — NOT NULL
Coupons
- id — UUID — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- discount_amount — INTEGER — NOT NULL — 할인율, 할인금액(0보다 큰 값)
- discount_policy — VARCHAR(30) — NOT NULL — ENUM: 비율할인, 고정할인
- target — VARCHAR(30) — NOT NULL — ENUM: 모든 공연, 특정 공연, 특정 등급, 특정 좌석
- start_date — TIMESTAMP — NOT NULL — 쿠폰 사용 가능 시작 날짜
- expiration_date — TIMESTAMP — NOT NULL — 쿠폰 사용 가능 만료 날짜
- min_spend_amount — INTEGER — NOT NULL
- max_quantity — INTEGER — NOT NULL — 발급 가능한 최대 수량, 무제한: -1
- issued_quantity — INTEGER — NOT NULL — default : 0
- is_limited_quantity — BOOLEAN — NOT NULL — true: 제한 존재, false: 무제한
- usage_limit — INTEGER — NOT NULL — 한 사용자가 쿠폰을 사용할 수 있는 최대 횟수, 무제한 : -1
- is_limited_usage — BOOLEAN — NOT NULL — true: 제한 존재, false: 무제한
- is_deleted — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
User_coupons
- id — UUID — 기본 키 — NOT NULL
- coupon_id — UUID — NOT NULL
- user_id — BIGINT — NOT NULL
- usage_count — INTEGER — NOT NULL — default: 0
- is_usable — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTMAP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
Users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL — 사용자 아이디는 이메일
- password — VARCHAR(255) — NOT NULL
- user_role — VARCHAR(255) — NOT NULL — ENUM: ADMIN, CUSTOMER
- name — VARCHAR(10) — NOT NULL
- birth_date — DATE — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- is_deleted — BOOLEAN
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
orders
- id — UUID — 기본 키 — NOT NULL
- concert_id — UUID — 외래 키 → Concerts.id — NOT NULL
- user_id — BIGINT — 외래 키 → Users.id — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING, COMPLETE, CANCELLED, REFUND, EXPIRED
- is_delted — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_by — BIGINT
- updated_at — TIMESTAMP
- deleted_by — BIGINT
- deleted_at — TIMESTAMP
orders_seat
- id — UUID — 기본 키 — NOT NULL
- order_id — UUID — 외래 키 → orders.id — NOT NULL
- concert_id — UUID — 외래 키 → orders.concert_id — NOT NULL
- user_id — BIGINT — 외래 키 → orders.user_id — NOT NULL
- seat_price_id — UUID — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_by — BIGINT
- updated_at — TIMESTAMP
- deleted_by — BIGINT
- deleted_at — TIMESTAMP
payment
- id — UUID — 기본 키 — NOT NULL
- order_id — UUID — 외래 키 → orders.id — NOT NULL
- concert_id — UUID — 외래 키 → orders.concert_id — NOT NULL
- user_id — BIGINT — 외래 키 → orders.user_id — NOT NULL
- pg_transaction_id — UUID — NOT NULL
- method — VARCHAR(20) — NOT NULL — CARD, TRANSFER, POINT, PAY_MONEY
- price — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING, SUCCESS, FAIL, EXPIRED
- is_deleted — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_by — BIGINT
- updated_at — TIMESTAMP
- deleted_by — BIGINT
- deleted_at — TIMESTAMP
payment_failure
- id — UUID — 기본 키 — NOT NULL
- payment_id — UUID — 외래 키 → payment.id — NOT NULL
- order_id — UUID — 외래 키 → payment.order_id — NOT NULL
- concert_id — UUID — 외래 키 → payment.concert_id — NOT NULL
- user_id — BIGINT — 외래 키 → payment.user_id — NOT NULL
- failure_reason — VARCHAR(255) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_by — BIGINT
- created_at — TIMESTAMPTZ
- updated_by — BIGINT
- updated_at — TIMESTAMPTZ
- deleted_by — BIGINT
- deleted_at — TIMESTAMP
prices
- id — UUID — 기본 키 — NOT NULL
- concert_id — UUID — NOT NULL
- price — INTEGER — NOT NULL
- seat_grade — VARCHAR(10) — NOT NULL
- is_delete — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
seat_prices
- id — UUID — 기본 키 — NOT NULL
- price_id — UUID — NOT NULL
- seat_id — UUID — NOT NULL
- status — VARCHAR(30) — NOT NULL — ENUM : RESERVED, PAYING, AVAILABLE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
seats
- id — UUID — 기본 키 — NOT NULL
- venue_id — UUID — NOT NULL
- seat_number — INTEGER — NOT NULL
- seat_grade — VARCHAR(10) — NOT NULL — ENUM : R석, S석, A석, B석
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT
settlement
- id — UUID — 기본 키 — NOT NULL
- concert_id — UUID — 외래 키 → Concerts.id — NOT NULL
- service_fee — DECIMAL(10, 2) — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING, PROCESSING, COMPLETE, FAILED, HOLD
- is_deleted — BOOLEAN — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_by — BIGINT
- updated_at — TIMESTAMP
- deleted_at — BIGINT
- deleted_by — TIMESTAMP
venues
- id — UUID — 기본 키 — NOT NULL
- venue_name — VARCHAR(255) — NOT NULL
- venue_address — VARCHAR(255) — NOT NULL
- seat_capacity — INTEGER — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
- created_by — BIGINT
- updated_by — BIGINT
- deleted_by — BIGINT