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)