Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 3,326–3,350 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3326 | ticket_desk | 5 | NULL | 3326 | 2018-06-12 15:06:10 |
| 3327 | audio_guide_desk | NULL | 1 | 3327 | 2018-06-12 15:29:21 |
| 3328 | online | NULL | NULL | 3328 | 2018-06-12 15:42:28 |
| 3329 | app_store | NULL | NULL | 3329 | 2018-06-12 21:44:53 |
| 3330 | online | NULL | NULL | 3330 | 2018-06-13 08:46:10 |
| 3331 | online | NULL | NULL | 3331 | 2018-06-13 10:11:00 |
| 3332 | audio_guide_desk | NULL | 2 | 3332 | 2018-06-13 12:53:09 |
| 3333 | audio_guide_desk | NULL | 3 | 3333 | 2018-06-13 15:12:13 |
| 3334 | ticket_desk | 1 | NULL | 3334 | 2018-06-13 15:23:18 |
| 3335 | online | NULL | NULL | 3335 | 2018-06-14 17:30:09 |
| 3336 | app_store | NULL | NULL | 3336 | 2018-06-14 21:16:32 |
| 3337 | online | NULL | NULL | 3337 | 2018-06-15 09:31:46 |
| 3338 | online | NULL | NULL | 3338 | 2018-06-15 09:58:26 |
| 3339 | ticket_desk | 5 | NULL | 3339 | 2018-06-15 10:20:29 |
| 3340 | audio_guide_desk | NULL | 1 | 3340 | 2018-06-15 13:41:27 |
| 3341 | online | NULL | NULL | 3341 | 2018-06-15 18:00:59 |
| 3342 | online | NULL | NULL | 3342 | 2018-06-15 20:26:57 |
| 3343 | online | NULL | NULL | 3343 | 2018-06-16 23:17:12 |
| 3344 | online | NULL | NULL | 3344 | 2018-06-17 11:15:40 |
| 3345 | audio_guide_desk | NULL | 2 | 3345 | 2018-06-17 12:41:27 |
| 3346 | ticket_desk | 1 | NULL | 3346 | 2018-06-18 15:48:36 |
| 3347 | app_store | NULL | NULL | 3347 | 2018-06-19 04:49:36 |
| 3348 | ticket_desk | 1 | NULL | 3348 | 2018-06-19 10:17:09 |
| 3349 | online | NULL | NULL | 3349 | 2018-06-19 15:58:09 |
| 3350 | online | NULL | NULL | 3350 | 2018-06-19 21:56:07 |
Table definition
CREATE TABLE purchase_order (
order_id INTEGER PRIMARY KEY,
channel TEXT NOT NULL
CHECK (channel IN ('online', 'ticket_desk', 'audio_guide_desk', 'app_store')),
entrance_id INTEGER REFERENCES entrance (entrance_id),
wing_id INTEGER REFERENCES wing (wing_id),
payment_id INTEGER NOT NULL UNIQUE REFERENCES payment (payment_id),
ordered_at TEXT NOT NULL,
CHECK ((channel = 'ticket_desk') = (entrance_id IS NOT NULL)),
CHECK ((channel = 'audio_guide_desk') = (wing_id IS NOT NULL))
) STRICT;