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