Albajob

Tables (12)

ANNOUNCEMENT

  • ANNOUNCEMENT_ID — INT — Primary key — NOT NULL
  • PAY — INT — NOT NULL
  • JOB_NAME — STRING — NOT NULL
  • WORK_PERIOD — VARCHAR(45) — NOT NULL
  • WORK_DAY — VARCHAR(45) — NOT NULL
  • WORK_TIME — VARCHAR(45) — NOT NULL
  • RECRUIT_NUMBER — INT — NOT NULL
  • CITY_NAME — STRING — NOT NULL
  • MANAGER_NAME — VARCHAR(45) — NOT NULL
  • MANAGER_PHONE — VARCHAR(45) — NOT NULL
  • ANNOUNCEMENT_NAME — VARCHAR(45) — NOT NULL

CATEGORY

  • CATEGORY_ID — INT
  • CATEGORY_NAME — VARCHAR(20) — NOT NULL

CITY

  • CITY_ID — int
  • CITY_NAME — varchar(10) — NOT NULL

CompanyMember

  • USER_ID — int
  • USER_NAME — varchar(45)
  • USER_PASSWORD — varchar(255)
  • USER_PHONE — int
  • USER_MAIL — varchar(45)
  • COMPANY_NUMBER — varchar(45)
  • COMPANY_NAME — varchar(45)
  • PATH — varchar(45)
  • MEMBERSHIP — varchar(45)

JOB

  • CATEGORY_ID — INT
  • JOB_ID — INT
  • JOB_NAME — VARCHAR(20) — NOT NULL

Member

  • USER_ID — int
  • USER_NAME — varchar(45)
  • USER_PASSWORD — varchar(45)
  • USER_PHONE — varchar(45)
  • USER_MAIL — varchar(45)
  • PATH — varchar(45)

RESUME

  • RESUME_ID — INT — NOT NULL
  • USER_NAME — VARCHAR(50) — NOT NULL
  • RESUME_TITLE — VARCHAR(100) — NOT NULL
  • EDUCATION — VARCHAR(50)
  • EDUCATION_FORM — VARCHAR(50)
  • EXPERIENCE — VARCHAR(50)
  • TOWN_NAME — VARCHAR(50)
  • CITY_NAME — VARCHAR(50)
  • JOB_NAME — VARCHAR(50)
  • WORK_FORM — VARCHAR(50)
  • PERIOD_NAME — VARCHAR(50)
  • DAY_NAME — VARCHAR(50)
  • PARTTIME_NAME — VARCHAR(50)
  • SALARY — INT
  • SALARY_FORM — VARCHAR(50)
  • SKILL — VARCHAR(50)
  • INTRO — VARCHAR(255)
  • RESUME_DATE_CREATED — DATETIME

TOWN

  • CITY_ID — INT
  • TOWN_ID — INT
  • TOWN_NAME — VARCHAR(10) — NOT NULL

VILLAGE

  • TOWN_ID — INT
  • VILLAGE_ID — INT
  • VILLAGE_NAME — VARCHAR(10) — NOT NULL

WORK_DAY

  • DAY_ID — INT
  • DAY_NAME — VARCHAR(20)

WORK_PARTTIME

  • PARTTIME_ID — INT
  • PARTTIME_NAME — VARCHAR(20)

WORK_PERIOD

  • PERIOD_ID — INT
  • PERIOD_NAME — VARCHAR(20)