| Profession_ID | Profession | Price | Experience_Level | Specialization |
|---|---|---|---|---|
| 1 | Photographer | 500.0 | Experienced | Wedding Photography |
| 2 | Photographer | 600.0 | Expert | Portrait Photography |
| 3 | Videographer | 500.0 | Beginner | Corporate Videos |
| 4 | Videographer | 700.0 | Intermediate | Documentary Filmmaking |
| 5 | Graphic Designer | 800.0 | Advanced | Digital Art |
| ID | Name |
|---|---|
| 1 | ABC Studio |
| 2 | XYZ Agency |
| 3 | PQR Production House |
| 4 | LMN Advertising |
| ID | Title | Description | Date | Status |
|---|---|---|---|---|
| 1 | Full Time Photographer | Looking for a full time photographer with experience in wedding photography. | 2023-05-01 00:00:00 | Open |
| 2 | Part Time Videographer | We need a part time videographer who can create corporate videos. | 2023-05-01 00:00:00 | Filled |
| 3 | Graphic Design Internship | Seeking an intern to assist our design team. | 2023-05-01 00:00:00 | Closed |
| 4 | Senior Video Editor | Need a senior video editor for documentary filmmaking projects. | 2023-05-01 00:00:00 | Open |
| 5 | Event Photographer | Hiring event photographers for various occasions. | 2023-05-01 00:00:00 | Open |
| Apply_ID | Job_ID | Applicant_Name | Resume_Path | Application_Date |
|---|---|---|---|---|
| (→ JobPosting.ID) | ||||
| 1 | 1 | John Doe | /path/to/resume.pdf | 2023-05-02 09:30:00 |
| 2 | 2 | Jane Smith | /path/to/another_resume.docx | 2023-05-02 09:35:00 |
| 3 | 3 | Michael Johnson | /path/to/portfolio.html | 2023-05-02 09:40:00 |
| 4 | 4 | Emily Brown | /path/to/portfolio_video.mp4 | 2023-05-02 09:45:00 |
| 5 | 5 | David Wilson | /path/to/event_photos.zip | 2023-05-02 09:50:00 |