이력관리플랫폼 설계
테이블 (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