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