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 — 리셀러 등