devjob
테이블 (8)
CAREER
- CAREER_IDX — NUMBER — 기본 키 — NOT NULL
- PROJECT_NAME — VARCHAR2(100) — NOT NULL
- PROJECT_STARTDATE — VARCHAR2(100) — NOT NULL
- PROJECT_ENDDATE — VARCHAR2(100) — NOT NULL
- LANGUAGE — VARCHAR2(100)
- DBMS — VARCHAR2(100)
- PER_ID — VARCHAR2(100)
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- PER_ID (FK_PER_ID) — VARCHAR2(100) — 외래 키 → 개인회원.PER_ID — NOT NULL
EDUCATION
- EDU_IDX — NUMBER — 기본 키 — NOT NULL
- EDU_NAME — VARCHAR2(100) — NOT NULL
- EDU_INSTITUTE — VARCHAR2(100) — NOT NULL
- EDU_STARTDATE — VARCHAR2(100) — NOT NULL
- EDU_ENDDATE — VARCHAR2(100) — NOT NULL
- PER_ID — VARCHAR2(100)
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- PER_ID (FK_PER_ID) — VARCHAR2(100) — 외래 키 → 개인회원.PER_ID — NOT NULL
개인회원 (PERSONAL)
- PER_ID — VARCHAR2(100) — 기본 키 — NOT NULL
- PER_NAME — VARCHAR2(100) — NOT NULL
- PER_PWD — VARCHAR2(100) — NOT NULL
- PER_PH — VARCHAR2(100) — NOT NULL
- PER_EMAIL — VARCHAR2(100) — NOT NULL
- PER_BIRTH — VARCHAR2(100)
- PER_SEX — VARCHAR2(100)
- PER_ADDR — VARCHAR2(100)
- PER_PROFILE_IMAGE — VARCHAR2(100)
- PER_DEL_YN — VARCHAR2(100)
- PER_JOIN_DATE — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- ROLE — VARCHAR2(100) — NOT NULL
공고 (POST)
- POST_IDX — NUMBER — 기본 키 — NOT NULL
- POST_NAME — VARCHAR2(100) — NOT NULL
- POST_STATE — VARCHAR2(100) — NOT NULL
- POST_BUDGET — VARCHAR2(100) — NOT NULL
- PROJECT_ENDDATE — VARCHAR2(100) — NOT NULL
- PROJECT_ADDR — VARCHAR2(100) — NOT NULL
- POST_ENDDATE — VARCHAR2(100) — NOT NULL
- CMP_REG_NO — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- CMP_REG_NO (FK_CMP_REG_NO) — VARCHAR(100) — 외래 키 → 기업.CMP_REG_NO — NOT NULL
공통코드 (COMMON_CODE)
- GUBUN — VARCHAR2(100) — 기본 키 — NOT NULL
- CODE — VARCHAR2(100) — 기본 키 — NOT NULL
- NAME — VARCHAR2(100)
- NOTE — VARCHAR2(100)
기업 (COMPANY)
- CMP_REG_NO — VARCHAR2(100) — 기본 키 — NOT NULL
- CMP_NAME — VARCHAR2(100) — NOT NULL
- CMP_OWNER — VARCHAR2(100) — NOT NULL
- CMP_TP_CD — VARCHAR2(100) — NOT NULL
- CMP_REG_IMAGE — VARCHAR2(100) — NOT NULL
- CMP_CLSD_YN — VARCHAR2(100)
- CMP_DEL_YN — VARCHAR2(100)
- CMP_JOIN_DATE — VARCHAR2(100) — NOT NULL
- CMP_WTHDR_DATE — VARCHAR2(100)
- FRST_REGISTER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- STORED_FILE_NAME — VARCHAR2(100)
담당자 (CHARGE)
- PIC_ID — VARCHAR2(100) — 기본 키 — NOT NULL
- PIC_NAME — VARCHAR2(100) — NOT NULL
- PIC_PWD — VARCHAR2(100) — NOT NULL
- PIC_PH — VARCHAR2(100) — NOT NULL
- PIC_EMAIL — VARCHAR2(100) — NOT NULL
- PIC_DEL_YN — VARCHAR2(100)
- PIC_JOIN_DATE — VARCHAR2(100) — NOT NULL
- PIC_WTHDR_DATE — VARCHAR2(100)
- CMP_REG_NO — VARCHAR2(100)
- FRST_REGISTER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- CMP_REG_NO (FK_CMP_REG_NO) — VARCHAR(100) — 외래 키 → 기업.CMP_REG_NO — NOT NULL
- ROLE — VARCHAR2(100) — NOT NULL
지원자 (APPLICANT)
- APPLICANT_IDX — NUMBER — 기본 키 — NOT NULL
- POST_IDX — NUMBER — NOT NULL
- PER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(100) — NOT NULL
- FRST_REGISTER_PNTTM — VARCHAR2(100) — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(100)
- LAST_UPDUSR_PNTTM — VARCHAR2(100)
- PER_ID (FK_PER_ID) — VARCHAR2(100) — 외래 키 → 개인회원.PER_ID — NOT NULL
- POST_IDX (FK_POST_IDX) — NUMBER — 외래 키 → 공고.POST_IDX — NOT NULL