Daon-il

Tables (24)

application

  • application_id — BIGINT — Primary key — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.job_posting_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
  • status — ENUM( 'SUBMITTED', 'DOCUMENT_PASSED', 'DOCUMENT_FAILED', 'INTERVIEW_PASSED', 'INTERVIEW_FAILED', 'FINAL_ACCEPTED', 'FINAL_REJECTED' ) — NOT NULL
  • applied_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

bookmark

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.job_posting_id — NOT NULL
  • created_at — DATETIME — NOT NULL

certificate

  • certificate_id — BIGINT — Primary key — NOT NULL
  • certificate_name — VARCHAR(150) — NOT NULL
  • issuing_organization — VARCHAR(150)
  • description — VARCHAR(255)

company

  • company_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(30) — NOT NULL
  • industry_type_id — BIGINT — Foreign key → industry_type.industry_type_id
  • detail_industry_type_id — BIGINT — Foreign key → detail_industry_type.detail_industry_type_id
  • address — VARCHAR(255)
  • manager_name — VARCHAR(30)
  • manager_phone — VARCHAR(30)
  • company_email — VARCHAR(100)
  • company_description — TEXT
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

detail_industry_type

  • detail_industry_type_id — BIGINT — Primary key — NOT NULL
  • industry_type_id — BIGINT — Foreign key → industry_type.industry_type_id — NOT NULL
  • detail_industry_name — VARCHAR(100) — NOT NULL

disability

  • disability_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)

industry_keyword

  • industry_keyword_id — BIGINT — Primary key — NOT NULL
  • industry_type_id — BIGINT — Foreign key → industry_type.industry_type_id — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword_master.keyword_id — NOT NULL

industry_type

  • industry_type_id — BIGINT — Primary key — NOT NULL
  • industry_name — VARCHAR(100) — NOT NULL

job_posting

  • job_posting_id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT
  • job_category — VARCHAR(100)
  • employment_type — VARCHAR(50)
  • work_region — VARCHAR(100)
  • salary — VARCHAR(100)
  • work_hours — VARCHAR(100)
  • recruit_count — INT
  • qualification — TEXT
  • preference — TEXT
  • welfare — TEXT
  • application_start_date — DATE
  • application_end_date — DATE
  • is_closed — BOOLEAN — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

keyword_master

  • keyword_id — BIGINT — Primary key — NOT NULL
  • keyword_name — VARCHAR(100) — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • phone_number — VARCHAR(30)
  • address — VARCHAR(255)
  • role — ENUM('JOB_SEEKER', 'COMPANY', 'ADMIN') — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT — NOT NULL
  • is_important — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(255)
  • attachment_url — VARCHAR(255)
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_like

  • post_like_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

profile

  • profile_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • career — VARCHAR(255)
  • preferred_job — VARCHAR(100)
  • preferred_region — VARCHAR(100)
  • introduction — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

profile_certificate

  • profile_certificate_id — BIGINT — Primary key — NOT NULL
  • profile_id — BIGINT — Foreign key → profile.profile_id — NOT NULL
  • certificate_id — BIGINT — Foreign key → certificate.certificate_id — NOT NULL
  • acquired_date — DATE
  • score_or_grade — VARCHAR(50)
  • status — VARCHAR(50)

profile_disability

  • profile_disability_id — BIGINT — Primary key — NOT NULL
  • profile_id — BIGINT — Foreign key → profile.profile_id — NOT NULL
  • disability_id — BIGINT — Foreign key → disability.disability_id — NOT NULL
  • severity — VARCHAR(50)
  • note — VARCHAR(255)

profile_lang_qualification

  • profile_lang_qualification_id — BIGINT — Primary key — NOT NULL
  • profile_id — BIGINT — Foreign key → profile.profile_id — NOT NULL
  • language_name — VARCHAR(50) — NOT NULL
  • test_name — VARCHAR(100)
  • score — VARCHAR(50)
  • acquired_date — DATE
  • expiration_date — DATE

recruitment_step

  • recruitment_step_id — BIGINT — Primary key — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.job_posting_id — NOT NULL
  • recruitment_step_category_id — BIGINT — Foreign key → recruitment_step_category.recruitment_step_category_id — NOT NULL
  • step_order — INT — NOT NULL
  • step_name — VARCHAR(100)
  • description — VARCHAR(255)
  • step_start_date — DATE
  • step_end_date — DATE

recruitment_step_category

  • recruitment_step_category_id — BIGINT — Primary key — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL

report

  • report_id — BIGINT — Primary key — NOT NULL
  • reporter_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • target_type — ENUM('POST', 'COMMENT', 'MEMBER', 'JOB_POSTING') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

resume

  • resume_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • user_photo — VARCHAR(255)
  • content — TEXT
  • portfolio_url — VARCHAR(255)
  • education — TEXT
  • career_history — TEXT
  • self_introduction — TEXT
  • is_public — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

resume_certificate

  • resume_certificate_id — BIGINT — Primary key — NOT NULL
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
  • certificate_id — BIGINT — Foreign key → certificate.certificate_id — NOT NULL
  • description — VARCHAR(255)