jobboard
Tables (5)
Company (Untitled)
- 회사 ID (company_id) — integer — Primary key — NOT NULL — Company Unique ID
- 회사이름 (name) — varchar
- 회사종류 (type) — integer
- 평점취합 (gather_vote) — json
- 좋아요 (likes) — integer
- 주소 (Address) — integer
Works (Untitled3)
- 일 ID (work_id) — integer — Primary key — NOT NULL
- 회사 ID (company_id) — integer — Foreign key → Company.회사 ID — NOT NULL — Company Unique ID
- 종류 (work_type) — integer
- 근무지 (work_area) — integer
- 경력최소 (career_min) — integer
- 경력최대 (career_max) — integer
- 필수조건 (requirements) — jsonb
- 필요조건 (etc) — jsonb
- 마감일 (deat_line) — date
location (Untitled5)
- location_id — integer — Primary key — NOT NULL
- 지역명(대) (state) — string
- 지역명(중) (city) — string
- 지역명(소) (street) — string
taglist (Untitled4)
- name — varchar — Primary key — NOT NULL
- count — integer
vote (Untitled2)
- 작성자 (writer_id) — varchar — Primary key — NOT NULL
- 회사 ID (company_id) — integer — Foreign key → Company.회사 ID — NOT NULL — Company Unique ID
- 투표들 (votes) — json
- 태그 (tags) — json