System Manager
Tables (9)
cpu (CPU Info)
- mname (model name) — VARCHAR — Primary key
- package — INT — NOT NULL — slot
- freq (frequency) — DOUBLE — vendor frequency
- core (cores) — INT — number of cores
- thread (threads) — INT — number of threads
- archi (architecture) — VARCHAR — microarchitecture
cusage (CPU Usage)
- mname (CPU model) — VARCHAR — Foreign key → cpu.mname
- datetime — DATETIME — NOT NULL — running time
- usage (total usage) — DOUBLE — usage ratio
graphic (Graphic Cards)
- mname (device name) — VARCHAR — Primary key — NOT NULL
- mfr (manufacturer) — VARCHAR
- version (driver version info) — VARCHAR
- vram (vRam) — DOUBLE
lcpu (logical cpu)
- mname (CPU model) — VARCHAR — Foreign key → cpu.mname
- thread — INT — NOT NULL
- datetime — DATETIME
- usage — DOUBLE
mainboard (MainBoard Info)
- mname (model name) — VARCHAR — Primary key — NOT NULL
- mfr (manufacturer) — VARCHAR
- firmware — VARCHAR
- version — VARCHAR
memory (RAM Info)
- mname (memory name) — VARCHAR — Primary key — NOT NULL
- slot — INT
- mfr (manufacturer) — VARCHAR
- cap (capacity) — DOUBLE
- speed (clock speed) — DOUBLE
- type (memory type) — VARCHAR — DDR4
musage (Memory Usage)
- seq (sequence) — INT — Primary key — NOT NULL — 0 ~ 9999
- datetime — DATETIME — NOT NULL
- total (total memory) — DOUBLE
- usage (memory usage) — DOUBLE
- ratio (usage ratio) — DOUBLE — %
network (Network Interface)
- iname (interface name) — VARCHAR — Primary key — NOT NULL — eth0
- mac (MAC address) — VARCHAR — 70:85:c2:c5:cd:1b
- speed (network speed) — INT — 1000000000
- ipv4 (IPv4) — VARCHAR — 192.168.35.140/24
- ipv6 (IPv6) — VARCHAR — fe80:0:0:0:78ba:2215:aa82:443f/64
- host (host name) — VARCHAR
- domain (domain name) — VARCHAR
- dns (DNS server) — VARCHAR
- gateway4 (IPv4 gateway) — VARCHAR
- gateway6 (IPv6 gateway) — VARCHAR
sysinfo (System Info)
- server (server name) — VARCHAR — Primary key — NOT NULL
- Field