오픈마켓정산자동화
테이블 (10)
CHANNELS
- channel_id — INT
- channel_name — VARCHAR(100) — NOT NULL
- channel_code — VARCHAR(50) — NOT NULL
- api_key — VARCHAR(255)
- api_secret — VARCHAR(255)
- api_endpoint — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
CHANNEL_SETTLEMENT_DETAILS
- detail_id — INT
- settlement_id — INT — NOT NULL
- channel_id — INT — NOT NULL
- channel_specific_data — JSON
- created_at — DATETIME
- updated_at — DATETIME
COUPANG_SETTLEMENT_DETAILS
- coupang_detail_id — INT
- detail_id — INT — NOT NULL
- rocket_delivery_fee — DECIMAL(15, 2)
- advertising_fee — DECIMAL(15, 2)
- return_fee — DECIMAL(15, 2)
- coupang_promotion_fee — DECIMAL(15, 2)
- created_at — DATETIME
- updated_at — DATETIME
ELEVEN_SETTLEMENT_DETAILS
- eleven_detail_id — INT
- detail_id — INT — NOT NULL
- card_discount_fee — DECIMAL(15, 2)
- eleven_promotion_fee — DECIMAL(15, 2)
- premium_listing_fee — DECIMAL(15, 2)
- other_eleven_fees — DECIMAL(15, 2)
- created_at — DATETIME
- updated_at — DATETIME
FEE_DETAILS
- fee_detail_id — INT
- settlement_id — INT — NOT NULL
- fee_type_id — INT — NOT NULL
- fee_amount — DECIMAL(15, 2) — NOT NULL
- description — TEXT
- created_at — DATETIME
- updated_at — DATETIME
FEE_TYPES
- fee_type_id — INT
- fee_type_name — VARCHAR(100) — NOT NULL
- description — TEXT
- is_common — BOOLEAN — NOT NULL
- channel_id — INT
- created_at — DATETIME
- updated_at — DATETIME
NAVER_SETTLEMENT_DETAILS
- naver_detail_id — INT
- detail_id — INT — NOT NULL
- naverpay_fee — DECIMAL(15, 2)
- promotion_fee — DECIMAL(15, 2)
- early_settlement_fee — DECIMAL(15, 2)
- other_naver_fees — DECIMAL(15, 2)
- created_at — DATETIME
- updated_at — DATETIME
ORDERS
- order_id — INT
- channel_id — INT — NOT NULL
- product_id — INT — NOT NULL
- order_number — VARCHAR(100) — NOT NULL
- order_date — DATETIME — NOT NULL
- quantity — INT — NOT NULL
- sale_price — DECIMAL(15, 2) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- customer_id — VARCHAR(100)
- shipping_info — TEXT
- created_at — DATETIME
- updated_at — DATETIME
PRODUCTS
- product_id — INT
- product_name — VARCHAR(255) — NOT NULL
- supply_price — DECIMAL(15, 2) — NOT NULL
- product_code — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — DATETIME
- updated_at — DATETIME
SETTLEMENTS
- settlement_id — INT
- order_id — INT — NOT NULL
- channel_id — INT — NOT NULL
- settlement_number — VARCHAR(100) — NOT NULL
- settlement_date — DATETIME — NOT NULL
- gross_sales — DECIMAL(15, 2) — NOT NULL
- total_fees — DECIMAL(15, 2) — NOT NULL
- supply_cost — DECIMAL(15, 2) — NOT NULL
- net_sales — DECIMAL(15, 2) — NOT NULL
- settlement_status — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME