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