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