Companies
id | name | address | phoneNumber |
1 | Events Unlimited | 123 Main St | 555-0000 |
2 | Celebrations Inc. | 456 Elm St | 555-1111 |
3 | Party Planning Plus | 789 Oak St | 555-2222 |
4 | Festive Solutions | 101 Pine St | 555-3333 |
5 | Weddings by Design | 202 Cedar St | 555-4444 |
Events
eventId | companyId | industry | date | location |
| (→ Companies.id) | | | |
1 | 1 | Event Planner | 2023-01-15 12:00:00 | Downtown Hall |
2 | 2 | Event Planner | 2023-02-10 18:00:00 | City Center Ballroom |
3 | 1 | Wedding Coordinator | 2023-03-25 16:00:00 | Garden Wedding Venue |
4 | 2 | Wedding Coordinator | 2023-04-08 14:00:00 | Beachside Resort |
5 | 3 | Conference Organizer | 2023-05-01 09:00:00 | Convention Center |
Employees
employeeId | firstName | lastName | position | hireDate |
1 | John | Smith | Event Manager | 2022-01-15 |
2 | Jane | Doe | Assistant Event Planner | 2022-02-10 |
3 | Michael | Brown | Event Coordinator | 2022-03-25 |
4 | Alice | Green | Wedding Specialist | 2022-04-08 |
5 | David | Black | Graphic Designer | 2022-05-01 |
EventEmployee
eventId | employeeId | role |
(→ Events.eventId) | (→ Employees.employeeId) | |
1 | 1 | Team Lead |
1 | 2 | Decorator |
2 | 3 | Stage Manager |
3 | 4 | Floral Arranger |
4 | 5 | Photographer |