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