DOMS

Tables (10)

base_channel_order_info (기본서비스 주문 정보)

  • Key — Primary key — NOT NULL
  • Field

base_channel_order_info_item_order_details (기본서비스 주문 정보와 상품 상세 조인 시키는 중간 테이블)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → base_channel_order_info.Key — NOT NULL
  • Field

contract (계약)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → order_info.Key — NOT NULL
  • Field

customer (고객)

  • Key — Primary key — NOT NULL

estimate (선수수익)

  • Key4 — Primary key — NOT NULL
  • Key (Key3) — Foreign key → contract.Key — NOT NULL
  • Key4 (Key42) — Foreign key → evidence.Key4 — NOT NULL
  • Key — Foreign key → customer.Key — NOT NULL
  • Key (Key2) — Foreign key → partner.Key — NOT NULL

estimate_sales (선수수익 상세)

  • Key — Primary key — NOT NULL
  • Key4 — estimate_id — Foreign key → estimate.Key4 — NOT NULL
  • Key (Key2) — Foreign key → estimate.Key — NOT NULL
  • Key (Key22) — Foreign key → estimate.Key — NOT NULL
  • Key (Key3) — Foreign key → estimate.Key — NOT NULL

evidence (증빙)

  • Key4 — Primary key — NOT NULL
  • Key — Foreign key → contract.Key — NOT NULL

item_order_detail (상품 상세)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → base_channel_order_info_item_order_details.Key — NOT NULL
  • Key (Key22) — Foreign key → base_channel_order_info_item_order_details.Key — NOT NULL
  • Field
  • Field2

order_info (주문)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → customer.Key — NOT NULL
  • Key (Key3) — Foreign key → partner.Key — NOT NULL
  • Field

partner (파트너사)

  • Key — Primary key — NOT NULL
  • Field — 리셀러 등