DB Design
Tables (12)
approval.approval (기안)
- id (approval.id) — int4 — Primary key — NOT NULL
- doc.type — int4 — Primary key
- id (business.opportunity.id) — int4 — Foreign key → business.opportunity.id — NOT NULL
business.opportunity (영업기회)
- id (business.opportunity.id) — int4 — Primary key — NOT NULL
- name — varchar
contract.product.list (계약물품 리스트)
- id (contract.product.list.id) — int4 — Primary key — NOT NULL
- id (approval.id) — int4 — Foreign key → approval.approval.id — NOT NULL
- Field
design.line.list (상세내역)
- id (list.id) — int8 — Primary key — NOT NULL
- id (design.order.line.id) — int4 — Foreign key → design.order.line.id — NOT NULL
- id (design.order.id) — int4 — Foreign key → design.order.line.id — NOT NULL
design.order (설계요청)
- id (design.order.id) — int4 — Primary key — NOT NULL
- id (business.opportunity.id) — int4 — Foreign key → business.opportunity.id — NOT NULL
design.order.line (설계내역)
- id (design.order.line.id) — int4 — Primary key — NOT NULL
- id (design.order.id) — int4 — Foreign key → design.order.id — NOT NULL
opportunity.product (예상납품 내역)
- id (opprunity.id) — int8 — Primary key — NOT NULL
- id (business.opportunity.id) — int4 — Foreign key → business.opportunity.id — NOT NULL
purchase.order (구매요청)
- id (purchase.order.id) — int4 — Primary key — NOT NULL
- Field
purchase.order.line (구매물품 리스트)
- id (purchase.order.line.id) — int4 — Primary key — NOT NULL
- id (purchase.order.id2) — int4 — Foreign key → purchase.order.id — NOT NULL
- Field
req.delivery.list (출고요청)
- id (req.delivery.list.id) — int4 — Primary key — NOT NULL
- id (contract.product.list.id) — int4 — Foreign key → contract.product.list.id — NOT NULL
- id (approval.id) — int4 — Foreign key → contract.product.list.id — NOT NULL
- doc.type — int4 — Foreign key → approval.approval.doc.type
- id (business.opportunity.id) — int4 — Foreign key → approval.approval.id — NOT NULL
sale.order (판매요청)
- id (purchase.order.id) — int4 — Primary key — NOT NULL
- id (approval.id) — int4 — Foreign key → approval.approval.id — NOT NULL
sale.order.line (판매물품 리스트)
- id (sale.order.line.id) — int4 — Primary key — NOT NULL
- id (purchase.order.id) — int4 — Foreign key → sale.order.id — NOT NULL
- id (approval.id) — int4 — Foreign key → sale.order.id — NOT NULL
- Field