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