Table
product
What the museum sells, priced in euro cents.
Replaces in 2020: Product
Rows 1–4 of 4
| product_idINTEGER | codeTEXT | nameTEXT | price_centsINTEGER |
|---|---|---|---|
| 1 | TICKET_ONLINE | Museum ticket (online) | 1500 |
| 2 | TICKET_ON_SITE | Museum ticket (on site) | 1700 |
| 3 | AUDIO_GUIDE | Audio guide hire | 800 |
| 4 | APP | Official Louvre app | 400 |
Table definition
CREATE TABLE product (
product_id INTEGER PRIMARY KEY,
code TEXT NOT NULL UNIQUE
CHECK (code IN ('TICKET_ONLINE', 'TICKET_ON_SITE', 'AUDIO_GUIDE', 'APP')),
name TEXT NOT NULL,
price_cents INTEGER NOT NULL CHECK (price_cents >= 0)
) STRICT;