원티드 프리온보딩

테이블 (4)

applyment (지원내역)

  • PK (id) — 기본 키 — NOT NULL
  • Field (created_date)
  • Field (modified_date)
  • FK (member_id) — 외래 키 → member.PK — NOT NULL
  • FK (recruitment_id) — int — 외래 키 → recruitment.PK — NOT NULL

company (회사)

  • PK (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (nation)
  • Field (region)
  • Field (created_date)
  • Field (modified_date)

member (사용자)

  • PK (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (phone_number)
  • Field (email)
  • Field (created_date)
  • Field (modified_date)

recruitment (채용공고)

  • PK (id) — int — 기본 키 — NOT NULL
  • Field (position) — varchar(50)
  • Field (reward) — int
  • Field (content) — clob
  • Field (tech) — varchar(20)
  • Field (created_date)
  • Field2 (modified_date)
  • FK (company_id) — 외래 키 → company.PK — NOT NULL