didit2
테이블 (22)
공간
- spaceId — NOT — 기본 키 — NOT NULL
- memberId — NOT — 외래 키 — NOT NULL
- name — NOT — NOT NULL
- createDate — NOT — NOT NULL
- updateDate — NOT — NOT NULL
- deleteFlag — NOT — NOT NULL
alarm
- alarm_id — NOT — NOT NULL
- member_id — NOT — 외래 키 → member.member_id — NOT NULL
- time — NULL
- day — NULL
- create_at — NOT — NOT NULL
career
- career_id — NOT — NOT NULL
- resume_id — NOT — NOT NULL
- member_id — NOT — NOT NULL
- company — NOT — NOT NULL
- department — NOT — NOT NULL
- job_role — NOT — NOT NULL
- work_start_date — NOT — NOT NULL
- work_finish_date — NOT — NOT NULL
- is_working — NOT — NOT NULL
- create_at — NOT — NOT NULL
- update_at — NOT — NOT NULL
- field — VARCHAR(255)
career_skill
- career_skill_id — NOT — NOT NULL
- career_id — NOT — 외래 키 → career.career_id — NOT NULL
- type — NOT — NOT NULL
- create_at — NOT — NOT NULL
main_task
- task_id — NOT — NOT NULL
- career_id — NOT — 외래 키 → career.career_id — NOT NULL
- work_start_date — NOT — NOT NULL
- work_finish_date — NOT — NOT NULL
- achievement — NOT — NOT NULL
- explain — NOT — NOT NULL
- create_at — NOT — NOT NULL
member
- member_id — NOT — NOT NULL
- email — NOT — NOT NULL
- password — NOT — NOT NULL
- name — NOT — NOT NULL
- nick_name — NOT — NOT NULL
- job_family — NOT — NOT NULL
- job_role — NOT — NOT NULL
- create_at — NOT — NOT NULL
memoir
- memoir_id — NOT — NOT NULL
- space_id — NOT — 외래 키 → space.space_id — NOT NULL
- member_id — NOT — 외래 키 → space.member_id — NOT NULL
- title — NOT — NOT NULL
- content — VARCHAR(255)
- date — NOT — NOT NULL
- create_at — NOT — NOT NULL
skill
- member_skill_id — NOT — NOT NULL
- member_id — NOT — 외래 키 → member.member_id — NOT NULL
- type — NOT — NOT NULL
- create_at — NOT — NOT NULL
space
- space_id — NOT — NOT NULL
- member_id — NOT — 외래 키 → member.member_id — NOT NULL
- name — NOT — NOT NULL
- create_at — NOT — NOT NULL
tag
- tag_id — NOT — NOT NULL
- space_id — NOT — 외래 키 → memoir.memoir_id — NOT NULL
- type — NOT — NOT NULL
- create_at — NOT — NOT NULL
template
- template_id — NOT — NOT NULL
- space_id — NOT — 외래 키 → memoir.memoir_id — NOT NULL
- type — NOT — NOT NULL
- create_at — NOT — NOT NULL
공간
- space_id — NOT — 기본 키 — NOT NULL
- member_id — NOT — 외래 키 → 멤버.member_id — NOT NULL
- name — NOT — NOT NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
- delete_flag — NOT — NOT NULL
기술
- member_skill_id — NOT — 기본 키 — NOT NULL
- member_id — NOT — 외래 키 → 멤버.member_id — NOT NULL
- type — NOT — NOT NULL
- create_date — NOT — NOT NULL
멤버
- member_id — NOT — 기본 키 — NOT NULL
- email — NOT — NOT NULL
- password — NOT — NOT NULL
- name — NOT — NOT NULL
- nick_name — NOT — NOT NULL
- job_family — NOT — NOT NULL
- job_role — NOT — NOT NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
- delete_flag — NOT — NOT NULL
알람
- alaram_id — NOT — 기본 키 — NOT NULL
- member_id — NOT — 외래 키 → 멤버.member_id — NOT NULL
- time — NULL
- day — NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
이력
- carrer_id — NOT — 기본 키 — NOT NULL
- resume_id — NOT — 외래 키 — NOT NULL
- member_id — NOT — 외래 키 — NOT NULL
- company — NOT — NOT NULL
- department — NOT — NOT NULL
- job_role — NOT — NOT NULL
- work_start_date — NOTNULL
- work_finish_date — NOT — NOT NULL
- is_working — NOT — NOT NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
- delete_flag — NOT — NOT NULL
이력기술
- career_skill_id — NOT — 기본 키 — NOT NULL
- carrer_id — NOT — 외래 키 → 이력.carrer_id — NOT NULL
- type — NOT — NOT NULL
- create_date — NOT — NOT NULL
이력서
- resumeId — NOT — NOT NULL
- memberId — NOT — NOT NULL
- phone — NOT — NOT NULL
- email — NOT — NOT NULL
- oneLineIntroduction — NOT — NOT NULL
- createAt — NOT — NOT NULL
- up — pasted — NOT NULL
주요업무
- task_id — NOT — 기본 키 — NOT NULL
- carrer_id — NOT — 외래 키 → 이력.carrer_id — NOT NULL
- work_start_date — NOT — NOT NULL
- work_finish_date — NOT — NOT NULL
- achievement — NOT — NOT NULL
- explain — NOT — NOT NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
- delete_flag — NOT — NOT NULL
태그
- tag_id — NOT — 기본 키 — NOT NULL
- space_id — NOT — 외래 키 → 회고록.memoir_id — NOT NULL
- type — NOT — NOT NULL
- create_date — NOT — NOT NULL
템플릿
- template_id — NOT — 기본 키 — NOT NULL
- space_id — NOT — 외래 키 → 회고록.memoir_id — NOT NULL
- type — NOT — NOT NULL
- create_date — NOT — NOT NULL
회고록
- memoir_id — NOT — 기본 키 — NOT NULL
- space_id — NOT — 외래 키 → 공간.space_id — NOT NULL
- member_id — NOT — 외래 키 → 공간.member_id — NOT NULL
- titile — NOT — NOT NULL
- content — VARCHAR(255)
- write_date — NOT — NOT NULL
- create_date — NOT — NOT NULL
- update_date — NOT — NOT NULL
- delete_flag — NOT — NOT NULL