구인구직파이널
테이블 (14)
Role
- role_id — VARCHAR2(50)
- role_name — VARCHAR2(50) — NOT NULL
UserRoles
- user_id — VARCHAR2(50) — 기본 키 — NOT NULL
- role_id — VARCHAR2(50) — 기본 키 — NOT NULL
- user_type — VARCHAR2(20)
- admin)) — NOT — NOT NULL
admin
- admin_id — VARCHAR2(50)
- email — VARCHAR2(50) — NOT NULL
- password — VARCHAR2(225) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- birth — DATE
- tel — VARCHAR2(16)
application
- application_id — NUMBER
- resume_id — NUMBER
- jobPost_id — NUMBER
- jobseeker_id — VARCHAR2(50)
- created — DATE
- is_read — CHAR(1)
- applied_date — TIMESTAMP
blacklist
- jobSeeker_id — VARCHAR2(50)
- black_id — NUMBER
- comp_id — VARCHAR2(50)
- reason — VARCHAR2(1000)
- blacklist_date — DATE
- is_blacklisted — NUMBER(1)
- type — VARCHAR2(10)
company
- comp_id — VARCHAR2(50)
- password — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(50) — NOT NULL
- company_name — VARCHAR2(50) — NOT NULL
- business_number — VARCHAR2(20) — NOT NULL
- homepage — VARCHAR2(50)
- logo_name — VARCHAR2(255)
- logo_path — VARCHAR2(255)
- address — VARCHAR2(100)
- status — VARCHAR2(50)
jobPost
- jobPost_id — NUMBER
- comp_id — VARCHAR2(50)
- title — VARCHAR2(100) — NOT NULL
- content — VARCHAR2(3000)
- position — VARCHAR2(50)
- salary — VARCHAR2(20)
- experience — VARCHAR2(1000)
- education — VARCHAR2(1000)
- address — VARCHAR2(100)
- end_date — DATE
- homepage — VARCHAR2(50)
- created — DATE
- hit_no — NUMBER
- status — VARCHAR2(50)
- logo_name — VARCHAR2(255)
- logo_path — VARCHAR2(255)
- payment_status — VARCHAR2(50)
- After — Payment'))
jobSeeker
- jobSeeker_id — VARCHAR2(50)
- email — VARCHAR2(50) — NOT NULL
- password — VARCHAR2(225) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- birth — DATE
- tel — VARCHAR2(16)
- file_name — VARCHAR2(255)
- file_path — VARCHAR2(255)
- address — VARCHAR2(100)
jobSeekerScrap
- scrap_id — NUMBER
- jobSeeker_id — VARCHAR2(50) — NOT NULL
- jobPost_id — NUMBER
- created — DATE
- title — VARCHAR2(100)
- salary — VARCHAR2(20)
- address — VARCHAR2(100)
- end_date — DATE
- logo_name — VARCHAR2(255)
- logo_path — VARCHAR2(255)
payment
- payment_id — NUMBER
- comp_id — VARCHAR2(50)
- jobPost_id — NUMBER
- payment_date — DATE
- amount — NUMBER
requiredSkill
- requiredSkill_id — NUMBER
- jobPost_id — NUMBER
- skill — VARCHAR2(1000)
resume
- resume_id — NUMBER
- jobSeeker_id — VARCHAR2(50)
- title — VARCHAR2(100)
- content — VARCHAR2(2000)
- education — VARCHAR2(100)
- experience — VARCHAR2(1000)
- link — VARCHAR2(100)
- hit_no — NUMBER
- file_name — VARCHAR2(255)
- file_path — VARCHAR2(255)
- visibility_status — VARCHAR2(7) — NOT NULL
resumeSkill
- resumeSkill_id — NUMBER
- resume_id — NUMBER
- skill — VARCHAR2(1000)
suggestion
- sug_id — NUMBER
- name — VARCHAR2(30) — NOT NULL
- tel — VARCHAR2(30) — NOT NULL
- title — VARCHAR2(100) — NOT NULL
- content — VARCHAR2(1000) — NOT NULL
- created — DATE