이력관리플랫폼 설계

테이블 (6)

Resume (resume)

  • Resume Id (resume_id) — int(11) — 기본 키 — NOT NULL
  • User Id (user_id) — int(11) — 외래 키 → User.User Id — NOT NULL
  • Name (name) — VARCHAR(20)
  • Description (description) — VARCHAR(255)
  • Open YN (open_yn) — tiniint(1)
  • Create Date (create_date) — DATATIME
  • Update Date (update_date) — DATATIME

Resume_Element (resume_element)

  • RE Id (re_id) — int(11) — 기본 키 — NOT NULL
  • Field
  • RET Id (ret_id) — int(11) — 외래 키 → Resume_Element_Type.RET Id — NOT NULL
  • Section Id (section_id) — int(11) — 외래 키 → Section.Section Id — NOT NULL
  • Field2 — tiniint(1)
  • Field3 — int(2)
  • Field4 — DATATIME
  • Field5 — DATATIME

Resume_Element_Type (resume_element_type)

  • RET Id (ret_id) — int(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)
  • Description (description) — VARCHAR(255)
  • Type (type) — VARCHAR(20)
  • Label (label)

Resume_Element_Value (resume_element_value)

  • REV ID (rev_id) — int(11) — 기본 키 — NOT NULL
  • RE Id (re_id) — int(11) — 외래 키 → Resume_Element.RE Id — NOT NULL
  • RET Id (ret_id) — int(11) — 외래 키 → Resume_Element_Type.RET Id — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — LONGTEXT
  • Field4 — DATATIME
  • Field3 — tiniint(1)
  • Field5 — DATATIME
  • Field6 — DATATIME

Section (section)

  • Section Id (section_id) — int(11) — 기본 키 — NOT NULL
  • Resume Id (resume_id) — int(11) — 외래 키 → Resume.Resume Id — NOT NULL
  • Name (name) — VARCHAR(12)
  • Open YN (open_yn) — tiniint(1)
  • Priority (priority) — int(2)
  • Create Date (create_date) — DATATIME

User (user)

  • User Id (user_id) — int(11) — 기본 키 — NOT NULL
  • Create Date (create_date) — DATATIME
  • Update Date (update_date) — DATATIME
  • Field