현장실습(개선)
테이블 (13)
TCP_SIGN
- SIGNIDX — VARCHAR2(20) — 기본 키 — NOT NULL
- 사용테이블 (SIGNTABLE) — VARCHAR2(20) — 기본 키 — NOT NULL
- 현장실습기업IDX (TCPBIZ) — VARCHAR2(20)
- 서명한아이디 (USERID) — VARCHAR2(20)
- 서명한권한 (MAUTH) — VARCHAR2(20)
기업평가/교수평가 TCP_EVALUATION (TCP_EVALUATION)
- TCPRESULTIDX — NUMBER(8) — 기본 키 — NOT NULL
- PID — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.PID — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.공고번호 — NOT NULL
- TCPBIZ — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.TCPBIZ — NOT NULL
- TCPTERM — VARCHAR2(10)
- BID — VARCHAR2(20)
- Q1 — VARCHAR2(5)
- Q2 — VARCHAR2(5)
- Q3 — VARCHAR2(5)
- Q4 — VARCHAR2(5)
- Q5 — VARCHAR2(5)
- Q6 — VARCHAR2(5)
- Q7 — VARCHAR2(5)
- Q8 — VARCHAR2(5)
- Q9 — VARCHAR2(1000)
- Q10 — VARCHAR2(100)
- Q11 — CLOB
- WDATE — DATE
- EVALUATOR — VARCHAR2(10)
- TPOINT — VARCHAR2(20)
- Q12 — VARCHAR2(20)
- Q13 — VARCHAR2(20)
- WMUID — VARCHAR2(20)
사전서면점검서TCP_PERINSPECTION (TCP_PERINSPECTION)
- 사전서면점검서번호 (PERINIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- TCPBIZ — NUMBER(8) — 외래 키 → 현장실습 기업 TCP_BIZ.TCPBIZ — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.공고번호 — NOT NULL
- CHECK1GITA — VARCHAR2(100)
- CHECK2 — VARCHAR2(100)
- CHECK2GITA — VARCHAR2(100)
- CHECK3 — VARCHAR2(100)
- CHECK4 — VARCHAR2(100)
- CHECK4GITA — VARCHAR2(100)
- CHECK5 — VARCHAR2(100)
- CHECK6 — VARCHAR2(100)
- CHECK7 — VARCHAR2(100)
- CHECK8 — VARCHAR2(100)
설문관리 TSURVEYMASTER (TSURVEYMASTER)
- SIDX (TCPIDX) — NUMBER(8) — 기본 키 — NOT NULL
- SSIDX — NUMBER(8) — 기본 키 — NOT NULL
- STYPE — NUMBER(8) — 기본 키 — NOT NULL
- 설문코드 문항세트 (SVIDX) — NUMBER(8) — 기본 키 — NOT NULL
- SURVEYTITLE — VARCHAR2(300)
- SURVEYWHO — VARCHAR2(5)
- SURVEYSDATE — DATE
- SURVEYEDATE — DATE
- INFO — VARCHAR2(4000)
- SURVEYURL — VARCHAR2(100)
- SURVEYCHK — VARCHAR2(5)
- AUTOTYPE — VARCHAR2(5)
- DPTYPE — VARCHAR2(300)
- DEPT — VARCHAR2(2000)
- GRADE — VARCHAR2(50)
- REGISTER — VARCHAR2(20)
- MAUTH — VARCHAR2(20)
- GROUPS — VARCHAR2(20)
- WDATE — DATE
- WMUID — VARCHAR2(20)
- WUSERNAME — VARCHAR2(50)
설문답변 TSURVEYANS (TSURVEYANS)
- SIDX (TCPIDX) — VARCHAR2(10) — 기본 키 — NOT NULL
- STYPE — VARCHAR2(5) — 기본 키 — NOT NULL
- 설문코드 문항세트 (SVIDX) — NUMBER(8) — 기본 키 — NOT NULL
- USERID — VARCHAR2(30) — 기본 키 — NOT NULL
- USERNAME — VARCHAR2(100)
- MAUTH — VARCHAR2(5)
- DEPT — VARCHAR2(30)
- GRADE — VARCHAR2(5)
- GENDER — VARCHAR2(5)
- MOBILE — VARCHAR2(30)
- EMAIL — VARCHAR2(30)
- WDATE — DATE
- WMUID — VARCHAR2(30)
- WUSERNAME — VARCHAR2(30)
- ANS1 — VARCHAR2(2000)
- ANS2 — VARCHAR2(2000)
- ANS3 — VARCHAR2(2000)
- ANS4 — VARCHAR2(2000)
- ANS5 — VARCHAR2(2000)
- ANS6 — VARCHAR2(2000)
- ANS7 — VARCHAR2(2000)
- ANS8 — VARCHAR2(2000)
- ANS9 — VARCHAR2(2000)
- ANS10 — VARCHAR2(2000)
- ANS11 — VARCHAR2(2000)
- ANS12 — VARCHAR2(2000)
- ANS13 — VARCHAR2(2000)
- ANS14 — VARCHAR2(2000)
- ANS15 — VARCHAR2(2000)
- ANS16 — VARCHAR2(2000)
- ANS17 — VARCHAR2(2000)
- ANS18 — VARCHAR2(2000)
- ANS19 — VARCHAR2(2000)
- ANS20 — VARCHAR2(2000)
- ANS21 — VARCHAR2(2000)
- ANS22 — VARCHAR2(2000)
- ANS23 — VARCHAR2(2000)
- ANS24 — VARCHAR2(2000)
- ANS25 — VARCHAR2(2000)
- ANS26 — VARCHAR2(2000)
- ANS27 — VARCHAR2(2000)
- ANS28 — VARCHAR2(2000)
- ANS29 — VARCHAR2(2000)
- ANS30 — VARCHAR2(2000)
- ANS31 — VARCHAR2(2000)
- ANS32 — VARCHAR2(2000)
- ANS33 — VARCHAR2(2000)
- ANS34 — VARCHAR2(2000)
- ANS35 — VARCHAR2(2000)
- ANS36 — VARCHAR2(2000)
- ANS37 — VARCHAR2(2000)
- ANS38 — VARCHAR2(2000)
- ANS39 — VARCHAR2(2000)
- ANS40 — VARCHAR2(2000)
- ANS41 — VARCHAR2(2000)
- ANS42 — VARCHAR2(2000)
- ANS43 — VARCHAR2(2000)
- ANS44 — VARCHAR2(2000)
- ANS45 — VARCHAR2(2000)
- ANS46 — VARCHAR2(2000)
- … +16
순회지도보고서 TCP_VISITEACT (TCP_VISITEACT)
- 순회지도보고서 번호 (TCPVA) — VARCHAR2(20) — 기본 키 — NOT NULL
- TCPBIZ — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.TCPBIZ — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.공고번호 — NOT NULL
- BID — NUMBER(8)
- PM_NAME — VARCHAR2(50)
- PM_JOB — VARCHAR2(50)
- PM_DEPT — VARCHAR2(50)
- PM_MOBILE — VARCHAR2(50)
- PM_TEL — VARCHAR2(50)
- PM_FAX — VARCHAR2(50)
- PM_EMAIL — VARCHAR2(50)
- CONTENT — CLOB
- CONFER — CLOB
- TCEIDX — NUMBER(8)
- TCPVAS — VARCHAR2(10)
- VDATE — DATE
- PID — VARCHAR2(2000)
- W_ACT_DEPT — VARCHAR2(50)
- W_ACT_MUID — VARCHAR2(50)
- CONFIRM_DATE — DATE
운영계획서 TCP_BIZOPER (TCP_BIZOPER)
- 운영계획서번호 (OPERIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- TCPBIZ — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.TCPBIZ — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 기업 TCP_BIZ.공고번호 — NOT NULL
- BID — VARCHAR2(20)
- BIZNAME — VARCHAR2(100)
- BIZNAMEEN — VARCHAR2(100)
- CEONAME — VARCHAR2(100)
- BIZNUM — VARCHAR2(100)
- OPENBIZ — VARCHAR2(100)
- KSSC — VARCHAR2(100)
- WORKERS — VARCHAR2(100)
- SALES — VARCHAR2(100)
- ADDRESS — VARCHAR2(100)
- HOMEPAGE — VARCHAR2(100)
- BIZTYPE — VARCHAR2(100)
- BIZSIZE — VARCHAR2(100)
- DAYTIME1 — VARCHAR2(100)
- DAYTIME2 — VARCHAR2(100)
- DAYWEEK1 — VARCHAR2(100)
- DAYWEEK2 — VARCHAR2(100)
- OPERDEPT — VARCHAR2(100)
- OPERNAME — VARCHAR2(100)
- OPERSPOT — VARCHAR2(100)
- OPERTEL — VARCHAR2(100)
- OPERMOBILE — VARCHAR2(100)
- OPEREMAIL — VARCHAR2(100)
- REPORTTYPE — VARCHAR2(100)
- SCHEDULE1 — VARCHAR2(100)
- SCHEDULE2 — VARCHAR2(100)
- SCHEDULE3 — VARCHAR2(100)
- OPERPROCESS — VARCHAR2(100)
- OPERTYPE — VARCHAR2(100)
- TRAININGDAY — VARCHAR2(100)
- OVERTIME — VARCHAR2(100)
- WORKCONTRACTGITA — VARCHAR2(100)
- PAYWM — VARCHAR2(100)
- PAYWMMONEY — VARCHAR2(100)
- OVERTIMEMONEY — VARCHAR2(100)
- SEXPECTED — VARCHAR2(100)
- EEXPECTED — VARCHAR2(100)
- SUPPORTGITA — VARCHAR2(100)
- SITEPM — VARCHAR2(100)
- SITENAME — VARCHAR2(100)
- SITERANK — VARCHAR2(100)
- SITETEL — VARCHAR2(100)
- SITEMOBILE — VARCHAR2(100)
- SITEEMAIL — VARCHAR2(100)
- TRAININGDEPT — VARCHAR2(100)
- TRAININGADDRESS — VARCHAR2(100)
- TRAININGWORK — VARCHAR2(100)
- TRAININGGOAL — VARCHAR2(100)
- TRAININGPOSITION — VARCHAR2(100)
- TRAININGTAGET — VARCHAR2(100)
- PERCOUNT — VARCHAR2(100)
- PERGRADE — VARCHAR2(100)
- PERSCORE — VARCHAR2(100)
- PERREQUEST — VARCHAR2(100)
- PERGITA — VARCHAR2(100)
- SDATE — DATE
- EDATE — DATE
- … +7
종합보고서 TCP_REPORT (TCP_REPORT)
- 종합보고서 번호 (REPORTIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- PID — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.PID — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.공고번호 — NOT NULL
- INTE_RPT1 — CLOB
- INTE_RPT2 — CLOB
- INTE_RPT3 — CLOB
- INTE_RPT4 — CLOB
- INTE_RPT5 — CLOB
- WDATE — DATE
- INTE_RPT6 — CLOB
주간보고서 TCP_RPTWEEK (TCP_RPTWEEK)
- 주간보고서 번호 (RPTWEEKIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- PID — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.PID — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.공고번호 — NOT NULL
- WEEK_RPT — CLOB
- WDATE — DATE
- WMUID — VARCHAR2(20)
- RCHECK — VARCHAR2(10)
- FILEPATH — VARCHAR2(500)
- TCPBIZ — NUMBER(8)
- TCPTYPE — VARCHAR2(10)
중간보고서 TCP_OPRSVY (TCP_OPRSVY)
- 중간보고서 번호 (OPRIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- PID (PID2) — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.PID — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 학생 TCP_PER.공고번호 — NOT NULL
- PID — VARCHAR2(20)
- Q1 — VARCHAR2(5)
- Q2 — VARCHAR2(5)
- Q3 — VARCHAR2(5)
- Q4 — VARCHAR2(5)
- Q5 — VARCHAR2(5)
- Q6 — VARCHAR2(5)
- Q7 — VARCHAR2(5)
- Q8 — VARCHAR2(5)
- Q9 — VARCHAR2(5)
- Q10 — VARCHAR2(5)
- Q11 — VARCHAR2(5)
- Q12 — VARCHAR2(5)
- Q13 — VARCHAR2(5)
- Q14 — VARCHAR2(5)
- Q14_GITA — VARCHAR2(100)
- Q15 — VARCHAR2(5)
- Q16 — VARCHAR2(5)
- Q17 — CLOB
- WDATE — DATE
- HTYPE — VARCHAR2(10)
- UDATE — DATE
- Q4_ETC — VARCHAR2(30)
- Q6_ETC — VARCHAR2(30)
- Q7_ETC — VARCHAR2(30)
현장실습 공고 TCP_NOTICE (TCP_NOTICE)
- 공고번호 (TCPIDX) — VARCHAR2(20) — 기본 키 — NOT NULL
- 년도 (TCPYEAR) — VARCHAR2(20)
- 학기 (TCPTERM) — VARCHAR2(20)
- 타입 (TCPTYPE) — VARCHAR2(20)
- RSDATEBIZ — DATE
- REDATEBIZ — DATE
- RSDATEPER — DATE
- REDATEPER — DATE
- TITLE — VARCHAR2(500)
- CONTENT — CLOB
- WNMUID — VARCHAR2(50)
- WNDATE — DATE
- RSDATEASS — DATE
- REDATEASS — DATE
- RSDATEPERRPT — DATE
- REDATEPERRPT — DATE
- SSIDX — VARCHAR2(10)
- BIZSSIDX — VARCHAR2(10)
- SVIDX — VARCHAR2(10)
- BIZSVIDX — VARCHAR2(10)
현장실습 기업 TCP_BIZ (TCP_BIZ)
- TCPBIZ — VARCHAR2(20) — 기본 키 — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 공고 TCP_NOTICE.공고번호 — NOT NULL
- BID — VARCHAR2(20)
- BIZNAME — VARCHAR2(100)
- PM_NAME — VARCHAR2(50)
- PM_JOB — VARCHAR2(50)
- PM_DEPT — VARCHAR2(50)
- PM_MOBILE — VARCHAR2(50)
- PM_TEL — VARCHAR2(50)
- PM_FAX — VARCHAR2(50)
- PM_EMAIL — VARCHAR2(50)
- TCPTERM — VARCHAR2(50)
- MUID — VARCHAR2(50)
- DEPT — VARCHAR2(50)
- TITLE — VARCHAR2(500)
- BSDATE — DATE
- BEDATE — DATE
- BCOURSE — VARCHAR2(10)
- BWDAY — NUMBER(8)
- PSHOUR — VARCHAR2(20)
- PEHOUR — VARCHAR2(10)
- REGGRADE — VARCHAR2(10)
- MAJORCHECK — VARCHAR2(10)
- MAJORRECRUIT — VARCHAR2(50)
- REQUIREMENT — CLOB
- SUPPORT — CLOB
- CONTENT — CLOB
- MGRPLAN — CLOB
- TCPBIZS — VARCHAR2(10)
- WBMUID — VARCHAR2(50)
- WBDATE — DATE
- AREAHOPE — VARCHAR2(100)
- FILES1 — VARCHAR2(200)
- TCPNOTI — VARCHAR2(5)
- TCPTYPE — VARCHAR2(10)
- NCSCODE — VARCHAR2(200)
- NCSDETAIL — VARCHAR2(200)
- PERREG — VARCHAR2(20)
- TCPREGTYPE — VARCHAR2(5)
- CONFIRM_DATE — DATE
- DWDAY — NUMBER(8)
- PERCNT — VARCHAR2(10)
- REGGENDER — VARCHAR2(10)
- CVDATE — DATE
- WDATE — DATE
현장실습 학생 TCP_PER (TCP_PER)
- PID — VARCHAR2(20) — 기본 키 — NOT NULL
- 공고번호 (TCPIDX) — VARCHAR2(20) — 외래 키 → 현장실습 공고 TCP_NOTICE.공고번호 — NOT NULL
- MOBILE — VARCHAR2(50)
- TEL — VARCHAR2(50)
- EMAIL — VARCHAR2(50)
- WDATE — DATE
- PCOURSE — VARCHAR2(10)
- AREAHOPE — VARCHAR2(50)
- PSDATE — DATE
- PEDATE — DATE
- SIGN — VARCHAR2(10)
- PREG — VARCHAR2(10)
- TCPBIZ — NUMBER(8)
- FINISH — VARCHAR2(10)
- CHKCON — VARCHAR2(5)
- TCPREGTYPE — VARCHAR2(5)
- REQTCPBIZ — VARCHAR2(10)
- GRADUWORK — VARCHAR2(5)
- TCPREGS — VARCHAR2(5)
- MONEY — VARCHAR2(20)