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