Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 5,351–5,375 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5351 | ticket_desk | 3 | NULL | 5351 | 2020-02-02 16:06:26 |
| 5352 | audio_guide_desk | NULL | 3 | 5352 | 2020-02-02 16:41:01 |
| 5353 | audio_guide_desk | NULL | 3 | 5353 | 2020-02-02 16:45:44 |
| 5354 | app_store | NULL | NULL | 5354 | 2020-02-03 11:30:09 |
| 5355 | ticket_desk | 2 | NULL | 5355 | 2020-02-04 08:46:56 |
| 5356 | audio_guide_desk | NULL | 2 | 5356 | 2020-02-04 09:18:06 |
| 5357 | audio_guide_desk | NULL | 2 | 5357 | 2020-02-04 09:18:09 |
| 5358 | online | NULL | NULL | 5358 | 2020-02-04 22:38:16 |
| 5359 | online | NULL | NULL | 5359 | 2020-02-05 13:23:38 |
| 5360 | online | NULL | NULL | 5360 | 2020-02-05 21:15:29 |
| 5361 | ticket_desk | 5 | NULL | 5361 | 2020-02-06 08:28:02 |
| 5362 | online | NULL | NULL | 5362 | 2020-02-06 09:51:49 |
| 5363 | app_store | NULL | NULL | 5363 | 2020-02-06 13:28:51 |
| 5364 | online | NULL | NULL | 5364 | 2020-02-06 22:06:26 |
| 5365 | app_store | NULL | NULL | 5365 | 2020-02-06 23:05:56 |
| 5366 | audio_guide_desk | NULL | 1 | 5366 | 2020-02-07 13:36:43 |
| 5367 | online | NULL | NULL | 5367 | 2020-02-08 08:00:50 |
| 5368 | ticket_desk | 4 | NULL | 5368 | 2020-02-08 09:51:42 |
| 5369 | online | NULL | NULL | 5369 | 2020-02-08 15:36:01 |
| 5370 | online | NULL | NULL | 5370 | 2020-02-09 07:43:17 |
| 5371 | online | NULL | NULL | 5371 | 2020-02-09 08:39:28 |
| 5372 | ticket_desk | 1 | NULL | 5372 | 2020-02-09 14:11:29 |
| 5373 | online | NULL | NULL | 5373 | 2020-02-09 14:33:41 |
| 5374 | app_store | NULL | NULL | 5374 | 2020-02-10 03:57:39 |
| 5375 | online | NULL | NULL | 5375 | 2020-02-10 08:29:10 |
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;