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