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