v5info

Tables (19)

Untitled (userinfo)

  • Key (userid) — int — Primary key — NOT NULL
  • Field (username) — text — NOT NULL — login ID
  • Field (password) — text — NOT NULL — encrypted
  • Field (displayname) — text — NOT NULL — user name
  • Field (description) — text — admin layout
  • Field (status) — int — NOT NULL — codeinfo
  • Field (email) — text — to be needed
  • Field (tel) — text — to be needed
  • Field (department) — text — admin layout
  • Field (connectedip) — text
  • Field (connectedtime) — datetime
  • Field (createddate) — datetime — admin layout
  • Field (updateddate) — datetime — admin layout

Untitled (codeinfo)

  • Key (codeid) — int — Primary key — NOT NULL
  • Field (tablename) — text
  • Field (columnname) — text — NOT NULL
  • Field (columnvalue) — int — NOT NULL
  • Field (description) — text — NOT NULL

Untitled (managerinfo)

  • Key (managerid) — int — Primary key — NOT NULL
  • Field (majorversion) — int
  • Field (minorversion) — int
  • Field (releaseversion) — int
  • Field (ontunetime) — datetime — NOT NULL
  • Field (processedpacket) — int
  • Field (processedpackettime) — int
  • Field (newdata) — int
  • Field (inserteddate) — int
  • Field (queueddata) — int
  • Field (status) — text
  • Field (address) — text
  • Field (data) — text
  • Field (fdata) — int
  • Field (eventqueue) — int
  • Field (standardbias) — int
  • Field (daylight) — int
  • Field (daylightbias) — int
  • Field (tablemode) — int
  • Field (bias) — int
  • Field (build) — int
  • Field (daylightstarttime) — datetime
  • Field (standardstarttime) — datetime
  • Field (alterdatepidtable) — datetime
  • Field (alterdateidtable) — datetime
  • Field (alterdateagenttime) — datetime
  • Field (alterhourperftable) — datetime

Untitled (grouprelationinfo)

  • Key (ancestorid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (descentantid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (confighistory)

  • Key (confighistoryid) — int — Primary key — NOT NULL
  • Field (userid) — int — NOT NULL
  • Field (tablename) — text — NOT NULL
  • Field (crudtype) — text — NOT NULL
  • Field (crudvalues) — text
  • Field2 (description) — text
  • Field (createddate) — datetime — NOT NULL — used in history table

Untitled (tableinfo)

  • Key (tableid) — int — Primary key — NOT NULL
  • Field (tablename) — text
  • Field (version) — int
  • Field (createddate) — datetime — existed column
  • Field (updateddate) — datetime — existed column
  • Field (durationmin) — int

Untitled (authinfo)

  • Key (authid) — int — Primary key — NOT NULL
  • Field (name) — text — NOT NULL
  • Field (defaultvalue) — text

Untitled (userauthinfo)

  • Key (authid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (userid) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (value) — text — NOT NULL

Untitled (usergrouphostinfo)

  • Key (usergroupid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hostid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (usergroupinfo)

  • Key (usergroupid) — int — Primary key — NOT NULL
  • Key (groupid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (userid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (hostinfo)

  • Key (hostid) — int — Primary key — NOT NULL
  • Field (hostname) — text — NOT NULL
  • Field (status) — int — NOT NULL — codeinfo
  • Field (os) — text
  • Field (fw) — text
  • Field (agentversion) — text
  • Field (model) — text
  • Field (serial) — text
  • Field (processorcount) — text
  • Field (processorclock) — text
  • Field (memorysize) — text
  • Field (swapsize) — text
  • Field (poolid) — text
  • Field (replication) — text
  • Field (smt) — text
  • Field (micropar) — text
  • Field (capped) — text
  • Field (ec) — text
  • Field (virtualcpu) — text
  • Field (weight) — text
  • Field (cpupool) — text
  • Field (ams) — text
  • Field (allip) — text
  • Field (numanodecount) — text
  • Field (btime) — text
  • Field (shorttermbasic) — int
  • Field (shorttermproc) — int
  • Field (shorttermio) — int
  • Field (shorttermcpu) — int
  • Field (timecheck) — int
  • Field (disconnecteddate) — datetime
  • Field (skipdatatypes) — int
  • Field (virbasicperf) — int
  • Field (hypervisor) — int
  • Field (installdate) — datetime
  • Field (ibmpcrate) — int
  • Field (updateddate) — datetime — existed column

Untitled (groupinfo)

  • Key (groupid) — int — Primary key — NOT NULL
  • Field (name) — text — NOT NULL
  • Field (alias) — text
  • Field (description) — text

Untitled (grouphostinfo)

  • Key (groupid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hostid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (jobscheduleinfo)

  • Key (jobscheduleid) — int — Primary key — NOT NULL — auto increment
  • Field (desc) — text — NOT NULL
  • Field (jobtime) — datetime — NOT NULL
  • Field (periodic) — int — NOT NULL
  • Field (script) — text — NOT NULL
  • Field (jobfield) — text
  • Field (os) — int — NOT NULL — codeinfo
  • Field (enabled) — int — NOT NULL — codeinfo

Untitled (hostjobscheduleinfo)

  • Key (scheduleid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hostid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (intervalscheduleinfo)

  • Key (intervalscheduleid) — int — Primary key — NOT NULL — auto increment
  • Field (intervalname) — text — NOT NULL
  • Field (desc) — text
  • Field (enabled) — int — NOT NULL — codeinfo
  • Field (shorttermbasic) — int — NOT NULL
  • Field (shorttermproc) — int — NOT NULL
  • Field (shorttermio) — int — NOT NULL
  • Field (shorttermcpu) — int — NOT NULL
  • Field (starttime) — int
  • Field (endtime) — int
  • Field (createddate) — datetime — admin layout
  • Field (updateddate) — datetime — admin layout

Untitled (hostintervalscheduleinfo)

  • Key (intervalid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hostid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (customcolumninfo)

  • Key (customcolumnid) — int — Primary key — NOT NULL — auto increment
  • Field (name) — text — NOT NULL
  • Field (displayorder) — int — NOT NULL

Untitled (hostcolumninfo)

  • Key (customcolumnid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hostid) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (value) — text