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