추천

테이블 (6)

careers

  • career_id — bigint(20) — 기본 키 — NOT NULL
  • category — varchar(255)
  • period — int(11) — NOT NULL
  • resume_id — bigint(20) — 외래 키 → resumes.resume_id — NOT NULL

job_announcement

  • job_announcement_id — bigint(20) — 기본 키 — NOT NULL
  • application_date — varchar(255)
  • business_address — varchar(255)
  • company_name — varchar(255)
  • company_type — varchar(255)
  • contact_number — varchar(255)
  • entry_form — varchar(255)
  • form_of_wages — varchar(255)
  • major_field — varchar(255)
  • recruitment_period — varchar(255)
  • recruitment_type — varchar(255)
  • registration_date — varchar(255)
  • required_credentials — varchar(255)
  • required_education — varchar(255)
  • required_experience — varchar(255)
  • responsible_agency — varchar(255)
  • type_of_employment — varchar(255)
  • wage — varchar(255)

member_wishlist

  • member_id — bigint(20) — 외래 키 → members.member_id — NOT NULL
  • job_announcement_id — bigint(20) — 외래 키 → job_announcement.job_announcement_id — NOT NULL

members

  • member_id — bigint(20) — 기본 키 — NOT NULL
  • address_details — varchar(100) — NOT NULL
  • address_info — varchar(100) — NOT NULL
  • age — int(11) — NOT NULL
  • disability_type — varchar(255) — NOT NULL
  • email — varchar(20) — NOT NULL
  • encrypted_pwd — varchar(255) — NOT NULL
  • username — varchar(20) — NOT NULL

resume_entity_certifications

  • resume_entity_resume_id — varchar(255) — 외래 키 → resumes.resume_id — NOT NULL
  • certifications — varchar(255)

resumes

  • resume_id — bigint(20) — 기본 키 — NOT NULL
  • education — varchar(255)
  • major — varchar(255)
  • prefer_income — bigint(20) — NOT NULL
  • prefer_keyword — varchar(255)
  • work_type — varchar(255)
  • member_id — bigint(20) — 외래 키 → members.member_id — NOT NULL