Create DB schema

[MurthyRebba]

• Create tables to be able to store, Role, Min Exp,Max Exp,Department, Company, City, Country
• Determine the right data types for each columns.
• Create any secondary tables as per requirement.
• Add appropriate primary and foreign keys.

[saipranav-sys]

I think we need 4 databases as mentioned below:

[saipranav-sys]

1. USER MANAGEMENT

Table name : User_role

user_role_id : int : pk user_role : job seeker , recruiter , admin

Table name : user_account

id : int : pk user_type_id : int : fk user_role_id email : varchar(25) username : varchar(25) password : varchar(25) contact_number : number(10)

[saipranav-sys]

2. COMPANY PROFILE :

Table name: category

id : int : pk cotegory_name : varchar(50)

Table name: Company

id: int : pk comany_name : varchar(50) profile_description : varchar(50) business_category : varchar(20) : fk company_website : varchar(500)

[saipranav-sys]

3. JOB SEEKER PROFILE :

Table name: applicants

experience_id : int : pk applicant_type : varchar

Table name: resume

resume_id : int : pk
resume : blob

[saipranav-sys]

4. Jobs_Management:

Table name: Job type

id : int : pk job_type : temporary or permanent : pk

Job description:

job_post_id : int : pk posted_by_id : int : fk Company table posted_date:date job title : varchar job duration : varchar job description : varchar skillset_required : varchar salary range : varchar

Job location:

id : int : pk steet_address : varchar city : varchar state : varchar country : varchar zip : varchar

Job activity:

job_post_id : int : pk,fk job description table

user_id : int : fk user_role table

application_date : date