과제 erd
테이블 (19)
ALARM
- alarm_id — INT
- company_id — INT — NOT NULL
- email_alarm — BOOLEAN — NOT NULL
- kakao_alarm — BOOLEAN — NOT NULL
APPLICANT_INFO
- applicant_id — INT
- name — VARCHAR(100) — NOT NULL
- dob — DATE — NOT NULL
- address — VARCHAR(255) — NOT NULL
- contact — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
APPLICANT_TRACKING
- tracking_id — INT
- job_id — INT — NOT NULL
- applicant_id — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
APPLIED_COMPANIES
- applied_id — INT
- applicant_id — INT — NOT NULL
- job_id — INT — NOT NULL
- applied_date — DATE — NOT NULL
CAREER
- career_id — INT
- applicant_id — INT — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- position — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- duties — TEXT — NOT NULL
COMP_INFO
- company_id — INT
- business_number — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- INDEX — (`business_number`)
COMP_PROF
- profile_id — INT
- company_id — INT — NOT NULL
- logo — VARCHAR(255) — NOT NULL
- staff_count — INT — NOT NULL
- sales — INT — NOT NULL
- business_item — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- ceo_name — VARCHAR(100) — NOT NULL
COM_USER_AUTHORITY
- authority_id — INT
- company_id — INT — NOT NULL
- manager_id — INT — NOT NULL
- role_type — VARCHAR(50) — NOT NULL
EDUCATION
- edu_id — INT
- applicant_id — INT — NOT NULL
- school_name — VARCHAR(100) — NOT NULL
- major — VARCHAR(100) — NOT NULL
- start_year — INT — NOT NULL
- end_year — INT — NOT NULL
HR_MANAGERS
- manager_id — INT
- company_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
JOB_POSTING
- job_id — INT
- company_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- deadline — DATE — NOT NULL
- job_description — TEXT — NOT NULL
JOB_POSTING_SKILL
- id — INT
- job_id — INT — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL
MANAGE_USERS
- user_id — INT
- type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
MENU
- menu_id — INT
- name — VARCHAR(100) — NOT NULL
- path — VARCHAR(255) — NOT NULL
MESSAGE
- message_id — INT
- sender_company_id — INT — NOT NULL
- receiver_applicant_id — INT — NOT NULL
- content — TEXT — NOT NULL
- timestamp — DATETIME — NOT NULL
PAYMENT
- payment_id — INT
- company_id — INT — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- card_info — VARCHAR(100) — NOT NULL
- refund_policy — TEXT — NOT NULL
PAYMENT_SALES
- sale_id — INT
- company_id — INT — NOT NULL
- amount — INT — NOT NULL
- payment_date — DATE — NOT NULL
RESUME_TRACKING
- resume_id — INT
- applicant_id — INT — NOT NULL
- resume_file — VARCHAR(255) — NOT NULL
- updated_at — DATETIME — NOT NULL
SKILL
- skill_id — INT
- career_id — INT — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL