CLT하역최적화
테이블 (11)
BASIC_TIME (선박이동및선석작업상태)
- TIME_SEQ (Key) — NUMBER — 기본 키 — NOT NULL
- TIME (Field) — STRING(14) — NOT NULL
- ACT_TIDE (Field2) — STRING(1) — NOT NULL
- ACT_TIDE_TIME (Field3) — STRING(14)
- ATA_ST (Field4) — NUMBER — NOT NULL
- ACT_END (Field5) — NUMBER — NOT NULL
- CHAR_DATE (Field6) — STRING(8)
BERTH_INFO (선석 작업정보)
- BERTH_CD (Key) — STRING(2) — 기본 키 — NOT NULL
- BERTH_SEQ (Field) — NUMBER — NOT NULL
- VESSEL_SIZE (Field2) — STRING(10) — NOT NULL
- ITEM_TYPE (Field3) — STRING(1) — NOT NULL
- DISC_VOL (Field4) — NUMBER — NOT NULL
- DISC_VOL_ORI (Field5) — NUMBER — NOT NULL
BERTH_PLAN (OUTPUT)
- VESSEL_CD (Key) — STRING(4) — 기본 키 — NOT NULL
- ACT_TIDE_TIME (Field9) — STRING(14) — 기본 키 — NOT NULL
- WORK_ST_TIME (Field10) — STRING(14) — 기본 키 — NOT NULL
- LAY_ST_TIME (Field11) — STRING(14) — 기본 키 — NOT NULL
- CNTR_END_TIME (Key2) — STRING(14) — 기본 키 — NOT NULL
- WORK_END_TIME (Key3) — STRING(14) — 기본 키 — NOT NULL
- WORK_TIME (Key4) — STRING(32) — 기본 키 — NOT NULL
- DEM_TIME (Key5) — STRING(32) — 기본 키 — NOT NULL
- DEM_COST (Key6) — NUMBER — 기본 키 — NOT NULL
- BERTH_CD (Key42) — STRING(2) — 외래 키 → MATRIX.BERTH_CD
- VARIABLE_NAME (Key22) — STRING(256) — 외래 키 → MATRIX.VARIABLE_NAME — NOT NULL
- TIME_SEQ (Key32) — NUMBER — 외래 키 → MATRIX.TIME_SEQ
- ITEM_NAME (Key52) — STRING(10) — 외래 키 → MATRIX.ITEM_NAME
- VESSEL_SEQ (Field) — STRING(10) — NOT NULL
- BERTH_SEQ (Field8) — NUMBER — NOT NULL
EQUATIONS (제약관련정보)
- EQUATION_NAME (Key) — STRING(256) — 기본 키 — NOT NULL
- EQUATION_TYPE (Field) — STRING(10) — NOT NULL
- VESSEL_CD (Field2) — STRING(4)
- VESSEL_SEQ (Field3) — NUMBER
- VESSEL_SIZE (Field4) — STRING(10)
- TIME_SEQ (Field5) — NUMBER
- END_SEQ (Field6) — NUMBER
- BERTH_CD (Field7) — STRING(2)
- BERTH_SEQ (Field8) — NUMBER
- TIDE (Field9) — STRING(1)
- ITEM_TYPE (Field10) — STRING(1)
- ITEM_NAME (Field11) — STRING(3)
- EQUATION_DATE (Field12) — DATE — NOT NULL
- EQUATION_TIME (Field13) — DATE — NOT NULL
- END_TIME (Field14) — DATE
- ROW_SIGN (Field15) — STRING(1) — NOT NULL
- ROW_RHS (Field16) — NUMBER — NOT NULL
- ROW_RNG (Field17) — NUMBER
- REDUCED_COST (Field18) — NUMBER
INITIAL_BERTH (시작시점에선석작업정보)
- VESSEL_CD (Key2) — STRING(4) — 외래 키 → VESSEL.VESSEL_CD — NOT NULL
- VESSEL_SEQ (Field) — NUMBER — NOT NULL
- BERTH_CD (Field2) — STRING(2) — NOT NULL
- BERTH_SEQ (Field3) — NUMBER — NOT NULL
- ACT_TIDE_TIME (Field4) — STRING(14) — NOT NULL
- WORK_ST_TIME (Field5) — STRING(14) — NOT NULL
- LAY_ST_TIME (Field6) — STRING(14) — NOT NULL
- CNTR_END_TIME (Field7) — STRING(14) — NOT NULL
- WORK_END_TIME (Field8) — STRING(14) — NOT NULL
- WORK_TIME (Field9) — STRING(32) — NOT NULL
- DEM_TIME (Field10) — STRING(32) — NOT NULL
- DEM_COST (Field11) — NUMBER — NOT NULL
MATRIX (제약과변수연결정보)
- COLUMN_NAME (Key) — STRING(128) — 기본 키 — NOT NULL
- ROW_NAME (Field) — STRING(128) — 기본 키 — NOT NULL
- FACTOR (Field2) — NUMBER — 기본 키 — NOT NULL
- VARIABLE_NAME (Key2) — STRING(256) — 외래 키 → VARIABLES.VARIABLE_NAME — NOT NULL
- TIME_SEQ (Key3) — NUMBER — 외래 키 → VARIABLES.TIME_SEQ
- BERTH_CD (Key4) — STRING(2) — 외래 키 → VARIABLES.BERTH_CD
- ITEM_NAME (Key5) — STRING(10) — 외래 키 → VARIABLES.ITEM_NAME
- EQUATION_NAME (Key6) — STRING(256) — 외래 키 → EQUATIONS.EQUATION_NAME — NOT NULL
- COLUMN_NAME2 (Field3) — NUMBER
SOS (SOS정보)
- ITEM_NAME (Key2) — STRING(10) — 외래 키 → STORAGE_ITEM.ITEM_NAME — NOT NULL
- ITEM_TYPE (Field3) — STRING(10) — NOT NULL
- INI_VOL (Field) — NUMBER
- AVG_USE (Field2) — NUMBER
STORAGE_ITEM (재고관련정보)
- ITEM_NAME (Key) — STRING(10) — 기본 키 — NOT NULL
- ITEM_TYPE (Field) — STRING(1) — NOT NULL
- INI_VOL (Field2) — NUMBER
- AVG_USE (Field3) — NUMBER
- SAFE_VOL (Field4) — NUMBER
- MIN_VOL (Field5) — NUMBER
VARIABLES (변수관련정보)
- VARIABLE_NAME (Key) — STRING(256) — 기본 키 — NOT NULL
- VESSEL_CD (Key2) — STRING(4) — 외래 키 → VESSEL.VESSEL_CD
- TIME_SEQ (Key3) — NUMBER — 외래 키 → BASIC_TIME.TIME_SEQ
- BERTH_CD (Key4) — STRING(2) — 외래 키 → BERTH_INFO.BERTH_CD
- ITEM_NAME (Key5) — STRING(10) — 외래 키 → STORAGE_ITEM.ITEM_NAME
- VARIABLE_TYPE (Field) — STRING(10) — NOT NULL
- VESSEL_SEQ (Field3) — NUMBER
- VESSEL_SIZE (Field4) — STRING(10)
- END_SEQ (Field6) — NUMBER
- BERTH_SEQ (Field8) — NUMBER
- TIDE (Field9) — STRING(1)
- ITEM_TYPE (Field10) — STRING(1)
- EQUATION_DATE (Field12) — DATE — NOT NULL
- EQUATION_TIME (Field13) — DATE — NOT NULL
- END_TIME (Field14) — DATE
- LOWER_BOUND (Field15) — NUMBER — NOT NULL
- UPPER_BOUND (Field16) — NUMBER — NOT NULL
- COST (Field17) — NUMBER — NOT NULL
- REDUCED_COST (Field18) — NUMBER — NOT NULL
- VALUE (Field19) — NUMBER — NOT NULL
- GINT (Field20) — STRING(1) — NOT NULL
VESSEL (선박관련정보)
- VESSEL_CD (Key) — STRING(4) — 기본 키 — NOT NULL
- ETA (Field) — STRING(14) — NOT NULL
- VESSEL_SEQ (Field2) — NUMBER — NOT NULL
- TIME_SEQ (Field3) — NUMBER — NOT NULL
- ITEM_TYPE (Field4) — STRING(1) — NOT NULL
- LAYTIME_TYPE (Field5) — STRING(10) — NOT NULL
- DEM_RATE (Field6) — NUMBER — NOT NULL
- TOTAL_VOL (Field7) — NUMBER — NOT NULL
- TURN_TIME (Field9) — NUMBER — NOT NULL
- VESSEL_SIZE (Field10) — STRING(10) — NOT NULL
- ALLOW_DISC_TIME (Field11) — NUMBER — NOT NULL
VESSEL_ITEM (선박선적ITEM정보)
- VESSEL_CD (Key2) — STRING(4) — 외래 키 → VESSEL.VESSEL_CD — NOT NULL
- ITEM_NAME (Key) — STRING(10) — 외래 키 → STORAGE_ITEM.ITEM_NAME — NOT NULL
- VESSEL_SEQ (Field2) — NUMBER — NOT NULL
- ITEM_TYPE (Field4) — STRING(1) — NOT NULL
- ITEM_VOL_ORI (Field9) — NUMBER — NOT NULL
- ITEM_VOL (Field10) — NUMBER — NOT NULL
- ITEM_RAT (Field11) — NUMBER — NOT NULL