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