id | name | location |
---|---|---|
1 | The Met | New York |
2 | British Museum | London |
id | museum_id | name |
---|---|---|
(→ Museum.id) | ||
1 | 1 | Modern Art Wing |
2 | 2 | Ancient Civilizations Hall |
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 |
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. |
id | name | phone_number | membership | |
---|---|---|---|---|
1 | John Doe | johndoe@example.com | +1234567890 | 0 |
2 | Jane Smith | janesmith@example.com | +0987654321 | 0 |
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 |