ITSM

테이블 (14)

TBASSETHD (aseq)

  • seq — varchar2 — 기본 키 — NOT NULL
  • gubun1 — varchar2
  • gubun2 — varchar2
  • gubun3 — varchar2
  • model — varchar2
  • worknm — vachar2
  • amt — varchar2
  • sn — varchar2
  • repair — date
  • chk_start — date
  • assetno — varchar2
  • calno — varchar2
  • chk_state — varchar2
  • hostnm — varchar2
  • osnm (Field13) — varchar2
  • os_patch (Field14) — varchar2
  • os_loc (Field15) — varchar2
  • rackno (Field16) — varchar2
  • rack_loc (Field17) — varchar2
  • cpu (Field18) — varchar2
  • core (Field19) — varchar2
  • speed (Field20) — varchar2
  • memory (Field21) — varchar2
  • disk_amt (Field22) — varchar2
  • raid_lev (Field23) — varchar2
  • net (Field24) — varchar2
  • ip (Field25) — varchar2
  • hba_amt (Field26) — varchar2
  • comnm (Field27) — varchar2
  • manager (Field28) — varchar2
  • tel (Field29) — varchar2
  • email (Field30) — varchar2
  • chk_cycle (Field31) — varchar2
  • eol (Field32) — varchar2
  • eosl (Field33) — varchar2
  • new_patch (Field34) — varchar2
  • reg_date (Field35) — date
  • useyn (Field37) — varchar2

TBASSETLOG (fk aseq)

  • (x) — varchar2 — 외래 키 → TBASSETHD.seq — NOT NULL
  • (xx) — varchar2 — 외래 키 → TBASSETSF.seq — NOT NULL
  • seq (fk) — varchar2
  • state (Field) — varchar2
  • empno (Field2) — varchar2
  • empnm (Field3) — varchar2
  • deptno (Field4) — varchar2
  • deptnm (Field5) — varchar2
  • content (Field7) — varchar2
  • reg_date (Field6) — date

TBASSETSF (eq aseq)

  • seq (pk) — varchar2 — 기본 키 — NOT NULL
  • gubun1 (Field) — varchar2
  • gubun2 (Field2) — varchar2
  • gubun3 (Field3) — varchar2
  • model (Field4) — varchar2
  • worknm (Field5) — varchar2
  • amt (Field6) — varchar2
  • repair (Field7) — date
  • chk_start (Field8) — date
  • assetno (Field9) — varchar2
  • calno (Field10) — varchar2
  • chk_state (Field11) — varchar2
  • lickey (Field29) — varchar2
  • licnm (Field12) — varchar2
  • licno (Field13) — varchar2
  • lic_amt (Field14) — varchar2
  • core_amt (Field15) — varchar2
  • hostnm (Field16) — varchar2
  • sf_path (Field17) — varchar2
  • supnm (Field18) — varchar2
  • sup_date (Field19) — date
  • comnm (Field20) — varchar2
  • manager (Field21) — varchar2
  • tel (Field22) — varchar2
  • email (Field23) — varchar2
  • chk_cycle (Field24) — varchar2
  • eol (Field25) — varchar2
  • eosl (Field26) — varchar2
  • new_patch (Field27) — varchar2
  • reg_date (Field28) — date
  • useyn (Field30) — varchar2

TBERR (eseq)

  • seq (pk) — varchar2 — 기본 키 — NOT NULL
  • id (Field) — varchar2
  • gubun (Field2) — varchar2
  • sysnm (Field3) — varchar2
  • prodnm (Field4) — varchar2
  • exenm (Field5) — varchar2
  • title (Field6) — varchar2
  • content (Field7) — varchar2
  • impact (Field8) — varchar2
  • cause (Field9) — varchar2
  • sv_state (Field10) — varchar2
  • rec_time (Field11) — varchar2
  • err_grade (Field12) — varchar2
  • err_state (Field13) — varchar2
  • after (Field14) — varchar2
  • rec_result (Field15) — varchar2
  • reg_date (Field16) — date
  • err_start_date (Field17) — varchar2
  • err_start_time (Field18) — varchar2
  • err_end_date (Field19) — varchar2
  • err_end_time (Field20) — varchar2
  • signline (Field21) — varchar2

TBERRSIGN (fk eseq)

  • seq (pk) — varchar2 — 외래 키 → TBERR.seq — NOT NULL
  • state (Field) — varchar2
  • manager (Field2) — varchar2
  • reg_date (Field3) — date
  • pm (Field4) — varchar2
  • pm_date (Field5) — date
  • admin (Field6) — varchar2
  • admin_date (Field7) — date
  • adhead (Field8) — varchar2
  • adhead_date (Field9) — date

TBNOTI

  • seq — varchar2 — 기본 키 — NOT NULL
  • empno — varchar2
  • empnm — varchar2
  • deptno — varchar2
  • deptnm — varchar2
  • title — varchar2
  • content — varchar2
  • filename — varchar2
  • state — varchar2
  • up_date — date
  • up_empno — varchar2
  • reg_date — date
  • readnum — number
  • isyn — varchar2

TBNOTIREPL (fk nseq)

  • seq (fk) — varchar2 — 외래 키 → TBNOTI.seq — NOT NULL
  • no (Field4) — varchar2
  • empno (Field) — varchar2
  • empnm (Field6) — varchar2
  • deptno (Field2) — varchar2
  • deptnm (Field7) — varchar2
  • reply (Field3) — varchar2
  • up_date (Field5) — date
  • up_empno (Field8) — varchar2
  • reg_date (Field9) — date
  • isyn (Field11) — varchar2

TBOFT

  • seq — varchar2 — 기본 키 — NOT NULL
  • gubun — varchar2
  • state — varchar2
  • empno — varchar2
  • empnm — varcahr2
  • deptno — varchar2
  • deptnm — varchar2
  • title — varchar2
  • content — varchar2
  • filename — varchar2
  • up_date — date
  • up_empno — varchar2
  • reg_date — date
  • isyn — varchar2

TBQNA (qseq)

  • seq (pk) — varchar2 — 기본 키 — NOT NULL
  • empno (Field) — varchar2
  • empnm (Field11)
  • deptno (Field2) — varchar2
  • deptnm (Field12)
  • title (Field3) — varchar2
  • content (Field4) — varchar2
  • filename (Field7) — varchar2
  • reg_date (Field5) — date
  • up_date (Field9) — date
  • up_empno (Field10) — varchar2
  • state (Field6) — varchar2
  • isyn (Field8) — varchar2

TBQNAREP(보류) (fk qseq)

  • seq (Field10) — varchar2
  • empno (Field) — varchar2
  • deptno (Field2) — varchar2
  • title (Field3) — varchar2
  • content (Field4) — varchar2
  • filename (Field5) — varchar2
  • up_date (Field6) — date
  • up_empno (Field7) — varcahr2
  • reg_date (Field8) — date
  • isyn (Field9) — varchar2

TBREQ

  • seq — varchar2 — 기본 키 — NOT NULL
  • empno — varchar2
  • deptno — varchar2
  • title — varchar2
  • content — varchar2
  • filename — varchar2
  • state — varchar2
  • try_date — date
  • try_content — varchar2
  • sr_num — varchar2
  • reg_date — date
  • up_date — date
  • isyn — varchar2

TBRSP (fk rseq)

  • seq (fk) — varchar2 — 외래 키 → TBREQ.seq — NOT NULL
  • devno (Field) — varchar2
  • admno (Field2) — varchar2
  • status (Field3) — varchar2
  • task_date (Field5) — date
  • start_date (Field6) — date
  • end_date (Field7) — date
  • erp_path (Field8) — varchar2
  • erp_name (Field9) — varchar2
  • rsp_content (Field10) — varchar2
  • rsp_result (Field11) — varchar2
  • rsp_filename (Field12) — varchar2
  • rsp_reg_date (Field13) — date
  • rsp_up_date (Field4) — date
  • isyn (Field14) — varchar2

TBSUBCT (sseq)

  • seq (pk) — varchar2 — 기본 키 — NOT NULL
  • sysnm (Field) — varchar2
  • devcnm (Field2) — varchar2
  • assetno (Field3) — varchar2
  • comnm (Field4) — varchar2
  • eng1nm (Field5) — varchar2
  • eng1tel (Field6) — varchar2
  • eng1em (Field7) — varchar2
  • eng2nm (Field8) — varchar2
  • eng2tel (Field9) — varchar2
  • eng2em (Field10) — varchar2
  • salesnm (Field11) — varchar2
  • salestel (Field12) — varchar2
  • salesem (Field13) — varchar2
  • chk_cycle (Field14) — varchar2
  • chk_way (Field15) — varchar2
  • asset_loc (Field16) — varchar2
  • reg_date (Field17) — date
  • empno (Field18) — varchar2
  • deptno (Field19) — varchar2
  • useyn (Field20) — varchar2

TBTASKLOG (FK SEQ)

  • (pk) — varchar2 — 외래 키 → TBREQ.seq — NOT NULL
  • (fk) — varchar2 — 외래 키 → TBRSP.seq — NOT NULL
  • seq (Field) — varchar2
  • state (Field2) — varchar2
  • empno (Field3) — varchar2
  • deptno (Field4) — varchar2
  • empnm (Field6) — varchar2
  • deptnm (Field7) — varchar2
  • exeno (Field8) — varchar2
  • exenm (Field9) — varchar2
  • reg_date (Field5) — date