TEST2
Tables (19)
alarm
- alarm_id — INT
- company_id — INT — NOT NULL
- receiver — VARCHAR(100)
- type — VARCHAR(50)
- content — VARCHAR(255)
- send_date — DATETIME
applicant_info
- applicant_id — INT
- name — VARCHAR(50)
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- birth_date — DATE
- phone — VARCHAR(20)
- address — VARCHAR(200)
applicant_tracking
- tracking_id — INT
- job_post_id — INT — NOT NULL
- applicant_id — INT — NOT NULL
- apply_date — DATE
- status — VARCHAR(50)
applied_companies
- applied_id — INT
- applicant_id — INT — NOT NULL
- job_post_id — INT — NOT NULL
- apply_date — DATE
- status — VARCHAR(50)
career
- career_id — INT
- applicant_id — INT — NOT NULL
- company — VARCHAR(100)
- position — VARCHAR(50)
- start_date — DATE
- end_date — DATE
- task — VARCHAR(100)
com_info
- company_id — INT
- biz_no — VARCHAR(20) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
com_prof
- company_id — INT
- logo — VARCHAR(255)
- employee_count — INT
- sales — BIGINT
- category — VARCHAR(100)
- address — VARCHAR(200)
- ceo_name — VARCHAR(50)
com_user_authority
- authority_id — INT
- company_id — INT — NOT NULL
- user_id — INT — NOT NULL
- role — VARCHAR(30)
education
- edu_id — INT
- applicant_id — INT — NOT NULL
- school — VARCHAR(100)
- major — VARCHAR(50)
- start_year — INT
- end_year — INT
hr_managers
- manager_id — INT
- company_id — INT — NOT NULL
- name — VARCHAR(50)
- email — VARCHAR(100)
- role — VARCHAR(50)
job_posting
- job_post_id — INT
- company_id — INT — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- start_date — DATE
- end_date — DATE
- salary — INT
job_posting_skill
- skill_id — INT
- job_post_id — INT — NOT NULL
- skill_name — VARCHAR(50)
manage_users
- user_id — INT
- type — VARCHAR(30)
- email — VARCHAR(100)
- name — VARCHAR(50)
menu
- menu_id — INT
- menu_name — VARCHAR(50)
- url — VARCHAR(200)
- role — VARCHAR(30)
message
- msg_id — INT
- company_id — INT — NOT NULL
- applicant_id — INT — NOT NULL
- content — TEXT
- send_date — DATETIME
payment
- payment_id — INT
- company_id — INT — NOT NULL
- payment_date — DATE
- amount — INT
- method — VARCHAR(50)
payment_sales
- sales_id — INT
- company_id — INT — NOT NULL
- amount — INT
- date — DATE
resume_tracking
- resume_id — INT
- applicant_id — INT — NOT NULL
- file_name — VARCHAR(255)
- upload_date — DATE
skill
- skill_id — INT
- career_id — INT — NOT NULL
- skill_name — VARCHAR(50)