정산

테이블 (8)

adjustments

  • id — BIGINT
  • settlement_id — BIGINT
  • type — ENUM('refund', 'bonus', 'penalty')
  • amount — INT
  • reason — TEXT
  • created_by — BIGINT
  • created_at — DATETIME

deliveries

  • id — BIGINT
  • order_id — BIGINT
  • rider_id — BIGINT
  • distance_km — DECIMAL(5,2)
  • duration_min — INT
  • fee — INT
  • completed_at — DATETIME

orders

  • id — BIGINT
  • store_id — BIGINT
  • customer_id — BIGINT
  • order_time — DATETIME
  • total_amount — INT
  • discount_amount — INT
  • status — ENUM('completed', 'cancelled', 'refunded')
  • payment_method — ENUM('card', 'cash', 'app_wallet')
  • created_at — DATETIME

riders

  • id — BIGINT
  • user_id — BIGINT
  • vehicle_type — ENUM('bike', 'scooter', 'car')
  • region — VARCHAR(100)
  • joined_at — DATETIME

settlement_items

  • id — BIGINT
  • settlement_id — BIGINT
  • order_id — BIGINT
  • delivery_fee — INT
  • commission — INT
  • vat — INT
  • final_amount — INT
  • created_at — DATETIME

settlements

  • id — BIGINT
  • target_type — ENUM('store', 'rider')
  • target_id — BIGINT
  • period_start — DATE
  • period_end — DATE
  • total_amount — INT
  • status — ENUM('pending', 'completed', 'error')
  • processed_at — DATETIME

stores

  • id — BIGINT
  • owner_id — BIGINT
  • name — VARCHAR(255)
  • business_number — VARCHAR(50)
  • address — TEXT
  • pg_id — VARCHAR(100)
  • created_at — DATETIME

users

  • id — BIGINT
  • name — VARCHAR(100)
  • role — ENUM('customer', 'store_owner', 'rider', 'admin')
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • created_at — DATETIME