employment

Tables (16)

APPLY_TB

  • APPLY_IDX — NUMBER — Primary key — NOT NULL
  • PERSON_IDX — NUMBER — Foreign key → PERSON_TB.PERSON_IDX — NOT NULL
  • POSTING_IDX — NUMBER — Foreign key → POSTING_TB.POSTING_IDX — NOT NULL
  • RESUME_IDX — NUMBER — Foreign key → RESUME_TB.RESUME_IDX — NOT NULL
  • CREATED_DATE — DATE
  • APPLY_STATUS — NUMBER

COMMUNITY_TB

  • COMMUNITY_IDX — NUMBER — Primary key — NOT NULL
  • COMMUNITY_TITLE — VARCHAR2
  • USER_IDX — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • COMMUNITY_NAME — VARCHAR2
  • COMMUNITY_CONTENT — VARCHAR2
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • VIEW_COUNT — NUMBER
  • LIKE_COUNT — NUMBER
  • REPLY_COUNT — NUMBER

COMPANY_FILE_TB

  • COMPANY_FILE_IDX — NUMBER — Primary key — NOT NULL
  • COMPANY_IDX — NUMBER — Foreign key → COMPANY_TB.COMPANY_IDX — NOT NULL
  • ORIGINAL_NAME — VARCHAR2
  • FILE_PATH — VARCHAR2
  • FILE_SIZE — NUMBER
  • UPLOAD_DATE — DATE

COMPANY_TB

  • COMPANY_IDX — NUMBER — Primary key — NOT NULL
  • USER_IDX — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • COMPANY_NAME — VARCHAR2
  • COMPANY_REP_NAME — VARCHAR2
  • COMPANY_ADDRESS — VARCHAR2
  • COMPANY_MGR_NAME — VARCHAR2
  • COMPANY_MGR_PHONE — VARCHAR2
  • COMPANY_EMP — NUMBER
  • COMPANY_SIZE — VARCHAR2
  • COMPANY_SECTOR — VARCHAR2
  • COMPANY_YEAR — DATE

FAQ_TB

  • FAQ_IDX — NUMBER — Primary key — NOT NULL
  • FAQ_TYPE — NUMBER
  • QUESTION — VARCHAR2
  • ANSWER — VARCHAR2

PERSON_SKILL_TB

  • POSTING_SKILL_IDX — NUMBER — Primary key — NOT NULL
  • SKILL_IDX — NUMBER — Foreign key → SKILL_TB.SKILL_IDX — NOT NULL
  • PERSON_IDX — NUMBER — Foreign key → PERSON_TB.PERSON_IDX — NOT NULL

PERSON_TB

  • PERSON_IDX — NUMBER — Primary key — NOT NULL
  • USER_IDX (USER_IDX2) — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • PERSON_NAME — VARCHAR2
  • PERSON_PHONE — VARCHAR2
  • PERSON_ADDRESS — VARCHAR2
  • PERSON_BIRTH — DATE
  • PERSON_EDUCATION — VARCHAR2

POSTING_SCRAP_TB

  • PSCRAP_IDX — NUMBER — Primary key — NOT NULL
  • PERSON_IDX — NUMBER — Foreign key → PERSON_TB.PERSON_IDX — NOT NULL
  • POSTING_IDX — NUMBER — Foreign key → POSTING_TB.POSTING_IDX — NOT NULL

POSTING_SKILL_TB

  • POSTING_SKILL_IDX — NUMBER — Primary key — NOT NULL
  • SKILL_IDX — NUMBER — Foreign key → SKILL_TB.SKILL_IDX — NOT NULL
  • POSTING_IDX — NUMBER — Foreign key → POSTING_TB.POSTING_IDX — NOT NULL

POSTING_TB

  • POSTING_IDX — NUMBER — Primary key — NOT NULL
  • USER_IDX (USER_IDX2) — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • POSTING_TITLE — VARCHAR2
  • POSTING_COMMENT — VARCHAR2
  • EXPERIENCE — VARCHAR2
  • EMP_TYPE — VARCHAR2
  • SALARY — VARCHAR2
  • START_TIME — VARCHAR2
  • END_TIME — VARCHAR2
  • POSTING_DEADLINE — DATE
  • JOB_TYPE — VARCHAR2

REPLY_TB

  • REPLY_IDX — NUMBER — Primary key — NOT NULL
  • COMMUNITY_IDX — NUMBER — Foreign key → COMMUNITY_TB.COMMUNITY_IDX — NOT NULL
  • USER_IDX — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • REPLY_NAME — VARCHAR2
  • REPLY_CONTENT — VARCHAR2
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • LIKE_COUNT — NUMBER

RESUME_FILE_TB

  • RESUME_FILE_IDX — NUMBER — Primary key — NOT NULL
  • RESUME_IDX — NUMBER — Foreign key → RESUME_TB.RESUME_IDX — NOT NULL
  • ORIGINAL_NAME — VARCHAR2
  • FILE_PATH — VARCHAR2
  • FILE_SIZE — NUMBER
  • UPLOAD_DATE — DATE

RESUME_SCRAP_TB

  • RSCRAP_IDX — NUMBER — Primary key — NOT NULL
  • COMPANY_IDX — NUMBER — Foreign key → COMPANY_TB.COMPANY_IDX — NOT NULL
  • RESUME_IDX — NUMBER — Foreign key → RESUME_TB.RESUME_IDX — NOT NULL

RESUME_TB

  • RESUME_IDX — NUMBER — Primary key — NOT NULL
  • USER_IDX (USER_IDX2) — NUMBER — Foreign key → USER_TB.USER_IDX — NOT NULL
  • RESUME_TITLE — VARCHAR2
  • PORTFOLIO — VARCHAR2
  • PUBLISH — NUMBER
  • RESUME_COMMENT — VARCHAR2
  • CREATED_DATE — VARCHAR2
  • UPDATED_DATE — VARCHAR2

SKILL_TB

  • SKILL_IDX — NUMBER — Primary key — NOT NULL
  • SKILL_NAME — VARCHAR2

USER_TB

  • USER_IDX — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2
  • USER_PW — VARCHAR2
  • USER_TYPE — NUMBER
  • USER_EMAIL — VARCHAR2
  • CREATED_DATE — VARCHAR2