1111
Tables (6)
apply
- cover_id — number
- r_no — number
- apply_date — date
career
- id — varchar2(20) — Foreign key → p_member.id
- car_id — NUMBER
- X_job — varchar2(50)
- job_start — DATE
- job_end — DATE
coverletter
- id — varchar2(20) — Foreign key → p_member.id
- cover_id — NUMBER
- cover_title — varchar2(50)
- cover_moti — varchar2(1000)
- cover_ex — varchar2(1000)
- cover_per — varchar2(1000)
- cover_goal — varchar2(1000)
license
- l_code — varchar2(10)
- l_name — varchar2(50)
p_member
- id — varchar2(20)
- pw — varchar2(20)
- name — varchar2(50)
- age — NUMBER(2)
- gender — varchar2(1)
- tel — varchar2(13)
- email — varchar2(13)
resume
- id — varchar2(20) — Foreign key → p_member.id
- resume_no — NUMBER
- url — varchar2(1000)
- field — varchar2(50)
- car_id — number — Foreign key → career.car_id
- cover_id — number — Foreign key → coverletter.cover_id
- area — varchar2(20)
- l_code — varchar2(10) — Foreign key → license.l_code
- l_date — DATE
- pofo — varchar2(100)
- tel — varchar2(13)
- email — varchar2(50)