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