test
Tables (21)
alarm_his
- hiskey — character
- almkey — character
- code — numeric(38,0)
- name — character
- type — numeric(38,0)
- grade — smallint
- category — numeric(38,0)
- colm — numeric(38,0)
- shelf — numeric(38,0)
- slot — numeric(38,0)
- node — numeric(38,0)
- block — numeric(38,0)
- subid — character
- strloc — character
- information — character
- data1 — character
- data2 — character
- data3 — character
- inhibit — numeric(38,0)
- occur_date — character
- reason — numeric(38,0)
- sts — numeric(38,0)
- rackid — smallint
- sysid — smallint
- systype — smallint
- destsysid — smallint
- destsystype — smallint
- checked — character(1)
- seqid — bigint
almday_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- sysid — integer
- systype — integer
- destnode — integer — NOT NULL
- destsysid — integer
- destsystype — integer
- almcode — character — NOT NULL
- almcnt — bigint
almfivemin_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- sysid — integer
- systype — integer
- destnode — integer — NOT NULL
- destsysid — integer
- destsystype — integer
- almcode — character — NOT NULL
- almcnt — bigint
almfunction_t
- funccode — numeric
- sysnamey — character
- funcname — character
almhour_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- sysid — integer
- systype — integer
- destnode — integer — NOT NULL
- destsysid — integer
- destsystype — integer
- almcode — character — NOT NULL
- almcnt — bigint
almmon_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- sysid — integer
- systype — integer
- destnode — integer — NOT NULL
- destsysid — integer
- destsystype — integer
- almcode — character — NOT NULL
- almcnt — bigint
almsms_t
- userid — character
- almcode — character
almtype_t
- almtype — numeric
- typename — character
areainfo_t
- areaid — bigint — NOT NULL
- areaname — character — NOT NULL
current_alarm
- almkey — character
- code — numeric(38,0)
- name — character
- type — numeric(38,0)
- grade — numeric(38,0)
- category — numeric(38,0)
- colm — numeric(38,0)
- shelf — numeric(38,0)
- slot — numeric(38,0)
- node — numeric(38,0)
- block — numeric(38,0)
- subid — character
- strloc — character
- information — character
- data1 — character
- data2 — character
- data3 — character
- inhibit — numeric(38,0)
- occur_date — character
- reason — numeric(38,0)
- adtflag — numeric(38,0)
- rackid — smallint
- sysid — smallint
- systype — smallint
- destsysid — smallint
- destsystype — smallint
- checked — character(1)
stt_day_t
- raisedate — character — NOT NULL
- systype — smallint — NOT NULL
- sysid — smallint — NOT NULL
- areaid — smallint — NOT NULL
- serviceid — smallint — NOT NULL
- try — numeric(10,0)
- success — numeric(10,0)
- fail0 — numeric(10,0)
- fail1 — numeric(10,0)
- fail2 — numeric(10,0)
- fail3 — numeric(10,0)
- fail4 — numeric(10,0)
- fail5 — numeric(10,0)
- fail6 — numeric(10,0)
- fail7 — numeric(10,0)
stt_fivemin_t
- raisedate — character — NOT NULL
- systype — smallint — NOT NULL
- sysid — smallint — NOT NULL
- areaid — smallint — NOT NULL
- serviceid — smallint — NOT NULL
- try — numeric(10,0)
- success — numeric(10,0)
- fail0 — numeric(10,0)
- fail1 — numeric(10,0)
- fail2 — numeric(10,0)
- fail3 — numeric(10,0)
- fail4 — numeric(10,0)
- fail5 — numeric(10,0)
- fail6 — numeric(10,0)
- fail7 — numeric(10,0)
stt_hour_t
- raisedate — character — NOT NULL
- systype — smallint — NOT NULL
- sysid — smallint — NOT NULL
- areaid — smallint — NOT NULL
- serviceid — smallint — NOT NULL
- try — numeric(10,0)
- success — numeric(10,0)
- fail0 — numeric(10,0)
- fail1 — numeric(10,0)
- fail2 — numeric(10,0)
- fail3 — numeric(10,0)
- fail4 — numeric(10,0)
- fail5 — numeric(10,0)
- fail6 — numeric(10,0)
- fail7 — numeric(10,0)
systemday_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- systype — integer
- sysid — integer
- cputotal — bigint
- cpucnt — bigint
- cpumin — bigint
- cpumax — bigint
- memtotal — bigint
- memcnt — bigint
- memmin — bigint
- memmax — bigint
- disktotal — bigint
- diskcnt — bigint
- diskmin — bigint
- diskmax — bigint
systemfivemin_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- systype — integer
- sysid — integer
- cputotal — bigint
- cpucnt — bigint
- cpumin — bigint
- cpumax — bigint
- memtotal — bigint
- memcnt — bigint
- memmin — bigint
- memmax — bigint
- disktotal — bigint
- diskcnt — bigint
- diskmin — bigint
- diskmax — bigint
systemhour_t
- raisedate — character — NOT NULL
- node — integer — NOT NULL
- areaid — integer
- systype — integer
- sysid — integer
- cputotal — bigint
- cpucnt — bigint
- cpumin — bigint
- cpumax — bigint
- memtotal — bigint
- memcnt — bigint
- memmin — bigint
- memmax — bigint
- disktotal — bigint
- diskcnt — bigint
- diskmin — bigint
- diskmax — bigint
tb_diskstat
- stat_date — character — NOT NULL
- node — numeric(38,0) — NOT NULL
- stat_week — numeric(38,0)
- numofhdd — numeric(38,0)
- diskmount — character — NOT NULL
- disktotal — numeric(38,0)
- diskused — numeric(38,0)
- diskfree — numeric(38,0)
- diskusage — numeric(38,0)
tb_loadstat
- stat_date — character — NOT NULL
- node — numeric(38,0) — NOT NULL
- act_sts — numeric(38,0) — NOT NULL
- stat_week — numeric(38,0)
- count — numeric(38,0)
- cpu_user_rate — numeric(5,2)
- cpu_kernel_rate — numeric(5,2)
- cpu_total_rate — numeric(5,2)
- cpu_peak_rate — numeric(5,2)
- mem_total — numeric(38,0)
- mem_used — numeric(38,0)
- mem_free — numeric(38,0)
- peak_mem_used — numeric(38,0)
- mem_usage_rate — numeric(5,2)
tb_node
- areaid — numeric(10,0) — NOT NULL
- tuid — numeric(10,0) — NOT NULL
- node_no — numeric(20,0)
- node_name — character — NOT NULL
- tuid_node_grp — numeric(20,0) — NOT NULL
- node_grp_name — character — NOT NULL
- node_type — character — NOT NULL
- redun_type — character — NOT NULL
- shelf_no — numeric(20,0)
- slot_no — numeric(20,0)
- sysid — smallint
- systype — smallint
- prefer_type — character(1) — NOT NULL
- ldng_type — character — NOT NULL
- act_sts — numeric(20,0) — NOT NULL
- adm_sts — numeric(20,0) — NOT NULL
- opr_sts — numeric(20,0) — NOT NULL
- svc_sts — numeric(20,0) — NOT NULL
- detail_sts — numeric(20,0) — NOT NULL
- sts_upt_dt — character — NOT NULL
- reg_id — character — NOT NULL
- reg_dt — character(19)
- YYYY-MM-DD — HH24:MI:SS'::text) — NOT NULL
- upt_id — character — NOT NULL
- upt_dt — character(19) — NOT NULL
tbl_cf_host_status
- areaid — bigint — NOT NULL
- systype — smallint — NOT NULL
- sysid — smallint — NOT NULL
- sysname — character — NOT NULL
- node_no — bigint
- node_name — character — NOT NULL
- node_grp_no — bigint
- node_grp_name — character — NOT NULL
- adm_status — smallint
- adm_status_str — character — NOT NULL
- opr_status — smallint
- opr_status_str — character — NOT NULL
- svc_status — smallint
- svc_status_str — character — NOT NULL
- port_0_mm_if — character
- port_0_mm_status — smallint
- port_0_s1_if — character
- port_0_s1_status — smallint
- port_0_s2_if — character
- port_0_s2_status — smallint
- port_1_mm_if — character
- port_1_mm_status — smallint
- port_1_s1_if — character
- port_1_s1_status — smallint
- port_1_s2_if — character
- port_1_s2_status — smallint
- port_2_mm_if — character
- port_2_mm_status — smallint
- port_2_s1_if — character
- port_2_s1_status — smallint
- port_2_s2_if — character
- port_2_s2_status — smallint
- port_3_mm_if — character
- port_3_mm_status — smallint
- port_3_s1_if — character
- port_3_s1_status — smallint
- port_3_s2_if — character
- port_3_s2_status — smallint
- port_4_mm_if — character
- port_4_mm_status — smallint
- port_4_s1_if — character
- port_4_s1_status — smallint
- port_4_s2_if — character
- port_4_s2_status — smallint
- port_5_mm_if — character
- port_5_mm_status — smallint
- port_5_s1_if — character
- port_5_s1_status — smallint
- port_5_s2_if — character
- port_5_s2_status — smallint
- port_6_mm_if — character
- port_6_mm_status — smallint
- port_6_s1_if — character
- port_6_s1_status — smallint
- port_6_s2_if — character
- port_6_s2_status — smallint
- port_7_mm_if — character
- port_7_mm_status — smallint
- port_7_s1_if — character
- port_7_s1_status — smallint
- … +15
tbl_cli_node_port
- areaid — bigint — NOT NULL
- node_nm — character — NOT NULL
- ifname — character — NOT NULL
- ip — character — NOT NULL
- gid — smallint — NOT NULL
- type — smallint
- redun — character
- mtu — bigint
- memo — character
- nodeg_nm — character — NOT NULL
- nodeg_id — bigint — NOT NULL
- node_id — bigint — NOT NULL