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