원티드 프리온보딩
테이블 (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