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