VOC

Tables (5)

carrier (운송사)

  • id — bigint — Primary key — NOT NULL
  • 기사명 (name) — varchar(255)
  • 회사명 (company) — varchar(255)

compensation (배상)

  • id — bigint — Primary key — NOT NULL
  • 배상금액 (amount) — varchar(255)

penalty (패널티)

  • id — bigint — Primary key — NOT NULL
  • 패널티금액 (amount) — varchar(255)
  • 읽음여부 (read) — Boolean
  • 이의제기여부 (objection) — Boolean
  • 이의제기사유 (reason) — varchar(255)

supplier (공급사(고객사))

  • id — bigint — Primary key — NOT NULL
  • 고객사명 (vendor_name) — varchar(255)
  • 담당자명 (manager_name) — varchar(255)
  • 담당자번호 (manager_number) — varchar(255)

voc (voc)

  • id — bigInt — Primary key — NOT NULL
  • 공급사id (supplier) — bigint — Foreign key → supplier.id — NOT NULL
  • 운송사id (carrier) — bigint — Foreign key → carrier.id — NOT NULL
  • 배상id (compensation) — bigint — Foreign key → compensation.id — NOT NULL
  • 패널티id (penalty) — bigint — Foreign key → penalty.id — NOT NULL
  • Voc상태 (voc_status) — varchar(255)
  • 귀책대상 (imputation) — varchar(255)
  • 귀책사유 (reason) — varchar(255)
  • 클레임여부 (claim) — Boolean