구인구직파이널

테이블 (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