CMS
Tables (4)
Containers
- ContainerSeq — NUMBER
- QCNumber — VARCHAR2(7)
- JobID — VARCHAR2(10)
- ContainerID — VARCHAR2(11) — NOT NULL
- ISOCode — VARCHAR2(4)
- WorkedTime — TIMESTAMP
- ITVNumber — VARCHAR2(4)
- ITVDirection — CHAR(1)
- ITVPosition — CHAR(1)
- SealPresence — CHAR(1)
- ContainerDoorOpen — CHAR(1)
- ContainerDoorDirection — CHAR(1)
- ITVWorkLane — NUMBER(1)
- OperationType — VARCHAR2(10)
- JobType — VARCHAR2(15)
- ITVHeadCompressionPrevention — CHAR(1)
- ContainerType — VARCHAR2(20)
- ContainerSizeRecognition — VARCHAR2(10)
- ImageLocationFront — VARCHAR2(255)
- ImageLocationBack — VARCHAR2(255)
- ImageLocationLeft — VARCHAR2(255)
- ImageLocationRight — VARCHAR2(255)
- ImageLocationTop — VARCHAR2(255)
- DamagePresenceFront — CHAR(1)
- DamagePresenceBack — CHAR(1)
- DamagePresenceLeft — CHAR(1)
- DamagePresenceRight — CHAR(1)
- DamagePresenceTop — CHAR(1)
- IMDGPresenceFront — CHAR(1)
- IMDGPresenceBack — CHAR(1)
- IMDGPresenceLeft — CHAR(1)
- IMDGPresenceRight — CHAR(1)
EditRequests
- EditRequestID — NUMBER
- QCNumber — VARCHAR2(7)
- JobID — VARCHAR2(10)
- ContainerID — VARCHAR2(11)
- RequestedBy — VARCHAR2(20)
- RequestedAt — TIMESTAMP
- AssignedAt — TIMESTAMP
- CompletedAt — TIMESTAMP
- ISOCodeRequested — CHAR(1)
- DamageRequested — CHAR(1)
- SealPresenceRequested — CHAR(1)
- ITVNumberRequested — CHAR(1)
- DoorDirectionRequested — CHAR(1)
- ContainerPositionRequested — CHAR(1)
- OperationTypeRequested — CHAR(1)
- JobTypeRequested — CHAR(1)
- IMDGRequested — CHAR(1)
- DoorOpenRequested — CHAR(1)
- Status — CHAR(1) — W, E, C
- Comment — VARCHAR2(255) — ARCHAR2(255
Untitled (CurrentCMSList)
- Field (CMSID) — CHAR(2)
- Field2
Users
- UserID — VARCHAR2(20)
- Password — VARCHAR2(255)
- Name — VARCHAR2(50)
- Department — VARCHAR2(100)
- EmployeeNumber — VARCHAR2(20)
- CreatedAt — TIMESTAMP