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