## Museum

id | name | location
--- | --- | ---
1 | The Met | New York
2 | British Museum | London

## Gallery

id | museum_id | name
--- | --- | ---
| (→ Museum.id) |
1 | 1 | Modern Art Wing
2 | 2 | Ancient Civilizations Hall

## Event

id | gallery_id | event_type | date | description | capacity
--- | --- | --- | --- | --- | ---
| (→ Gallery.id) |  |  |  |
1 | 1 | Lecture | 2023-01-01 19:00:00 | A lecture on modern art movements. | 100
2 | 1 | Art Workshop | 2023-01-02 14:00:00 | A hands-on workshop for aspiring artists. | 20

## Exhibit

id | gallery_id | title | artist | year | description
--- | --- | --- | --- | --- | ---
| (→ Gallery.id) |  |  |  |
1 | 1 | Starry Night | Vincent van Gogh | 1889 | A masterpiece depicting a view over the town of Saint-Rémy-de-Provence.
2 | 1 | Guernica | Pablo Picasso | 1937 | A powerful anti-war painting created after the bombing of Guernica during the Spanish Civil War.

## Visitor

id | name | email | phone_number | membership
--- | --- | --- | --- | ---
1 | John Doe | johndoe@example.com | +1234567890 | 0
2 | Jane Smith | janesmith@example.com | +0987654321 | 0

## Attendance

id | visitor_id | event_id | entry_time | exit_time
--- | --- | --- | --- | ---
| (→ Visitor.id) | (→ Event.id) |  |
1 | 1 | 1 | 2023-01-01 18:55:00 | 2023-01-01 21:15:00
2 | 2 | 2 | 2023-01-02 13:55:00 | 2023-01-02 16:15:00