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)