AppliQuest is a job application tracker web app that helps job seekers organize and manage their job applications in one place.
Title: AppliQuest URL: https://appliquest.onrender.com
The primary goal of the Job Application Tracker website is to provide a centralized location for job seekers to manage all aspects of their job search. The website will allow job seekers to keep track of their job applications, organize their job search, and keep all their job search details in one place.
The website will be designed for job seekers of all ages and backgrounds who are actively looking for employment. The primary demographic of users will be individuals who are seeking full-time or part-time employment opportunities, including recent graduates, professionals, and individuals who are looking to change careers.
The website will use job application data such as the company name, job title, application date, status updates, contact details, notes, tasks, documents, job descriptions, salaries, locations, and company data. The data will be collected from user input, and it will be securely stored in a database.
The database schema will consist of tables for users, jobs, companies, job descriptions, and other relevant data. The relationships between the tables will be established to ensure data integrity and efficient querying.
User | |
---|---|
id | unique identifier for each user |
first_name | first name of the user |
last_name | last name of user |
email address of the user | |
password | hashed password for user authentication |
linkedin_url | url to user's linkedin profile |
user_location | the location of user |
Job | |
---|---|
id | unique identifier for each job application |
user_id | foreign key to the users table |
company_id | foreign key to the companies table |
job_title | title of the job |
post_url | link to the job posting |
application _date | date when the application was submitted |
status | status of the application (e.g. applied, interview scheduled, rejected) |
notes | any notes or comments about the application |
job_location | location of the job |
job_description | full job description for the job |
created_at | date the job created by user |
modified_at | date the job modified by user |
|Company|-| |id| unique identifier for each job application| |company_name| name of the company| |company_location| company location| |company_url| link to the company websit| |company_about| about the company|
Contact | |
---|---|
id | unique identifier for each contact |
user_id | foreign key to the users table |
company_id | foreign key to the companies table |
first_name | first name of the contact person at the company |
last_name | last name of the contact person at the company |
email address of the contact person | |
phone | phone number of the contact person |
notes | any notes or comments about the contact |
Document | |
---|---|
id | unique identifier for each document |
user_id | foreign key to the users table |
job_id | foreign key to the jobs table |
originial_filename | name of the file |
category | type of the file (e.g. resume, cover letter, transcript) |
created_at | date the job created by user |
modified_at | date the job modified by user |
Task | |
---|---|
id | unique identifier for each task |
user_id | foreign key to the users table |
job_id | foreign key to the jobs table |
task_title | title of the task |
task | task description |
completed | Wheter the task is completed or not |
created_at | date the job created by user |
due_date | due date for the task |
notes | any notes or comments about the task |
One potential issue that may arise with the API is the availability and accuracy of the job data. The website will use job board APIs and web scraping techniques to gather job data, which may not always be up-to-date or complete.
Sensitive information such as user login credentials, personal information, and job application details will be securely stored and encrypted.
The website will include features such as user registration and login, job application tracking, job search organization, document storage, and notes and task management.
The user flow will begin with the user registration and login process. Once logged in, the user will be directed to their personalized dashboard, where they can add and manage their job applications, organize their job search, and track their progress. The website will also provide additional resources and job search tips to help users navigate the job search process.
Registration: Users can sign up for an account by providing their basic details. Login: Users can log in using their credentials to access their personalized dashboard. Jobboard: Upon logging in, users are directed to their jobboard, where they can view a summary of their job application. Users can add new job applications, update application status, and view details of each application, including job title, company, and application history. Document Management: Users can upload, manage, and access their job-related documents, such as resumes and cover letters. Task Management: Users can create tasks, set due dates, and track the progress of each task. Analytics: Users can access analytics and reports to gain insights into their job search progress and performance.
Users will be able to track the status of their job applications, including the date of application, application status, interview dates, and other relevant details. They will also be able to set reminders and receive notifications for upcoming interview dates.
Users will be able to upload and store resumes, cover letters, and other documents related to their job applications. This will allow them to quickly access these documents when needed, such as when updating an application or preparing for an interview.
Users will be able to create and manage tasks related to their job search, such as networking events to attend, job fairs to visit, and follow-up calls to make.
Users could view analytics and reports on their job search progress, including the number of applications submitted, the number of interviews secured, and the success rate of their job search.
The website will allow users to research companies they are interested in, including details such as the company's mission, culture, and reviews from current and former employees.
The website could integrate with job search engines like Indeed or Glassdoor to provide users with even more job search opportunities and data.
A matching algorithm could be developed to match job seekers with job openings that fit their skills and qualifications.
The following technologies were used to develop AppliQuest:
Front-end: HTML, CSS, JavaScript, Bootstrap Back-end: Python, Flask Database: PostgreSQL Deployment: Render, Git