Project
Tables (5)
Apply
- user_id — VARCHAR(50) — Foreign key → Seeker.user_id
- post_no — INT — Foreign key → JobPost.post_no
- result — VARCHAR(20)
- app_date — DATE
Company
- corp_id — VARCHAR(50)
- user_pw — VARCHAR(100)
- corp_name — VARCHAR(100)
- reg_num — VARCHAR(50)
- CEO — VARCHAR(50)
- contact — VARCHAR(50)
JobPost
- post_no — INT
- title — VARCHAR(100)
- job_type — VARCHAR(50)
- loc — VARCHAR(50)
- pay_info — INT
- end_date — DATE
- corp_id — VARCHAR(50) — Foreign key → Company.corp_id
Resume
- res_no — INT
- title — VARCHAR(100)
- edu — VARCHAR(50)
- career_desc — TEXT
- salary — INT
- user_id — VARCHAR(50) — Foreign key → Seeker.user_id
Seeker
- user_id — VARCHAR(50)
- user_pw — VARCHAR(100)
- name — VARCHAR(50)
- phone — VARCHAR(20)
- email — VARCHAR(100)
- addr — VARCHAR(200)