티켓팅

테이블 (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