## EventTypes

Id | TypeName
--- | ---
1 | Conference
2 | Wedding Reception
3 | Corporate Party
4 | Gala Dinner
5 | Cocktail Party

## Venues

Id | Name | SeatingCapacity
--- | --- | ---
1 | Grand Hotel | 800
2 | Plaza Inn | 600
3 | Central Conference Center | 1000
4 | Oceanview Resort | 700
5 | City Hall | 200

## Ballrooms

Id | VenueId | RoomNumber
--- | --- | ---
| (→ Venues.Id) |
1 | 1 | Ballroom A
2 | 2 | Ballroom B
3 | 3 | Ballroom C
4 | 4 | Ballroom D
5 | 5 | Ballroom E

## GreenRooms

Id | VenueId | RoomNumber
--- | --- | ---
| (→ Venues.Id) |
1 | 1 | Green Room A
2 | 2 | Green Room B
3 | 3 | Green Room C
4 | 4 | Green Room D
5 | 5 | Green Room E

## Events

Id | TypeId | StartDate | EndDate | VenueId
--- | --- | --- | --- | ---
| (→ EventTypes.Id) |  |  | (→ Venues.Id)
1 | 1 | 2022-09-01 | 2022-09-02 | 1
2 | 2 | 2022-09-15 | 2022-09-16 | 2
3 | 3 | 2022-10-01 | 2022-10-02 | 3
4 | 4 | 2022-10-15 | 2022-10-16 | 4
5 | 5 | 2022-11-01 | 2022-11-02 | 5