Portal

Tables (11)

asst_dgns_evt

  • id — integer — Primary key — NOT NULL
  • cpu_usg — character
  • ram_usg — character
  • disk_usg — character
  • prcs_list — character
  • nw_stts — character
  • db_cnnt_stts — character
  • evt_time — timestamp
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character
  • asst_id — character — Foreign key → asst_info.asst_id — NOT NULL

asst_dgns_info

  • asst_id — Integer — Foreign key → asst_info.asst_id — NOT NULL
  • cpu_usg — character
  • ram_usg — character
  • disk_usg — character
  • prcs_list — character
  • nw_stts — character
  • db_cnnt_stts — character
  • imdtl_run_yn — boolean
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

asst_grp_info

  • asst_grp_id — Integer — Primary key — NOT NULL
  • asst_grp_name — character
  • asst_grp_ctx (Field) — character
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

asst_grp_rltn

  • asst_grp_id — Integer — Foreign key → asst_grp_info.asst_grp_id — NOT NULL
  • asst_id — Integer — Foreign key → asst_info.asst_id — NOT NULL
  • careated_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

asst_info

  • asst_id — Integer — Primary key — NOT NULL
  • asst_name — character
  • asst_ip_01 — character
  • asst_ip_02 — character
  • asst_use_yn — boolean
  • ads_use_yn — boolean
  • line_info — character
  • line_seq — character
  • asst_spec_info — character
  • asst_srl — character
  • asst_ctx — character
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

dgns_grp_info

  • dgns_grp_id — Integer — Primary key — NOT NULL
  • dgns_grp_name — character — NOT NULL
  • dgns_grp_ctx — charater
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

dgns_grp_rltn

  • dgns_id — Integer — Foreign key → dgns_info.dgns_id — NOT NULL
  • dgns_grp_id — Integer — Foreign key → dgns_grp_info.dgns_grp_id — NOT NULL
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character

dgns_info

  • dgns_id — Integer — Primary key — NOT NULL
  • dgns_name — character
  • dgns_type — character
  • dgns_ctx — character
  • cpu_usg — character
  • ram_usg — character
  • disk_usg — character
  • prcs_list — character
  • nw_stts — character
  • db_cnnt_stts — character
  • created_at — timestamp
  • create_user — character
  • updated_at — timestamp
  • updated_user — character

rmt_log (rmt_asst_log)

  • id — integer — Primary key — NOT NULL
  • cnnt_mod — integer
  • rmt_lvl — integer
  • ssn_strt_time — timestamp
  • ssn_end_time — timestamp
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character
  • trgt_ip — character — Foreign key → rmt_stts.asst_id — NOT NULL
  • cnnt_user — character — Foreign key → user_info.user_id — NOT NULL

rmt_stts (rmt_asst_stts)

  • asst_id — character — Primary key — NOT NULL
  • cnnt_stts — boolean
  • cnnt_stts_mlt — boolean
  • rmt_lvl — integer
  • ctrl_yn — boolean
  • created_at — timestamp
  • created_user — character
  • updated_at — timestamp
  • updated_user — character
  • cnnt_cnt — integer

user_info

  • user_id — character — Primary key — NOT NULL
  • user_pw — character — NOT NULL
  • user_name — character
  • user_lvl — integer — NOT NULL
  • refresh_token — character
  • created_at — timestamp — NOT NULL
  • created_user — character — NOT NULL
  • updated_at — timestamp
  • updated_user — character