asset mng

Tables (22)

asset_agent (에이전트/원격/포터블관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

asset_agent (에이전트 관리)

  • seq (Key) — Primary key — NOT NULL

asset_agent_log (에이전트 로그정보)

  • seq (Key) — Foreign key → asset_agent.seq — NOT NULL
  • use_yn (Field)
  • log_size (Field2)
  • log_sec (Field3)
  • cre_dt (Field4)

asset_agent_resource (에이전트 리소스 정보)

  • seq (Key) — Foreign key → asset_agent.seq — NOT NULL
  • use_yn (Field)
  • cpu_size (Field2)
  • mem_size (Field3)
  • hdd_size (Field4)
  • cre_dt (Field5)

asset_master (자산관리)

  • master_seq (Key) — Primary key — NOT NULL
  • asset_nm (자산명) — varchar
  • assetalias (별칭) — varchar
  • ipaddr (ip주소) — varchar
  • purpose (사용용도) — varchar
  • cre_user_seq (관리자) — seq
  • status (상태) — varchar
  • cre_dt (생성일) — datetime
  • del_yn (삭제여부) — varchar

asset_master_type (자산관리 타입)

  • type_seq (Key2) — Primary key — NOT NULL
  • master_seq (key) — Foreign key → asset_master.master_seq — NOT NULL
  • cate_seq (Key) — Foreign key → pol_mng_grp_cate_dtl.cate_seq — NOT NULL
  • del_yn (Field)
  • cre_dt (Field2)

asset_master_user (자산관리 담당자)

  • regist_seq (Key) — Primary key — NOT NULL
  • master_seq (Key2) — Foreign key → asset_master.master_seq — NOT NULL
  • del_yn (Field2)
  • cre_dt (Field3)
  • user_seq (Field4)

asset_mng_chk_schedu (자산 스케줄관리)

  • chk_schedu_seq (Key) — Primary key — NOT NULL

asset_mng_chk_schedu_target (자산스케줄 대상관리)

  • chk_schedu_seq (Key) — Foreign key → asset_mng_chk_schedu.chk_schedu_seq — NOT NULL
  • cate_seq (Field)
  • target_schedu_seq (Field2)

cld_asset (CLOUD관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

cld_chk_schedu (CLOUD스케줄관리)

  • chk_schedu_seq (Key) — Primary key — NOT NULL

com_cd_dtl (리소스 설정)

  • cd_grp_cd (Key) — Foreign key → com_cd_grp_mngt.cd_grp_cd — NOT NULL
  • cd (Field2)
  • cd_nm (Field3)
  • opt_1 (Field4)
  • opt_2 (Field5)
  • opt_3 (Field6)
  • opt_4 (Field7)
  • del_yn (Field8)

com_cd_grp_mngt (리소스 관리)

  • cd_grp_cd (Key) — Primary key — NOT NULL
  • del_yn (Field2)

db_asset (DB관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

dbms_chk_schedu (DB스케줄관리)

  • chk_schedu_seq (Key) — Primary key — NOT NULL

nw_asset (네트워크관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

nw_chk_schedu (NW스케줄관리)

  • chk_schedu_seq (Key) — Primary key — NOT NULL

pol_mng_grp_cate_dtl (컴플라이언스 OS구분)

  • cate_seq (Key) — Primary key — NOT NULL
  • cate_nm (Field)
  • cate_disp_nm (Field2)
  • cate_grp (Field3)

ssm_schedule (OS스케줄관리)

  • schedule_id (Key) — Primary key — NOT NULL

ssmz_asset (에이전트 관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

web_asset (WEB관리)

  • type_seq (Key2) — Foreign key → asset_master_type.type_seq — NOT NULL

web_chk_schedu (WEB스케줄관리)

  • chk_schedu_seq (Key) — Primary key — NOT NULL