입학홍보통합시스템
테이블 (3)
TG_HB_APPLY (프로그램 신청 정보)
- TG_HB_APY_ID (Key) — VARCHAR(2) — 기본 키 — NOT NULL
- TG_HB_APY_TYPE_CD (Field) — VARCHAR(2)
- TG_HB_APY_PRG_ID (Key2) — VARCHAR(2) — 외래 키 → TG_HB_PROGRAM.TG_HB_PRG_ID — NOT NULL
- TG_HB_APY_NM (Field3) — VARCHAR(2)
- TG_HB_APY_SCHOOL_CD (Field4) — VARCHAR(2)
- TG_HB_APY_REGION_CD (Field5) — VARCHAR(2)
- TG_HB_APY_TEL (Field6) — VARCHAR(2)
- TG_HB_APY_REQ_DATE (Field7) — DATE
- TG_HB_APY_REQ_TIME (Field8) — VARCHAR(2)
- TG_HB_APY_GRADE_CD (Field9) — VARCHAR(2)
- TG_HB_APY_PERSON_CNT (Field10) — VARCHAR(2)
- TG_HB_APY_PLACE (Field11) — VARCHAR(2)
- TG_HB_APY_DURATION (Field12) — NUMBER
- TG_HB_APY_STATUS_CD (Field13) — VARCHAR(2)
- TG_HB_APY_ADD_INFO (Field14) — VARCHAR(2)
- TG_HB_APY_AGREE_YN (Field15) — CHAR(1)
- TG_HB_APY_VEHICLE_INFO (Field16) — VARCHAR(2)
- TG_HB_APY_PT_ID (Field17) — VARCHAR(2)
- TG_HB_APY_SUPPORTERS (Field18) — VARCHAR(2)
- TG_HB_APY_STUDENT_NM (Field19) — VARCHAR(2)
- TG_HB_APY_STUDENT_HAKBUN (Field20) — VARCHAR(2)
- TG_HB_APY_STUDENT_TEL (Field21) — VARCHAR(2)
- TG_HB_APY_REG_ID (Field22) — VARCHAR(2)
- TG_HB_APY_REG_DT (Field23) — DATE
- TG_HB_APY_UPD_ID (Field24) — VARCHAR(2)
- TG_HB_APY_UPD_DT (Field25) — DATE
TG_HB_CODE (입학 홍보 공통 코드 정보)
- TG_HB_CODE_TYPE (Key) — VARCHAR2 — 기본 키 — NOT NULL
- TG_HB_CODE_CODE (Key2) — VARCHAR2 — 기본 키 — NOT NULL
- TG_HB_CODE_FNAME (Field) — VARCHAR2
- TG_HB_CODE_SNAME (Field2) — VARCHAR2
- TG_HB_CODE_ENAME (Field3) — VARCHAR2
- TG_HB_CODE_USE (Field4) — CHAR(1)
- TG_HB_REG_ID (Field5) — VARCHAR(2)
- TG_HB_REG_DT (Field6) — DATE
- TG_HB_UPD_ID (Field7) — VARCHAR(2)
- TG_HB_UPD_DT (Field8) — DATE
TG_HB_PROGRAM (학과 프로그램 정보)
- TG_HB_PRG_ID (Key) — VARCHAR(2) — 기본 키 — NOT NULL
- TG_HB_PRG_DEPT_CD (Field) — VARCHAR(2)
- TG_HB_PRG_TYPE_CD (Field2) — VARCHAR(2)
- TG_HB_PRG_DESC (Field3) — VARCHAR(2)
- TG_HB_PRG_DAY_CD (Field4) — VARCHAR(2)
- TG_HB_PRG_START_TIME (Field5) — VARCHAR(2)
- TG_HB_PRG_END_TIME (Field6) — VARCHAR(2)
- TG_HB_PRG_USE_YN (Field7) — CHAR(1)
- TG_HB_PRG_REG_ID (Field8) — VARCHAR(2)
- TG_HB_PRG_REG_DT (Field9) — DATE
- TG_HB_PRG_UPD_ID (Field10) — VARCHAR(2)
- TG_HB_PRG_UPD_DT (Field11) — DATE