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