recruitment

Tables (7)

board (공고)

  • board_id (PK) — long — Primary key — NOT NULL
  • company_id (PK2) — long — Foreign key → company.company_id — NOT NULL
  • location_id (location FK) — int — Foreign key → company.location_id — NOT NULL
  • country_id (PK22) — int — Foreign key → company.country_id — NOT NULL
  • city_id (PK3) — int — Foreign key → company.city_id — NOT NULL
  • region_id (PK4) — int — Foreign key → company.region_id — NOT NULL
  • reward (채용보상금) — int
  • description (채용내용) — varchar
  • position (채용포지션) — varchar
  • Field (채용기술) — varchar

city (도시)

  • city_id (PK) — int — Primary key — NOT NULL
  • name (도시명) — varchar

company (회사)

  • company_id (PK) — long — Primary key — NOT NULL
  • location_id (location FK) — int — Foreign key → location.location_id — NOT NULL
  • country_id (PK2) — int — Foreign key → location.country_id — NOT NULL
  • city_id (PK3) — int — Foreign key → location.city_id — NOT NULL
  • region_id (PK4) — int — Foreign key → location.region_id — NOT NULL
  • name (회사명) — varchar

country (국가)

  • country_id (PK) — int — Primary key — NOT NULL
  • name (국가명) — varchar

location (위치)

  • location_id (PK) — int — Primary key — NOT NULL
  • country_id (PK2) — int — Foreign key → country.country_id — NOT NULL
  • city_id (PK3) — int — Foreign key → city.city_id — NOT NULL
  • region_id (PK4) — int — Foreign key → region.region_id — NOT NULL

member (사용자)

  • user_id (PK) — long — Primary key — NOT NULL
  • submitted (지원 여부) — boolean

region (지역)

  • region_id (PK) — int — Primary key — NOT NULL
  • name (지역명) — varchar