ID | FirstName | LastName | PhoneNumber | EmailAddress |
---|---|---|---|---|
1 | John | Doe | +1234567890 | john@example.com |
2 | Jane | Smith | +0987654321 | jane@example.com |
3 | Alice | Brown | +1112223334 | alice@example.com |
4 | Bob | White | +2223334445 | bob@example.com |
5 | Carol | Black | +3334445556 | carol@example.com |
TypeID | Name |
---|---|
1 | Wedding |
2 | Corporate Event |
3 | Conference |
4 | Party |
5 | Exhibition |
EventID | Date | StartTime | EndTime | TypeID |
---|---|---|---|---|
(→ EventType.TypeID) | ||||
1 | 2022-01-01 18:00:00 | 19:00:00 | 22:00:00 | 1 |
2 | 2022-02-01 18:00:00 | 19:00:00 | 22:00:00 | 2 |
3 | 2022-03-01 18:00:00 | 19:00:00 | 22:00:00 | 3 |
4 | 2022-04-01 18:00:00 | 19:00:00 | 22:00:00 | 4 |
5 | 2022-05-01 18:00:00 | 19:00:00 | 22:00:00 | 5 |
VenueID | Address | Capacity | SpecialOccasionLocation | Location | Description |
---|---|---|---|---|---|
1 | 1 High Street | 500 | Wedding Venue | High Street | A beautiful wedding venue with a capacity of 500 guests. |
2 | 2 Low Street | 300 | Wedding Venue | Low Street | An intimate wedding venue with a capacity of 300 guests. |
3 | 3 High Street | 400 | Corporate Event Space | High Street | A modern corporate event space with a capacity of 400 guests. |
4 | 4 Low Street | 200 | Corporate Event Space | Low Street | A classic corporate event space with a capacity of 200 guests. |
5 | 5 Main Street | 550 | Multi-purpose Hall | Main Street | A versatile multi-purpose hall with a capacity of 550 guests. |
BookingID | GuestID | EventID | VenueID | NumberOfGuests |
---|---|---|---|---|
(→ Guest.ID) | (→ Event.EventID) | (→ Venue.VenueID) | ||
1 | 1 | 1 | 1 | 200 |
2 | 2 | 2 | 2 | 150 |
3 | 3 | 3 | 3 | 300 |
4 | 4 | 4 | 4 | 100 |
5 | 5 | 5 | 5 | 500 |