Job았죠?
테이블 (6)
Company
- company_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- size — VARCHAR(20)
JobPosting
- posting_id — BIGSERIAL
- platform_id — SERIAL — NOT NULL
- company_id — SERIAL
- title — VARCHAR(200) — NOT NULL
- job_type — VARCHAR(50)
- location — VARCHAR(100)
- min_salary — INTEGER
- max_salary — INTEGER
- posted_date — DATE — NOT NULL
- url — VARCHAR(500) — NOT NULL
- crawled_at — TIMESTAMP — NOT NULL
JobPosting_Skill
- posting_id — BIGSERIAL
- platform_id — SERIAL — NOT NULL
- company_id — SERIAL
- skill_id — SERIAL
Platform
- platform_id — SERIAL — NOT NULL
- name — VARCHAR(50) — NOT NULL
- base_url — VARCHAR(200) — NOT NULL
Skill
- skill_id — SERIAL
- name — VARCHAR(50) — NOT NULL
Users
- user_id — SERIAL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL