swimpass

테이블 (12)

booking_classes

  • id — UUID
  • booking_id — UUID
  • class_id — UUID
  • price — INTEGER — NOT NULL
  • created_at — TIMESTAMP

bookings

  • id — UUID
  • order_number — VARCHAR(50) — NOT NULL
  • user_id — UUID
  • region_id — UUID
  • booking_date — DATE — NOT NULL
  • status — VARCHAR(20)
  • total_amount — INTEGER — NOT NULL
  • created_at — TIMESTAMP

classes

  • id — UUID
  • name — VARCHAR(200) — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • swimming_style — VARCHAR(50) — NOT NULL
  • time_slot — VARCHAR(20) — NOT NULL
  • capacity — INTEGER — NOT NULL
  • price — INTEGER — NOT NULL
  • lane — VARCHAR(20) — NOT NULL
  • instructor_id — UUID
  • region_id — UUID
  • created_at — TIMESTAMP

payment_logs

  • id — UUID
  • payment_id — UUID — NOT NULL
  • previous_status — VARCHAR(20)
  • current_status — VARCHAR(20) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • message — TEXT
  • metadata — JSONB
  • ip_address — INET
  • user_agent — TEXT
  • created_at — TIMESTAMP

payments

  • id — UUID
  • booking_id — UUID
  • amount — INTEGER — NOT NULL
  • method — VARCHAR(50)
  • status — VARCHAR(20)
  • payment_key — VARCHAR(200)
  • created_at — TIMESTAMP

refund_logs

  • id — UUID
  • refund_id — UUID — NOT NULL
  • previous_status — VARCHAR(20)
  • current_status — VARCHAR(20) — NOT NULL
  • message — TEXT
  • metadata — JSONB
  • created_at — TIMESTAMP

refunds

  • id — UUID
  • payment_id — UUID — NOT NULL
  • refund_key — VARCHAR(200)
  • amount — INTEGER — NOT NULL
  • reason — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20)
  • requested_by — VARCHAR(100)
  • approved_by — UUID
  • processed_at — TIMESTAMP
  • created_at — TIMESTAMP

regions

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • address — TEXT — NOT NULL
  • created_at — TIMESTAMP

users

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255)
  • gender — VARCHAR(10)
  • residence_area — VARCHAR(200)
  • swimming_experience — VARCHAR(50)
  • car_number — VARCHAR(20)
  • motivation — TEXT
  • created_at — TIMESTAMP

waitlists

  • id — UUID
  • user_id — UUID
  • class_id — UUID
  • booking_date — DATE — NOT NULL
  • position — INTEGER — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

webhook_logs

  • id — UUID
  • payment_id — UUID
  • provider — VARCHAR(50) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • webhook_data — JSONB — NOT NULL
  • signature — VARCHAR(500)
  • is_verified — BOOLEAN
  • processed — BOOLEAN
  • error_message — TEXT
  • created_at — TIMESTAMP

강사 (instructors)

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • region_id — UUID
  • created_at — TIMESTAMP