ID | Office_Address | City |
---|---|---|
1 | 123 Main St | New York |
2 | 456 Elm St | Los Angeles |
3 | 789 Oak St | Chicago |
4 | 012 Pine St | Miami |
5 | 321 Fir St | Boston |
ID | Name |
---|---|
1 | Engineering |
2 | Marketing |
3 | Human Resources |
4 | Finance |
5 | IT |
ID | Position_Title | Description | Duration |
---|---|---|---|
1 | Software Engineering Intern | Help develop software applications. | 12 |
2 | Graphic Design Intern | Create visual designs for marketing materials. | 12 |
3 | HR Intern | Assist with recruitment and onboarding processes. | 12 |
4 | Financial Analyst Intern | Analyze financial data and support decision-making. | 12 |
5 | Network Engineer Intern | Support network infrastructure and troubleshoot issues. | 12 |
ID | First_Name | Last_Name | Phone_Number | Hire_Date | |
---|---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1 234-567-8901 | 2024-02-19 12:27:01 |
2 | Jane | Smith | jane.smith@example.com | +1 345-678-9012 | 2024-02-19 12:27:01 |
3 | Alice | Johnson | alice.johnson@example.com | +1 456-789-0123 | 2024-02-19 12:27:01 |
4 | Bob | Williams | bob.williams@example.com | +1 567-890-1234 | 2024-02-19 12:27:01 |
5 | Emma | Brown | emma.brown@example.com | +1 678-901-2345 | 2024-02-19 12:27:01 |
ID | Title | Description | Required_Skills | Salary | Application_Deadline | Office_ID | Departments_ID | Internships_ID |
---|---|---|---|---|---|---|---|---|
(→ Office.ID) | (→ Department.ID) | (→ Internship_Position.ID) | ||||||
1 | Software Developer | Design, code, and maintain software systems. | JavaScript, HTML, CSS | 80000.0 | 2023-05-31 23:59:59 | 1 | 1 | None |
2 | Digital Marketing Specialist | Plan and execute digital marketing campaigns. | SEO, SEM, Social Media | 60000.0 | 2023-05-31 23:59:59 | 2 | 2 | None |
3 | Recruiter | Source, screen, and interview candidates. | Applicant Tracking Systems | 50000.0 | 2023-05-31 23:59:59 | 3 | 3 | None |
4 | Accountant | Prepare financial reports and analyze data. | Excel, QuickBooks | 65000.0 | 2023-05-31 23:59:59 | 4 | 4 | None |
5 | System Administrator | Install, configure, and maintain computer systems. | Linux, Windows Server | 70000.0 | 2023-05-31 23:59:59 | 5 | 5 | None |
ID | Full_name | Phone_number | Resume_url | Date_applied | Job_posting_id | |
---|---|---|---|---|---|---|
(→ Job_Posting.ID) | ||||||
1 | John Doe | johndoe@email.com | +1 234-567-8901 | https://www.example.com/resume-john-doe | 2024-02-19 12:27:01 | 1 |
2 | Jane Smith | janesmith@email.com | +1 345-678-9012 | https://www.example.com/resume-jane-smith | 2024-02-19 12:27:01 | 2 |
3 | Alice Johnson | alicejohnson@email.com | +1 456-789-0123 | https://www.example.com/resume-alice-johnson | 2024-02-19 12:27:01 | 3 |
4 | Bob Williams | bobwilliams@email.com | +1 567-890-1234 | https://www.example.com/resume-bob-williams | 2024-02-19 12:27:01 | 4 |
5 | Emma Brown | emmabrown@email.com | +1 678-901-2345 | https://www.example.com/resume-emma-brown | 2024-02-19 12:27:01 | 5 |