HJSS
Tables (13)
COM_SCRAP_TB
- CSCRAP_IDX — NUMBER(8,0) — Primary key
- RESUME_IDX — NUMBER(10,0) — Foreign key → RESUME_TB.RESUME_IDX
- CID (ID) — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
JOB_POST_TB
- POST_IDX — NUMBER(8,0) — Primary key
- ID (ID3) — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- POST_NAME — VARCHAR2(1000 BYTE)
- CAREER — VARCHAR2(255 BYTE)
- JOB_TYPE — VARCHAR2(255 BYTE)
- PAY — VARCHAR2(255 BYTE)
- GO_WORK — VARCHAR2(255 BYTE)
- GO_HOME — VARCHAR2(255 BYTE)
- DEADLINE — VARCHAR2(255 BYTE)
- JOB_INTRO — VARCHAR2(4000 BYTE)
- C_INTRO — VARCHAR2(4000 BYTE)
- CREATED_DATE — DATE
PERSON_INFO_TB
- ID — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- PNAME — VARCHAR2(255 BYTE)
- PHONE — VARCHAR2(255 BYTE)
- ADDRESS — VARCHAR2(255 BYTE)
- BIRTH — DATE
PERSON_PROPOSAL_TB
- PRO_IDX — NUMBER(8,0) — Primary key
- ID (ID3) — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- POST_IDX (POST_IDX2) — NUMBER(8,0) — Foreign key → JOB_POST_TB.POST_IDX
- RESUME_IDX (RESUME_IDX2) — NUMBER(10,0) — Foreign key → RESUME_TB.RESUME_IDX
- STATUS — NUMBER(8,0)
- CREATED_AT — DATE
PERSON_SCRAP_TB
- POST_IDX (POST_IDX2) — NUMBER(8,0) — Foreign key → JOB_POST_TB.POST_IDX
- PSCRAP_IDX — NUMBER(8,0)
- PID (ID) — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
PERSON_SKILL_TB
- PSNO — NUMBER(8,0) — Primary key
- SKILL_IDX — NUMBER(8,0) — Foreign key → SKILL_TB.SKILL_IDX
- ID — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
POST_SKILL_TB
- CSNO — NUMBER(8,0) — Primary key
- SKILL_IDX — NUMBER(8,0) — Foreign key → SKILL_TB.SKILL_IDX
- POST_IDX (POST_IDX2) — NUMBER(8,0) — Foreign key → JOB_POST_TB.POST_IDX
PROPOSAL_STATUS_TB
- STATUS_IDX — NUMBER(8,0) — Primary key
- POST_IDX (POST_IDX2) — NUMBER(8,0) — Foreign key → JOB_POST_TB.POST_IDX
- ID (ID2) — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- PRO_IDX — NUMBER(8,0)
- COMMENTS — VARCHAR2(255 BYTE)
RESUME_TB
- RESUME_IDX — NUMBER(10,0) — Primary key
- ID — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- PROFILE — VARCHAR2(255 BYTE)
- TITLE — VARCHAR2(1000 BYTE)
- PORTFOLIO — VARCHAR2(1000 BYTE)
- PUBLISH — NUMBER(8,0)
- SELF_INTRO — VARCHAR2(4000 BYTE)
- CREATED_AT — DATE
SKILL_TB
- SKILL_IDX — NUMBER(8,0) — Primary key
- SKILL_NAME — VARCHAR2(255 BYTE)
USER_FAQ_TB
- Q_IDX — NUMBER(8,0)
- TYPE — NUMBER(8,0)
- QUESTION — VARCHAR2(4000 BYTE)
- ANSWER — VARCHAR2(4000 BYTE)
USER_TB
- ID — VARCHAR2(255 BYTE) — Primary key
- TYPE — NUMBER(8,0) — Primary key
- PASSWORD — VARCHAR2(255 BYTE)
- USER_EMAIL — VARCHAR2(255 BYTE)
- CREATED_DATE — DATE
company_info_tb
- ID — VARCHAR2(255 BYTE) — Foreign key → USER_TB.ID
- cname — VARCHAR2
- com_logo — VARCHAR2
- cnumber — NUMBER
- crepresentive — VARCHAR2
- address — VARCHAR2
- manager_name — VARCHAR2
- company_managerPhone — VARCHAR2
- csize — NUMBER
- cyear — VARCHAR2