SQL
Tables (12)
ai_product_suggestions
- id — UUID
- wholesaler_id — UUID — NOT NULL
- product_id — UUID
- original_name — TEXT — NOT NULL
- suggested_name — TEXT — NOT NULL
- suggested_category — TEXT
- suggested_keywords — TEXT
- confidence_score — DECIMAL(5, 4)
- accepted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
audit_logs
- id — UUID
- user_id — UUID — NOT NULL
- action — TEXT — NOT NULL
- target_type — TEXT
- target_id — UUID
- details — JSONB
- ip_address — TEXT
- created_at — TIMESTAMP
cart_items
- id — UUID
- retailer_id — UUID — NOT NULL
- product_id — UUID — NOT NULL
- variant_id — UUID
- quantity — INTEGER — NOT NULL
- created_at — TIMESTAMP
cs_messages
- id — UUID
- thread_id — UUID — NOT NULL
- sender_type — TEXT — NOT NULL
- sender_id — UUID
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
cs_threads
- id — UUID
- user_id — UUID — NOT NULL
- title — TEXT — NOT NULL
- status — TEXT — NOT NULL
- created_at — TIMESTAMP
- closed_at — TIMESTAMP
inquiries
- id — UUID
- user_id — UUID — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- status — TEXT — NOT NULL
- admin_reply — TEXT
- created_at — TIMESTAMP
- replied_at — TIMESTAMP
orders
- id — UUID
- order_number — TEXT — NOT NULL
- retailer_id — UUID — NOT NULL
- wholesaler_id — UUID — NOT NULL
- product_id — UUID — NOT NULL
- variant_id — UUID
- quantity — INTEGER — NOT NULL
- unit_price — INTEGER — NOT NULL
- shipping_fee — INTEGER — NOT NULL
- total_amount — INTEGER — NOT NULL
- delivery_address — TEXT — NOT NULL
- request_note — TEXT
- status — TEXT — NOT NULL
- payment_method — TEXT
- payment_key — TEXT
- paid_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
product_variants
- id — UUID
- product_id — UUID — NOT NULL
- name — TEXT — NOT NULL
- price — INTEGER — NOT NULL
- stock_quantity — INTEGER — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
products
- id — UUID
- wholesaler_id — UUID — NOT NULL
- name — TEXT — NOT NULL
- category — TEXT — NOT NULL
- specification — TEXT
- description — TEXT
- price — INTEGER — NOT NULL
- moq — INTEGER — NOT NULL
- shipping_fee — INTEGER — NOT NULL
- stock_quantity — INTEGER — NOT NULL
- image_url — TEXT
- is_active — BOOLEAN — NOT NULL
- standardized_name — TEXT
- ai_suggested_category — TEXT
- ai_keywords — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
retailers
- id — UUID
- user_id — UUID — NOT NULL
- business_name — TEXT — NOT NULL
- address — TEXT — NOT NULL
- phone — TEXT — NOT NULL
- created_at — TIMESTAMP
settlements
- id — UUID
- order_id — UUID — NOT NULL
- wholesaler_id — UUID — NOT NULL
- order_amount — INTEGER — NOT NULL
- platform_fee_rate — DECIMAL(5, 4) — NOT NULL
- platform_fee — INTEGER — NOT NULL
- wholesaler_amount — INTEGER — NOT NULL
- status — TEXT — NOT NULL
- scheduled_payout_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
wholesalers
- id — UUID
- user_id — UUID — NOT NULL
- business_name — TEXT — NOT NULL
- business_number — TEXT — NOT NULL
- representative — TEXT — NOT NULL
- phone — TEXT — NOT NULL
- address — TEXT — NOT NULL
- bank_account — TEXT — NOT NULL
- anonymous_code — TEXT — NOT NULL
- status — TEXT — NOT NULL
- rejection_reason — TEXT
- created_at — TIMESTAMP
- approved_at — TIMESTAMP