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)