아인잡_v2

테이블 (20)

ALARM

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

APPLICANT_INFO

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL

APPLICANT_TRACKING

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • job_posting_id — INT — 외래 키 → JOB_POSTING.id — NOT NULL
  • applied_date — TIMESTAMP
  • status — ENUM('First Interview', 'Second Interview') — NOT NULL

APPLIED_COMPANIES

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

CAREER

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

COM_INFO

  • id — INT — 기본 키 — NOT NULL
  • BIN_No — VARCHAR(50) — NOT NULL
  • service_type — ENUM('Advance', 'Basic', 'Standard') — NOT NULL
  • status — ENUM('Active', 'Dormant', 'Terminated') — NOT NULL

COM_PROF

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • CEO_Name — VARCHAR(255) — NOT NULL
  • employee_count — INT
  • annual_revenue — DECIMAL(15,2)
  • business_items — TEXT
  • city_address — VARCHAR(255) — NOT NULL
  • detail_address — VARCHAR(255) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL
  • financial_info — JSON
  • extra_info — JSON

COM_USER_AUTHORITY

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • role — ENUM('Admin', 'HR', 'User') — NOT NULL

EDUCATION

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • degree — VARCHAR(255) — NOT NULL
  • institution — VARCHAR(255) — NOT NULL
  • graduation_year — YEAR — NOT NULL

HR_MANAGERS

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • manager_name — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50)
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • status — ENUM('Active', 'Resigned', 'Deleted') — NOT NULL

JOB_POSTING

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — ENUM('Pre-Registration', 'In Progress', 'Paused', 'Expired') — NOT NULL

JOB_POSTING_SKILL

  • id — INT — 기본 키 — NOT NULL
  • job_posting_id — INT — 외래 키 → JOB_POSTING.id — NOT NULL
  • skill_id — INT — 외래 키 → SKILL_DATA.id — NOT NULL

MANAGE_USERS

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • city_address — VARCHAR(255) — NOT NULL
  • detail_address — VARCHAR(255) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL
  • role — VARCHAR(50)
  • status — ENUM('Active', 'Inactive', 'banned') — NOT NULL

MENU

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

MESSAGE

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

PAYMENT

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — 외래 키 → COM_INFO.id — NOT NULL
  • payment_time — TIMESTAMP
  • status — ENUM('Paid', 'Cancelled') — NOT NULL
  • card_number — VARCHAR(20)
  • security_code — VARCHAR(10)
  • refund_policy — TEXT

PAYMENT_SALES

  • id — INT — 기본 키 — NOT NULL
  • company_id — INT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • transaction_date — TIMESTAMP

RESUME_TRACKING

  • id — INT — 기본 키 — NOT NULL
  • applicant_id — INT — 외래 키 → APPLICANT_INFO.id — NOT NULL
  • resume_path — VARCHAR(255) — NOT NULL

SKILL

  • id — INT — 기본 키 — NOT NULL
  • skill_id — INT — 외래 키 → SKILL_DATA.id — NOT NULL
  • career_id — INT — 외래 키 → CAREER.id — NOT NULL

SKILL_DATA

  • id — INT — 기본 키 — NOT NULL
  • category — ENUM('Backend', 'Frontend', 'Client', 'Infrastructure', 'Other') — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • skill_name — VARCHAR(255) — NOT NULL