오픈마켓정산자동화

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