STS OCR

Tables (26)

Admin Management History (ADMIN_HISTORY)

  • Index (HISTORY_INDEX) — BIGINT — Primary key — NOT NULL
  • History Category (CATEGORY) — VARCHAR
  • History Type (HISTORY_TYPE) — VARCHAR
  • History Level (HISTORY_LEVEL) — VARCHAR
  • Terminal Index related to history (TML_INDEX) — BIGINT
  • STS Index related to history (STS_INDEX) — BIGINT
  • Device Index related to history (DEVICE_INDEX) — BIGINT
  • Error code (ERR_CODE) — VARCHAR
  • Common code category (CODE_CATEGORY) — VARCHAR
  • Common code (CODE) — VARCHAR
  • History message (DESCRIPTION) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

Common Code (COMMON_CODE)

  • Code category (Error, Seal, Damage, ...) (CATEGORY) — VARCHAR — Primary key — NOT NULL
  • Code (CODE) — VARCHAR — Primary key — NOT NULL
  • Display name of code (CODE_NAME) — VARCHAR
  • Sub code (SUB_CODE) — VARCHAR
  • Description (DESCRIPTION) — VARCHAR
  • Ordering for display (DISPLAY_ORDER) — INTEGER
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

Container Damage Information (CNT_DMG)

  • Index (DAMAGE_INDEX) — BIGINT — Primary key — NOT NULL
  • Location (DAMAGE_POSITION) — VARCHAR
  • Remark (REMARK) — VARCHAR
  • Clent / TOS / Mobile (ACCESS_CHANNEL) — VARCHAR
  • Content type (Drawing / Picture / Text) (CONTENT_TYPE) — VARCHAR
  • Picture url (directory) from mobile (IMAGE_URL) — VARCHAR
  • Drawing contents from web client (IMAGE_DATA) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Code category (= Damage) (CATEGORY) — VARCHAR — Foreign key → Common Code.Code category (Error, Seal, Damage, ...) — NOT NULL
  • Damage code (CODE) — VARCHAR — Foreign key → Common Code.Code — NOT NULL
  • Index (CONTAINER_INDEX) — BIGINT — Foreign key → STS Job Container Detail Information.Index — NOT NULL

Container Hazard Information (CNT_HZD)

  • Index (HAZARD_INDEX) — BIGINT — Primary key — NOT NULL
  • IMDG Code (IMDG) — VARCHAR
  • UN No (UNNO) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Index (CONTAINER_INDEX) — BIGINT — Foreign key → STS Job Container Detail Information.Index — NOT NULL

Device Information (DEVICE_INFO)

  • Index (DEVICE_INDEX) — BIGINT — Primary key — NOT NULL
  • Device key (DEVICE_KEY) — VARCHAR
  • Device type (DEVICE_TYPE) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Interface type (INTERFACE_TYPE) — VARCHAR
  • IP — VARCHAR
  • Port Number (PORT) — VARCHAR
  • Connection Info (CONNECTION_INFO) — VARCHAR
  • Position (DEVICE_POSITION) — VARCHAR
  • Device status (DEVICE_STATUS) — VARCHAR
  • Manufacturer (MANUFACTURER) — VARCHAR
  • Version (VERSION) — VARCHAR
  • Description (DESCRIPTION) — VARCHAR
  • Last time received Idle status (for VAS Server) (LAST_TIME_RECV_MSG) — TIMESTAMP
  • RTSP Streaming URL (STREAMING_URL) — VARCHAR
  • Index (QC_INDEX) — BIGINT — Foreign key → QC Information.Index — NOT NULL

Event Code List (EVENT_CODE)

  • Event Code (EVENT_CODE) — VARCHAR — Primary key — NOT NULL
  • Alarm Level (Info, Warning, Error) (ALARM_LEVEL) — VARCHAR
  • System Kind (VAS, TOS, Client, ..) (SYS_KIND) — VARCHAR
  • Event Category (Job, Qc, Terminal) (CATEGORY) — VARCHAR
  • Inquiry Authority (All, Admin, Operator) (INQ_AUTH) — VARCHAR
  • Event message (MESSAGE) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

Event log (EVENT_LOG)

  • Index (EVENT_INDEX) — BIGINT — Primary key — NOT NULL
  • Terminal Index related to event (TML_INDEX) — BIGINT
  • QC Index related to event (QC_INDEX) — BIGINT
  • Job Index related to event (JOB_INDEX) — BIGINT
  • Container Index related to event (CONTAINER_INDEX) — BIGINT
  • Device Index related to event (DEVICE_INDEX) — BIGINT
  • Event Code (EVENT_CODE) — VARCHAR — Foreign key → Event Code List.Event Code — NOT NULL
  • Event message (MESSAGE) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

ITV Information (ITV_INFO)

  • Index (ITV_INDEX) — BIGINT — Primary key — NOT NULL
  • ITV Number (ITV_NO) — VARCHAR
  • ITV Number Recognized from VAS (ITV_NO_OCR) — VARCHAR
  • AI recognition rate (ITV_NO_RR) — INTEGER
  • ITV Head Direction (HEAD_DIRECTION) — VARCHAR
  • Position of parked lanes (Sea-side/Land-side) (LANE_POSITION) — VARCHAR
  • Parked Lane Number (LANE_NO) — INTEGER
  • Corrected by operator or not (CORRECTED) — BOOLEAN
  • ITV Image URL (ITV_IMAGE_URL) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR
  • Index (JOB_INDEX) — BIGINT — Foreign key → STS Job Information.Index — NOT NULL

Lane Information (LANE_INFO)

  • Index (LANE_INDEX) — BIGINT — Primary key — NOT NULL
  • Lane ID (LANE_ID) — VARCHAR
  • Lane name (LANE_NAME) — VARCHAR
  • Enabled (ENABLED) — BOOLEAN
  • Device name (DEVICE_NAME) — VARCHAR
  • Lane code (LANE_CODE) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

Operation Exception log (OPR_EXCEPTION_LOG)

  • Index (EXC_INDEX) — BIGINT — Primary key — NOT NULL
  • QC Index related to history (QC_INDEX) — BIGINT
  • Job Index related to history (JOB_INDEX) — BIGINT
  • Container Index related to history (CONTAINER_INDEX) — BIGINT
  • Resolved or not (IS_RESOLVED) — BOOLEAN
  • Resolved date time (RESOLVED_AT) — TIMESTAMP
  • Resolve Description (RESOLVE_DESC) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

Operation History (OPR_HISTORY)

  • Index (HISTORY_INDEX) — BIGINT — Primary key — NOT NULL
  • History Category (CATEGORY) — VARCHAR
  • History Type (HISTORY_TYPE) — VARCHAR
  • History Level (HISTORY_LEVEL) — VARCHAR
  • Terminal Index related to history (TERMINAL_INDEX) — BIGINT
  • STS Index related to history (QC_INDEX) — BIGINT
  • STS Job Index related to history (JOB_INDEX) — BIGINT
  • Container Index related to history (CONTAINER_INDEX) — BIGINT
  • Device Index related to history (DEVICE_INDEX) — BIGINT
  • TOS history Index related to history (TOS_INDEX) — BIGINT
  • TOS queue Index related to history (QUEUE_INDEX) — BIGINT
  • Damage Index related to history (DAMAGE_INDEX) — BIGINT
  • History message (DESCRIPTION) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

Planned Job (Container) List (TOS_QUEUE_JOB)

  • Index (JOB_INDEX) — BIGINT — Primary key — NOT NULL
  • Operation Sequence (SEQ) — INTEGER
  • Container number (CONTAINER_NO) — VARCHAR
  • ISO Code (Field) — VARCHAR
  • Full container or not (DOOR_DIRECTION) — BOOLEAN
  • Job is completed or not actually (FINISHED) — BOOLEAN
  • Loading/Discharging (LD_DS) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR
  • Index (QUEUE_INDEX) — BIGINT — Foreign key → Work Queue Information Received from TOS.Index — NOT NULL

QC Information (QC)

  • Index (QC_INDEX) — BIGINT — Primary key — NOT NULL
  • Index (TML_INDEX) — BIGINT — Foreign key → Terminal Information.Index — NOT NULL
  • QC ID (QC_ID) — VARCHAR
  • Equipment open status (true:Open/false:Close) (OPENED) — BOOLEAN
  • Working status (WORKING_STATUS) — VARCHAR(24)
  • Use auto job done or not (AUTO_JOB_DONE) — BOOLEAN
  • Break Action Status(None/MealTime/HatchCover,..) (BREAK_ACTION_STATUS) — VARCHAR(24)
  • Loading lane No. (LOAD_LANE_NO) — INTEGER
  • Loading lane No. - tandem (TANDEM_LOAD_LANE_NO) — INTEGER
  • Discharging lane No. (DISCHARGE_LANE_NO) — INTEGER
  • Discharging lane No. - tandem (TANDEM_DISCHARGE_LANE_NO) — INTEGER
  • Description (DESCRIPTION) — VARCHAR
  • Physical ordering of QC (CRANE_ORDER) — INTEGER
  • Station ID (STATION_ID) — VARCHAR — Foreign key → Station (Physical PC).Station ID — NOT NULL
  • Account (ACCOUNT) — VARCHAR(24) — Foreign key → User Information.Account — NOT NULL
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

STS Job Container Detail Information (CONTAINER)

  • Index (CONTAINER_INDEX) — BIGINT — Primary key — NOT NULL
  • Container No (CONTAINER_NO) — VARCHAR
  • Container No Recognized from VAS (CONTAINER_NO_OCR) — VARCHAR
  • ISO Code (CONTAINER_ISO) — VARCHAR
  • Size (CONTAINER_SIZE) — INTEGER
  • Height of container (CONTAINER_HEIGHT) — INTEGER
  • Container type (CONTAINER_TYPE) — VARCHAR
  • Door direction (DOOR_DIRECTION) — VARCHAR
  • Sea direction (SEA_DIRECTION) — VARCHAR
  • AI Recognition rate (CONTAINER_NO_RR) — INTEGER
  • Corrected by operator or not (CORRECTED) — BOOLEAN
  • Damaged container or not (DAMAGED) — BOOLEAN
  • Container is sealed or not (SEALED) — BOOLEAN
  • Seal count (SEAL_CNT) — INTEGER
  • Image URL (Left) (IMG_URL_LEFT) — VARCHAR
  • Image URL (Right) (IMG_URL_RIGHT) — VARCHAR
  • Image URL (Rear) (IMG_URL_REAR) — VARCHAR
  • Container position in STS (F(Front)/B(Back)) (QC_POSITION) — VARCHAR
  • Tare weight of container (TARE_WEIGHT) — INTEGER
  • Max gross weight of container (MAX_GROSS_WEIGHT) — INTEGER
  • Over size (Left) (OVER_SIZE_LEFT) — INTEGER
  • Over size (Right) (OVER_SIZE_RIGHT) — INTEGER
  • Over size (Front) (OVER_SIZE_FRONT) — INTEGER
  • Over size (Back) (OVER_SIZE_BACK) — INTEGER
  • Over size (Top) (OVER_SIZE_TOP) — INTEGER
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Is planned job in TOS work queue (PLANNED_IN_TOS) — BOOLEAN
  • Index (ITV_INDEX) — BIGINT — Foreign key → ITV Information.Index — NOT NULL

STS Job Information (JOB_INFO)

  • Index (JOB_INDEX) — BIGINT — Primary key — NOT NULL
  • Job type (N:Normal, F:Recog fail, G: Grounding, ...) (JOB_TYPE) — VARCHAR
  • Operation type (Single/Twin/Tandem) (OPERATION_TYPE) — VARCHAR
  • Loading/Discharging (LD_DS) — VARCHAR
  • Corrected by operator or not (CORRECTED) — BOOLEAN
  • Planned in TOS (PLANNED_IN_TOS) — BOOLEAN
  • TOS result (TOS_RESULT_STATUS) — VARCHAR
  • Job Error Status (E:Error,W:Warning,I:Normal) (JOB_ERROR_STATUS) — VARCHAR
  • Misrecognition data or not (GARBAGE_DATA) — BOOLEAN
  • Video URL (Seaside Left Sealbeam) (VIDEO_URL_SEA_LEFT) — VARCHAR
  • Video URL (Seaside Right Sealbeam) (VIDEO_URL_SEA_RIGHT) — VARCHAR
  • Video URL (Landside Left Sealbeam) (VIDEO_URL_LAND_LEFT) — VARCHAR
  • Video URL (Landside Right Sealbeam) (VIDEO_URL_LAND_RIGHT) — VARCHAR
  • Video URL (Portalbeam Left) (VIDEO_URL_PORTAL_LEFT) — VARCHAR
  • Video URL (Portalbeam Right) (VIDEO_URL_PORTAL_RIGHT) — VARCHAR
  • Job started time (START_AT) — TIMESTAMP
  • Job ended time (END_AT) — TIMESTAMP
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR
  • Index (QC_INDEX) — BIGINT — Foreign key → QC Information.Index — NOT NULL

Station (Physical PC) (STATION)

  • Station ID (STATION_ID) — VARCHAR — Primary key — NOT NULL
  • Station PC IP (IP) — VARCHAR
  • Description (DESCRIPTION) — VARCHAR(124)
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

System Base Information (SYS_BASE_INFO)

  • Index (SYS_INDEX) — BIGINT — Primary key — NOT NULL
  • Terminal Location Code (TML_CODE) — VARCHAR
  • The period of auto job done execution (AUTO_JOB_DONE_PERIOD) — INTEGER
  • The criteria rate of auto job done execution (AUTO_JOB_DONE_CRITERIA_RATE) — DOUBLE
  • Job Allocation Type (QC to station/ QC to logged-in user/RR) (JOB_ALLO_TYPE) — VARCHAR
  • Send AI recognition result to quay crane (auto) or not (SEND_AI_RECOG_TO_CRANE) — BOOLEAN
  • TOS data initialization was completed or not (TOS_INIT_FINISHED) — BOOLEAN
  • TOS Ignore or Not (TOS_IGNORE) — BOOLEAN
  • Retry job done request to TOS if the job fails or not (TOS_JOB_DONE_RETRY) — BOOLEAN
  • TOS Server connection is normal or not (TOS_STATUS_NORMAL) — BOOLEAN
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

System Schedule Information (SYS_SCHEDULE_INFO)

  • Index (SCHE_INDEX) — BIGINT — Primary key — NOT NULL
  • Schedule ID (SCHE_ID) — VARCHAR
  • Active or not (ACTIVE) — BOOLEAN
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Task Period (PERIOD) — BIGINT

TOS Message Receive History (TOS_HISTORY)

  • Index (HISTORY_INDEX) — BIGINT — Primary key — NOT NULL
  • STS Index related to history (STS_INDEX) — BIGINT
  • Job Index related to history (JOB_INDEX) — BIGINT
  • TOS Message ID (MSG_ID) — VARCHAR
  • Request / Response (HISTORY_TYPE) — VARCHAR
  • TOS Status (STATUSstatus) — VARCHAR
  • History message (DESCRIPTION) — VARCHAR
  • Original Message (XML_DATA) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR

TOS System Informaiton (TOS_INFO)

  • Index (TOS_INDEX) — BIGINT — Primary key — NOT NULL
  • Name (TOS_NAME) — VARCHAR(24)
  • TOS version (VERSION) — VARCHAR(128)
  • Url (URL) — VARCHAR
  • Server IP (IP) — VARCHAR
  • Server Port (PORT) — VARCHAR
  • Api Key (API_KEY) — VARCHAR
  • TOS Type (TOS_TYPE) — VARCHAR
  • Description (DESCRIPTION) — VARCHAR
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

Terminal Information (TML_INFO)

  • Index (TML_INDEX) — BIGINT — Primary key — NOT NULL
  • Name (TML_NAME) — VARCHAR(24)
  • Terminal Description (LOCATION) — VARCHAR(124)
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

User Information (USER_INFO)

  • Account (ACCOUNT) — VARCHAR(24) — Primary key — NOT NULL
  • Name (USER_NAME) — VARCHAR(50)
  • Email address (EMAIL) — VARCHAR(50)
  • Role type (ROLE_TYPE) — VARCHAR(50)
  • Password (PASSWORDa) — VARCHAR(60)
  • Station ID (STATION_ID) — VARCHAR — Foreign key → Station (Physical PC).Station ID — NOT NULL

User Login Information (USER_LOGIN)

  • Index (USER_LOGIN_INDEX) — BIGINT — Primary key — NOT NULL
  • Login channel (LOGIN_CHANNEL) — VARCHAR(1)
  • ZSession (Z_SESSION) — VARCHAR(50)
  • Current Station (STATION) — VARCHAR
  • Login time (LOGIN_AT) — TIMESTAMP
  • Logout time (LOGOUT_AT) — TIMESTAMP
  • Index (USER_INDEX) — BIGINT — Foreign key → User Information.Account — NOT NULL

Vessel Operation KPI History (for STATS) (TOS_VESSEL_KPI)

  • Index (KPI_INDEX) — BIGINT — Primary key — NOT NULL
  • Actual operation started time (OPERATION_ST_AT) — TIMESTAMP
  • Actual operation ended time (OPERATION_EN_AT) — TIMESTAMP
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Index (VSL_INDEX) — BIGINT — Foreign key → Vessel Visit Information.Index — NOT NULL

Vessel Visit Information (TOS_VESSEL)

  • Index (VSL_INDEX) — BIGINT — Primary key — NOT NULL
  • Visid ID (VISIT_ID) — VARCHAR
  • Vessel code (VESSEL_CODE) — VARCHAR
  • Operation status (OP_STATUS) — VARCHAR
  • Vessel status (VSL_STATUS) — VARCHAR
  • ETA — TIMESTAMP
  • ETB — TIMESTAMP
  • ETD — TIMESTAMP
  • Estimated Loading moves (LD_MOVES) — INTEGER
  • Estimated Discharging moves (DS_MOVES) — INTEGER
  • Vessel activated time (ACTIVATED_AT) — TIMESTAMP
  • Vessel deactivated time (DEACTIVATED_AT) — TIMESTAMP
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)

Work Queue Information Received from TOS (TOS_QUEUE)

  • Index (QUEUE_INDEX) — BIGINT — Primary key — NOT NULL
  • Work Queue ID (QUEUE_ID) — VARCHAR
  • Loading/Discharging (LD_DS) — VARCHAR
  • Bay Information (BAY) — VARCHAR
  • Status (Running/Temparary paused/Stop) (QUEUE_STATUS) — VARCHAR
  • Queue finish (FINISHED) — BOOLEAN
  • Queue Description (DESCRIPTION) — VARCHAR
  • Queue activated time (ACTIVATED_AT) — TIMESTAMP
  • Queue deactivated time (DEACTIVATED_AT) — TIMESTAMP
  • Created time (CREATE_AT) — TIMESTAMP
  • Created user (CREATE_BY) — VARCHAR(24)
  • Updated time (UPDATE_AT) — TIMESTAMP
  • Updated user (UPDATE_BY) — VARCHAR(24)
  • Index (QC_INDEX) — BIGINT — Foreign key → QC Information.Index — NOT NULL
  • Index (VSL_INDEX) — BIGINT — Foreign key → Vessel Visit Information.Index — NOT NULL