아인잡

테이블 (19)

ALARM

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • type — ENUM('email', 'kakaotalk')
  • message — TEXT
  • sent_at — TIMESTAMP

APPLICANT_INFO

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • birth_date — DATE
  • contact — VARCHAR(50)

APPLICANT_TRACKING

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • job_posting_id — INT — 외래 키 → JOB_POSTING.id — NOT NULL
  • status — ENUM('applied', 'interview', 'hired', 'rejected') — NOT NULL

APPLIED_COMPANIES

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • applied_at — TIMESTAMP

CAREER

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • company_name — VARCHAR(255)
  • position — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • responsibilities — TEXT

COM_INFO

  • id — INT — 기본 키 — NOT NULL
  • business_registration_number — VARCHAR(50) — NOT NULL

COM_PROF

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • logo — VARCHAR(255)
  • employee_count — INT
  • annual_revenue — DECIMAL(15,2)
  • business_items — TEXT
  • address — VARCHAR(255)
  • representative_name — VARCHAR(255)

COM_USER_AUTHORITY

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • user_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • role — VARCHAR(50)

EDUCATION

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • school_name — VARCHAR(255)
  • major — VARCHAR(100)
  • start_year — INT
  • graduation_year — INT

HR_MANAGERS

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • manager_name — VARCHAR(255)
  • role — VARCHAR(50)

JOB_POSTING

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

JOB_POSTING_SKILL

  • id — INT — 기본 키 — NOT NULL
  • job_posting_id — INT — 외래 키 → JOB_POSTING.id — NOT NULL
  • skill_name — VARCHAR(100)

MANAGE_USERS

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • role — VARCHAR(50)
  • status — ENUM('active', 'inactive', 'banned')

MENU

  • id — INT — 기본 키 — NOT NULL
  • menu_name — VARCHAR(255)
  • url — VARCHAR(255)

MESSAGE

  • id — INT — 기본 키 — NOT NULL
  • sender_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • receiver_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • message_text — TEXT
  • sent_at — TIMESTAMP

PAYMENT

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • payment_method — VARCHAR(50)
  • card_number — VARCHAR(20)
  • security_code — VARCHAR(10)
  • refund_policy — TEXT

PAYMENT_SALES

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — NOT NULL
  • total_sales — DECIMAL(15,2)
  • total_refunds — DECIMAL(15,2)
  • report_date — DATE

RESUME_TRACKING

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • resume_text — TEXT

SKILL

  • id — INT — 기본 키 — NOT NULL
  • career_id — INT — 외래 키 → CAREER.id — NOT NULL
  • skill_name — VARCHAR(100)