Records
Every table, every row
The demo database behind the site, read on the server straight from the bundled SQLite file. It covers 1 March 2015 to 29 February 2020 and every record in it is synthetic, generated from a fixed seed. Open a table to search it, page through it or download it as CSV.
- tables
- 19
- views
- 2
- rows
- 66,219
- SQLite file
- 3.3 MB
Reference data
Fixed lists from the brief: entrances, wings, languages, products, and the banks that issue cards.
- entrance5 rowsThe five entrances, spelled correctly.2020: Entrance.Gate Name (ENUM)
- wing3 rowsThe three wings.2020: Wings.Wings Name (ENUM), Hired Audio Guide wing ENUMs
- language13 rowsThe 13 audio-guide languages with ISO codes.2020: Hired Audio Guide.Language Setting
- product4 rowsWhat the museum sells, priced in euro cents.2020: Product
- financial_institution35 rowsCard-issuing banks with their short names and countries.2020: EFTPOS.Financial Institution Name
Payments
One payment row each, with exactly one card or cash subtype.
Orders and tickets
Sales by channel, what was in them, and the tickets they produced.
- purchase_order5,412 rowsOne sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.2020: Invoices
- order_line5,412 rowsProducts and quantities in an order, with the price charged.2020: Invoices
- ticket9,842 rowsEach admission ticket and its unique barcode.2020: Ticket
Admission and movement
Every scan at the five entrances and the three wings.
Audio guides
The device register and every hire.
Special exhibitions
Hall Napoleon exhibitions, their dated slots, bookings and admissions.
- exhibition12 rowsHall Napoleon exhibitions and their places per slot.2020: Special Exhibition
- exhibition_slot443 rowsA dated 15-minute slot of one exhibition.2020: Time Slot
- exhibition_booking2,015 rowsA ticket's place in a slot; a trigger stops overbooking.2020: Exhibition Booking, Booking Ticket
- hall_napoleon_scan1,775 rowsAdmission at the Hall Napoleon door, at most one per booking.2020: Hall Napoleon, Actual Number of Visitor
Views
Derived from the tables when queried; nothing is stored twice.