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