hr

Tables (18)

admin_log

  • log_id — BIGINT — Primary key — NOT NULL
  • action — VARCHAR(255)
  • created_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

alarm

  • notification_id — BIGINT — Primary key — NOT NULL
  • message — TEXT
  • type — VARCHAR(50)
  • is_read — BOOLEAN
  • created_at — DATETIME
  • email_noti — BOOLEAN
  • kakao_noti — BOOLEAN
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

app_career

  • career_id — Primary key — NOT NULL
  • company_name — VARCHAR(255)
  • position — VARCHAR(100)
  • start_date — DATE
  • end_date — DATE
  • responsibilities — TEXT
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL

app_education

  • edu_id — BIGINT — Primary key — NOT NULL
  • school_name — VARCHAR(255)
  • degree — VARCHAR(100)
  • major — VARCHAR(100)
  • admission_year — YEAR
  • graduation_year — YEAR
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL

application

  • application_id — BIGINT — Primary key — NOT NULL
  • status — VARCHAR(30)
  • created_at — DATETIME
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
  • position_id — BIGINT — Foreign key → job_position.position_id — NOT NULL

company

  • company_id — BIGINT — Primary key — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • introduction — TEXT
  • business_number — VARCHAR(50)
  • office_phone — VARCHAR(50)
  • office_address — VARCHAR(255)
  • employee_count — INT
  • logo_url — VARCHAR(255)
  • annual_sales — BIGINT
  • ceo_name — VARCHAR(100)
  • homepage_url — VARCHAR(255)
  • updated_at — DATETIME
  • created_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

company_welfare

  • welfare_id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • benefit_type — VARCHAR(50)
  • benefit_name — VARCHAR(100)
  • is_highlighted — BOOLEAN
  • display_order — INT
  • created_at — DATETIME
  • updated_at — DATETIME

inquiry

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • content — TEXT
  • status — VARCHAR(30)
  • created_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

interview

  • interview_id — BIGINT — Primary key — NOT NULL
  • schedule — DATETIME
  • result — VARCHAR(50)
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • application_id — BIGINT — Foreign key → application.application_id — NOT NULL

job_position

  • position_id — BIGINT — Primary key — NOT NULL
  • position_name — VARCHAR(100) — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL

job_posting

  • job_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • requirements — TEXT
  • deadline — DATE
  • location — VARCHAR(255)
  • salary_range — VARCHAR(100)
  • created_at — DATETIME
  • career_min_year — INT DEFAULT 0
  • career_max_year — INT DEFAULT 0
  • education_level — ENUM('고졸','학사','석사','박사')
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL

job_posting_skill_map

  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL

payment

  • payment_id — BIGINT — Primary key — NOT NULL
  • amount — DECIMAL(12,2) — NOT NULL
  • service_type — VARCHAR(100)
  • paid_at — DATETIME
  • payment_method — VARCHAR(50)
  • card_registered — BOOLEAN
  • security_level — ENUM('BASIC','HIGH')
  • registered_card_info — TEXT
  • refund — VARCHAR(50)
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL

resume

  • resume_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • experience — TEXT
  • self_intro — TEXT
  • birth_date — DATE
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

role

  • role_id — BIGINT — Primary key — NOT NULL
  • role_name — VARCHAR(50) — NOT NULL

skill

  • skill_id — BIGINT — Primary key — NOT NULL
  • skill_name — VARCHAR(100)

user_role

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role_id — BIGINT — Foreign key → role.role_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • user_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(50)
  • address — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME