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