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