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)