## Office

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

## Department

ID | Name
--- | ---
1 | Engineering
2 | Marketing
3 | Human Resources
4 | Finance
5 | IT

## Internship_Position

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

## Employee

ID | First_Name | Last_Name | Email | 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

## Job_Posting

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

## Applicant

ID | Full_name | Email | 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