아인잡_v3
테이블 (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
- required_years — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — ENUM('Pre-Registration', 'In Progress', 'Paused', 'Expired') — NOT NULL
JOB_POSTING_SKILL
- id — INT — 기본 키 — NOT NULL
- skill_id — INT — 외래 키 → SKILL_DATA.id — NOT NULL
- job_posting_id — INT — 외래 키 → JOB_POSTING.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
- applicant_id — INT — 외래 키 → APPLICANT_INFO.id — 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