acs

Tables (47)

NA_A_ALARM

  • id — varchar(64)
  • alarmCode — varchar(10)
  • alarmText — varchar(255)
  • vehicleId — varchar(64)
  • createTime — datetime2(6)
  • alarmId — varchar(10)
  • transportCommandId — varchar(64)

NA_A_ALARMSPEC

  • id — varchar(64)
  • alarmId — varchar(10)
  • alarmText — varchar(255)
  • severity — varchar(10)
  • description — varchar(255)

NA_C_NIO

  • id — varchar(64)
  • interfaceClassName — varchar(225)
  • workflowManagerName — varchar(225)
  • applicationName — varchar(64)
  • port — int
  • remoteIp — varchar(20)
  • machineName — varchar(64)
  • NAME — varchar(64) — NOT NULL
  • description — varchar(225)
  • createTime — datetime2(6)
  • creator — varchar(45)
  • editor — varchar(45)
  • state — varchar(20)
  • editTime — datetime2(6)

NA_C_SECS

  • id — varchar(64)
  • deviceId — int
  • interfaceClassName — varchar(255)
  • workflowManagerName — varchar(255)
  • dictionaryFile — varchar(255)
  • driverLogBackUpDays — int
  • driverLogLevel — int
  • driverLogMode — varchar(20)
  • driverType — varchar(20)
  • applicationName — varchar(64)
  • hsmsConnectionMode — varchar(20)
  • hsmsPort — int
  • hsmsRemoteIp — varchar(20)
  • hsmsType — varchar(20)
  • logDirectory — varchar(255)
  • machineName — varchar(64)
  • machineType — varchar(20)
  • secsIILogMode — varchar(20)
  • secsILogMode — varchar(20)
  • smdPath — varchar(255)
  • timeOutLinkTest — int
  • timeOutT1 — float
  • timeOutT2 — float
  • timeOutT3 — int
  • timeOutT4 — int
  • timeOutT5 — int
  • timeOutT6 — int
  • timeOutT7 — int
  • timeOutT8 — int
  • state — varchar(20)
  • NAME — varchar(64) — NOT NULL
  • description — varchar(255)
  • createTime — datetime2(6)
  • creator — varchar(45)
  • editor — varchar(45)
  • editTime — datetime2(6)

NA_H_ALARMRPTHISTORY

  • id — varchar(64)
  • alarmCode — varchar(10)
  • alarmText — varchar(255)
  • vehicleId — varchar(64)
  • alarmId — varchar(10)
  • state — varchar(20)
  • PARTITIONID — int — NOT NULL
  • time — datetime2(6)
  • transportCommandId — varchar(64)

NA_H_ALARMTIMEHISTORY

  • ID — nvarchar(64) — Primary key — NOT NULL
  • ALARMID — nvarchar(10)
  • ALARMCODE — nvarchar(10)
  • ALARMTEXT — nvarchar(500)
  • VEHICLEID — nvarchar(64)
  • TIME — datetime
  • PARTITIONID — int — NOT NULL
  • TRANSPORTCOMMANDID — nvarchar(64)
  • CREATETIME — datetime
  • CLEARTIME — datetime
  • NEARAGV — nvarchar(2)
  • BAYID — nvarchar(64)
  • ISCROSS — nvarchar(2)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_APPLICATIONHISTORY

  • ID — nvarchar(64) — Primary key — NOT NULL
  • TIME — datetime — NOT NULL
  • APPLICATIONNAME — nvarchar(45)
  • TYPE — nvarchar(20)
  • STATE — nvarchar(20)
  • CREATOR — nvarchar(45)
  • EDITOR — nvarchar(45)
  • STARTTIME — datetime
  • EDITTIME — datetime
  • CHECKTIME — datetime
  • INITIALHARDWARE — nvarchar(45)
  • RUNNINGHARDWARE — nvarchar(45)
  • RUNNINGHARDWAREADDRESS — nvarchar(45)
  • MSB — nvarchar(20)
  • MEMORY — nvarchar(5)
  • JMX — nvarchar(10)
  • DESTINATIONNAME — nvarchar(60)
  • PARTITIONID — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_HEARTBEATFAILHISTORY

  • id — varchar(64)
  • applicationName — varchar(64)
  • type — varchar(20)
  • state — varchar(20)
  • startTime — datetime2(6)
  • initialHardware — varchar(45)
  • runningHardware — varchar(45)
  • PARTITIONID — int — NOT NULL
  • time — datetime2(6)

NA_H_MISSMATCHANDFLYHISTORY

  • ID — nvarchar(64) — Primary key — NOT NULL
  • TIME — datetime — NOT NULL
  • VEHICLEID — nvarchar(32)
  • CURRENTNODEID — nvarchar(64)
  • NODENG — nvarchar(64)
  • PARTITIONID — int — NOT NULL
  • TYPE — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_NIOHISTORY

  • ID — nvarchar(64) — Primary key — NOT NULL
  • TIME — datetime
  • APPLICATIONNAME — nvarchar(45)
  • PORT — int
  • REMOTEIP — nvarchar(20)
  • MACHINENAME — nvarchar(64)
  • STATE — nvarchar(20)
  • NAME — nvarchar(20)
  • PARTITIONID — int
  • LOCATION — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_TRANSPORTCMDHISTORY

  • id — varchar(64)
  • jobId — varchar(64)
  • priority — int
  • state — varchar(20)
  • vehicleId — varchar(64)
  • vehicleEvent — varchar(16)
  • carrierId — varchar(64)
  • source — varchar(64)
  • dest — varchar(64)
  • path — varchar(1000)
  • additionalInfo — varchar(1000)
  • createdTime — datetime2(6)
  • queuedTime — datetime2(6)
  • assignedTime — datetime2(6)
  • startedTime — datetime2(6)
  • loadArrivedTime — datetime2(6)
  • loadedTime — datetime2(6)
  • unloadArrivedTime — datetime2(6)
  • unloadedTime — datetime2(6)
  • completedTime — datetime2(6)
  • unloadingTime — datetime2(6)
  • loadingTime — datetime2(6)
  • eqpId — varchar(64)
  • portId — varchar(64)
  • agvName — varchar(64)
  • jobType — varchar(64)
  • midLoc — varchar(64)
  • midPortId — varchar(64)
  • originLoc — varchar(64)
  • description — varchar(256)
  • PARTITIONID — int — NOT NULL
  • time — datetime2(6)
  • bayId — varchar(64)
  • reason — varchar(255)
  • code — varchar(20)

NA_H_USERHISTORY

  • ID — nvarchar(64) — Primary key — NOT NULL
  • TIME — datetime — NOT NULL
  • USERID — nvarchar(10)
  • USERCLASS — nvarchar(500)
  • COMPUTERNAME — nvarchar(64)
  • ACTIONCATEGORY — nvarchar(6)
  • ACTIONVIEWNAME — nvarchar(10)
  • ACTIONTEXT — nvarchar(20)
  • DESCRIPTION — nvarchar(64)
  • PARTITIONID — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_VEHICLEHISTORY

  • id — varchar(64)
  • vehicleId — varchar(64)
  • bayId — varchar(64)
  • carrierType — varchar(8)
  • connectionState — varchar(16)
  • alarmState — varchar(8)
  • processingState — varchar(10)
  • currentNodeId — varchar(64)
  • transportCommandId — varchar(64)
  • path — varchar(100)
  • nodeCheckTime — datetime2(6)
  • state — varchar(20)
  • installed — varchar(20)
  • transferState — varchar(20)
  • runState — varchar(10)
  • fullState — varchar(10)
  • time — datetime2(6)
  • messageName — varchar(64)
  • acsDestNodeId — varchar(64)
  • vehicleDestNodeId — varchar(64)
  • PARTITIONID — int — NOT NULL

NA_H_VEHICLESEARCHPATH

  • ID — nvarchar(64) — Primary key — NOT NULL
  • VEHICLEID — nvarchar(64)
  • BAYID — nvarchar(64)
  • CURRENTNODEID — nvarchar(64)
  • PATH — nvarchar(2000)
  • TIME — datetime
  • PARTITIONID — int
  • TRCMD — nvarchar(64)
  • TYPE — nvarchar(64)
  • TRANSFERSTATE — nvarchar(64)
  • DISTANCE — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_H_VEHICLE_BATTERYHISTORY

  • id — varchar(64)
  • vehicleId — varchar(64)
  • batteryRate — int
  • batteryVoltage — float
  • time — datetime2(6)
  • PARTITIONID — int — NOT NULL
  • PROCESSINGSTATE — varchar(20)

NA_L_LARGELOGMESSAGE

  • id — varchar(64)
  • LOGMESSAGEID — varchar(900) — NOT NULL
  • largeText — varchar(4000)
  • PARTITIONID — int — NOT NULL
  • time — datetime2(6)
  • sequence — int — NOT NULL

NA_L_LOG

  • Data — datetime
  • Thread — varchar(50)
  • Level — varchar(50)
  • Logger — varchar(50)
  • Message — varchar(4000)

NA_L_LOGMESSAGE

  • id — varchar(64)
  • transactionId — varchar(64)
  • threadName — varchar(64)
  • operationName — varchar(255)
  • communicationMessageName — varchar(64)
  • transportCommandId — varchar(64)
  • carrierName — varchar(64)
  • processName — varchar(64)
  • messageName — varchar(64)
  • machineName — varchar(64)
  • unitName — varchar(64)
  • text — varchar(4000)
  • logLevel — varchar(6)
  • PARTITIONID — int — NOT NULL
  • time — datetime2(6)

NA_M_CARRIER

  • id — varchar(64)
  • type — varchar(20)
  • carrierLoc — varchar(64)
  • createTime — datetime2(6)

NA_Q_TRANSPORTCMDREQUEST

  • id — varchar(64)
  • messageName — varchar(255)
  • jobId — varchar(64)
  • vehicleId — varchar(64)
  • dest — varchar(64)
  • description — varchar(64)
  • createTime — datetime2(6)

NA_R_BAY

  • id — varchar(64) — Primary key
  • floor — numeric(10, 0)
  • description — varchar(200)
  • agvType — varchar(20)

NA_R_LINK

  • ID — varchar(64) — Primary key
  • ID (FROMNODEID) — varchar(64) — Foreign key → NA_R_NODE.ID
  • TONODEID — varchar(64)
  • LENGTH — numeric(10, 0)
  • SPEED — numeric(10, 0)
  • LEFTBRANCH — numeric(10, 0)
  • AVAILABILITY — varchar(2)
  • LOAD — numeric(10, 0)

NA_R_LINK_VW

  • id — varchar(64)
  • zoneId — varchar(64)
  • transferFlag — varchar(1)
  • fromNodeId — varchar(64)
  • from_xpos — int
  • from_ypos — int
  • toNodeId — varchar(64)
  • to_xpos — int
  • to_ypos — int
  • length — int
  • speed — int
  • leftBranch — int
  • availability — varchar(2)
  • loading — int
  • bayId — varchar(64)

NA_R_LINK_ZONE

  • ID — varchar(64) — Primary key
  • ID (LINKID) — varchar(64) — Foreign key → NA_R_LINK.ID
  • ID (ZONEID) — varchar(64) — Foreign key → NA_R_ZONE.ID
  • TRANSFERFLAG — varchar(1)

NA_R_LOCATION

  • PORTID — varchar(64) — Primary key
  • ID (STATIONID) — varchar(64) — Foreign key → NA_R_STATION.ID
  • TYPE — varchar(8)
  • CARRIERTYPE — varchar(8)
  • DIRECTION — varchar(8)
  • STATE — varchar(20)

NA_R_LOCATION_VW

  • portId — varchar(64)
  • stationId — varchar(64)
  • bayId — varchar(64)
  • location_type — varchar(8)
  • carrierType — varchar(8)
  • direction — varchar(8)
  • state — varchar(20)
  • linkId — varchar(64)
  • parentNode — varchar(64)
  • station_type — varchar(64)
  • distance — int
  • from_xpos — int
  • from_ypos — int
  • to_xpos — int
  • to_ypos — int
  • length — int
  • speed — int
  • leftBranch — int
  • availability — varchar(2)
  • loading — int
  • transferFlag — varchar(1)

NA_R_NODE

  • ID — varchar(64) — Primary key
  • TYPE — varchar(8)
  • XPOS — numeric(10, 0)
  • YPOS — numeric(10, 0)
  • ZPOS — numeric(10, 0)

NA_R_QR_OCCUPY

  • ID — varchar(50)
  • AGVID — varchar(50)
  • CHANGEDTIME — datetime2(6)

NA_R_STATION

  • ID — varchar(64) — Primary key
  • ID (LINKID) — varchar(64) — Foreign key → NA_R_LINK.ID
  • TYPE — varchar(20)
  • DISTANCE — numeric(10, 0)

NA_R_STATION_VW

  • id — varchar(64)
  • linkId — varchar(64)
  • parentNode — varchar(64)
  • nextNode — varchar(64)
  • type — varchar(64)
  • distance — int

NA_R_VEHICLE

  • ID — varchar(64) — Primary key
  • NIOID — varchar(32)
  • VENDOR — varchar(32)
  • VERSION — varchar(32)
  • BAYID — varchar(64)
  • CARRIERTYPE — varchar(8)
  • CONNECTIONSTATE — varchar(16)
  • ALARMSTATE — varchar(8)
  • PROCESSINGSTATE — varchar(10)
  • BATTERYRATE — numeric(10, 0)
  • CURRENTNODEID — varchar(64)
  • TRANSPORTCOMMANDID — varchar(64)
  • PATH — varchar(1000)
  • NODECHECKTIME — datetime2(6)
  • STATE — varchar(20)
  • INSTALLED — varchar(20)
  • TRANSFERSTATE — varchar(20)
  • BATTERYVOLTAGE — float
  • RUNSTATE — varchar(10)
  • FULLSTATE — varchar(10)
  • ACSDESTNODEID — varchar(64)
  • VEHICLEDESTNODEID — varchar(64)
  • EVENTTIME — datetime2(6)
  • PLCVERSION — varchar(32)
  • NIONAME — varchar(32)
  • LASTCHARGETIME — datetime2(6)
  • LASTCHARGEBATTERY — float

NA_R_VEHICLE_ADDITION

  • ID — varchar(10)
  • DIRECTION — varchar(10)
  • FGSTATE — varchar(10)
  • TOPSTATE — varchar(10)
  • BTMSTATE — varchar(10)
  • CHANGEDTIME — datetime2(6)

NA_R_VEHICLE_CROSS_WAIT

  • VEHICLEID — varchar(64)
  • NODEID — varchar(64)
  • STATE — varchar(8)
  • CREATEDTIME — datetime2(6)

NA_R_VIRTUAL_PORT

  • ID — nvarchar(64) — Primary key — NOT NULL
  • VIRTUALPORTID — nvarchar(32)
  • REALPORTID — nvarchar(32)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_R_WAITINGPATH

  • ID — nvarchar(64) — Primary key — NOT NULL
  • WAITINGPATH — nvarchar(max)
  • TRIPLENODE — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NA_R_ZONE

  • ID — varchar(64) — Primary key
  • id (BAYID) — varchar(64) — Foreign key → NA_R_BAY.id
  • DESCRIPTION — varchar(200)

NA_T_TRANSPORTCMD

  • id — varchar(64)
  • priority — numeric(10, 0)
  • state — varchar(20)
  • vehicleId — varchar(64)
  • vehicleEvent — varchar(64)
  • carrierId — varchar(64)
  • source — varchar(64)
  • dest — varchar(64)
  • path — varchar(1000)
  • additionalInfo — varchar(1000)
  • createdTime — datetime2(6)
  • queuedTime — datetime2(6)
  • assignedTime — datetime2(6)
  • startedTime — datetime2(6)
  • loadArrivedTime — datetime2(6)
  • loadedTime — datetime2(6)
  • unloadArrivedTime — datetime2(6)
  • unloadedTime — datetime2(6)
  • completedTime — datetime2(6)
  • unloadingTime — datetime2(6)
  • loadingTime — datetime2(6)
  • eqpId — varchar(64)
  • portId — varchar(64)
  • agvName — varchar(64)
  • jobType — varchar(64)
  • midLoc — varchar(64)
  • midPortId — varchar(64)
  • originLoc — varchar(64)
  • bayId — varchar(64)
  • description — varchar(256)

NA_U_INFORM

  • id — varchar(64)
  • time — datetime2(6)
  • type — varchar(20)
  • message — varchar(1000)
  • source — varchar(64)
  • description — varchar(1000)

NA_U_LABEL

  • ID — varchar(64)
  • NAME — varchar(512)
  • X_POS — numeric(18, 0)
  • Y_POS — numeric(18, 0)
  • COLOR — varchar(20)
  • FONT_SIZE — numeric(18, 0)
  • OPACITY — numeric(18, 0)
  • BOLD — char(1)
  • VISIBILITY — char(1)

NA_U_SERVERSTATUS

  • HARDWARE_TYPE — varchar(16)
  • CPU_PERCENT — varchar(16)
  • MEMORY_TOTAL — varchar(16)
  • MEMORY_USAGE — varchar(16)
  • MEMORY_AVAIL — varchar(16)
  • MEMORY_PERCENT — varchar(16)
  • EDITTIME — datetime2(6)

NA_U_STATECOLOR

  • ID — varchar(64)
  • MODELNAME — varchar(20)
  • STATENAME — varchar(45)
  • STATEVALUE — varchar(45)
  • FIGURETARGET — varchar(20)
  • RED — numeric(4, 0)
  • GREEN — numeric(4, 0)
  • BLUE — numeric(4, 0)
  • IMAGEFILENAME — varchar(60)
  • DESCRIPTION — varchar(200)

NA_U_STORAGESTATUS

  • HARDWARE_TYPE — varchar(16)
  • FILESYSTEM_NAME — varchar(20)
  • TOTAL — varchar(16)
  • USAGE — varchar(16)
  • AVAIL — varchar(16)
  • PERCENT — varchar(16)
  • EDITTIME — datetime2(6)

NA_U_TRANSPORT

  • ID — varchar(64)
  • MESSAGENAME — varchar(64)
  • TRANSPORTCOMMANDID — varchar(64)
  • SOURCEPORTID — varchar(64)
  • DESTPORTID — varchar(64)
  • VEHICLEID — varchar(64)
  • DESTNODEID — varchar(64)
  • REQUESTID — varchar(64)
  • USERID — varchar(64)
  • CAUSE — varchar(64)
  • DESCRIPTION — varchar(64)
  • TIME — datetime2(6)

NA_U_USERGROUP

  • USERGROUP_ID — varchar(50)
  • USERGROUP_DESC — varchar(400)

NA_U_USERS

  • LOGINID — varchar(16)
  • PASSWORD — varchar(16)
  • FULLNAME — varchar(64)
  • USERGROUP — varchar(16)

NA_X_APPLICATION

  • id — varchar(64)
  • type — varchar(20)
  • state — varchar(20)
  • startTime — datetime2(6)
  • checkTime — datetime2(6)
  • initialHardware — varchar(45)
  • runningHardware — varchar(45)
  • runningHardwareAddress — varchar(45)
  • msb — varchar(20)
  • memory — varchar(5)
  • jmx — varchar(10)
  • destinationName — varchar(64)
  • NAME — varchar(64) — NOT NULL
  • description — varchar(255)
  • createTime — datetime2(6)
  • creator — varchar(45)
  • editor — varchar(45)
  • editTime — datetime2(6)

NA_X_TRUNCATEPARAMETER

  • id — varchar(64)
  • tableName — varchar(64)
  • nativeSql — varchar(200)
  • partitioningBase — varchar(20)
  • savePeriod — int
  • truncateSingleOrMulti — varchar(6)
  • description — varchar(255)
  • createTime — datetime2(6)
  • creator — varchar(45)
  • editor — varchar(45)
  • editTime — datetime2(6)