아인잡
테이블 (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)