practice

Tables (3)

CODE.CICPCODE (공통 포트마스터)

  • CCDSIC (회사구분) — char(1) — Primary key — NOT NULL
  • CCDGUB (코드그룹) — char(2) — Primary key — NOT NULL
  • CCDNAM (EUKOR PORT CODE) — varchar(10) — Primary key — NOT NULL
  • CCDDCR (항구 설명) — char(30)
  • CCDGBN (매핑 유형) — char(1) — Foreign key → EDIS.EDIPCODE.CCDGBN — NOT NULL
  • CCDKFD1 (내부 식별값1) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD1 — NOT NULL
  • CCDKFD2 (내부 식별값2) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD2 — NOT NULL
  • CCDKFD3 (내부 식별값3) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD3 — NOT NULL
  • CCDKFD4 (내부 식별값4) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD4 — NOT NULL
  • CCDKDS1 (파트너) — char(30) — Foreign key → EDIS.EDIPCODE.CCDKDS1 — NOT NULL
  • CCDKDS2 (EUKOR Port Code) — char(30) — Foreign key → EDIS.EDIPCODE.CCDKDS2 — NOT NULL

EDIS.EDIPCODE (CopyOfUntitled)

  • CCDGBN (매핑 유형) — char(1) — Primary key — NOT NULL
  • CCDKFD1 (내부 식별값1) — char(5) — Primary key — NOT NULL
  • CCDKFD2 (내부 식별값2) — char(5) — Primary key — NOT NULL
  • CCDKFD3 (내부 식별값3) — char(5) — Primary key — NOT NULL
  • CCDKFD4 (내부 식별값4) — char(5) — Primary key — NOT NULL
  • CCDKDS1 (파트너) — char(30) — Primary key — NOT NULL
  • CCDKDS2 (EUKOR Port Code) — char(30) — Primary key — NOT NULL
  • CCDKDS3 (Volvo Group Port Code) — char(30)
  • Field

EDIS.VOLPCHIS (이력관리테이블)

  • CCDHSQ (이력번호) — int — Primary key — NOT NULL
  • CCDACT (N : 등록 , C : 변경 , D : 삭제) — char(1)
  • CCDGBN (원본의 유형) — char(1)
  • CCDKDS1 (원본의 파트너) — char(30)
  • CCDKFD1,2,3,4, (원본의 식별값 복사본) — char(5)
  • CCDOLD (변경 전 Volvo Code) — char(30)
  • CCDNEW (변경 후 Volvo Code) — char(30)
  • CCDDCR (작업 당시 항구 설명) — char(30)
  • CCDINP (작업자) — char(10)
  • CCDINP (작업일) — char(8)
  • CCDHTM (작업시각) — char(6)
  • Field
  • CCDGBN (매핑 유형) — char(1) — Foreign key → EDIS.EDIPCODE.CCDGBN — NOT NULL
  • CCDKFD1 (내부 식별값1) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD1 — NOT NULL
  • CCDKFD2 (내부 식별값2) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD2 — NOT NULL
  • CCDKFD3 (내부 식별값3) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD3 — NOT NULL
  • CCDKFD4 (내부 식별값4) — char(5) — Foreign key → EDIS.EDIPCODE.CCDKFD4 — NOT NULL
  • CCDKDS1 (파트너2) — char(30) — Foreign key → EDIS.EDIPCODE.CCDKDS1 — NOT NULL
  • CCDKDS2 (EUKOR Port Code) — char(30) — Foreign key → EDIS.EDIPCODE.CCDKDS2 — NOT NULL