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