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,326–5,350 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 5326 | online | NULL | NULL | 5326 | 2020-01-27 23:30:11 |
| 5327 | online | NULL | NULL | 5327 | 2020-01-28 09:42:10 |
| 5328 | ticket_desk | 2 | NULL | 5328 | 2020-01-29 10:25:58 |
| 5329 | audio_guide_desk | NULL | 1 | 5329 | 2020-01-29 11:19:00 |
| 5330 | audio_guide_desk | NULL | 1 | 5330 | 2020-01-29 11:32:18 |
| 5331 | app_store | NULL | NULL | 5331 | 2020-01-30 00:46:19 |
| 5332 | online | NULL | NULL | 5332 | 2020-01-30 16:22:23 |
| 5333 | online | NULL | NULL | 5333 | 2020-01-30 23:22:12 |
| 5334 | app_store | NULL | NULL | 5334 | 2020-01-31 02:03:56 |
| 5335 | app_store | NULL | NULL | 5335 | 2020-01-31 08:57:58 |
| 5336 | audio_guide_desk | NULL | 2 | 5336 | 2020-01-31 12:51:41 |
| 5337 | online | NULL | NULL | 5337 | 2020-01-31 14:23:01 |
| 5338 | ticket_desk | 1 | NULL | 5338 | 2020-02-01 10:57:37 |
| 5339 | online | NULL | NULL | 5339 | 2020-02-01 11:12:44 |
| 5340 | audio_guide_desk | NULL | 2 | 5340 | 2020-02-01 11:46:42 |
| 5341 | ticket_desk | 1 | NULL | 5341 | 2020-02-01 12:05:38 |
| 5342 | online | NULL | NULL | 5342 | 2020-02-01 19:51:25 |
| 5343 | online | NULL | NULL | 5343 | 2020-02-01 20:44:24 |
| 5344 | app_store | NULL | NULL | 5344 | 2020-02-02 01:05:58 |
| 5345 | app_store | NULL | NULL | 5345 | 2020-02-02 04:47:35 |
| 5346 | app_store | NULL | NULL | 5346 | 2020-02-02 05:36:27 |
| 5347 | online | NULL | NULL | 5347 | 2020-02-02 08:08:02 |
| 5348 | audio_guide_desk | NULL | 2 | 5348 | 2020-02-02 11:02:20 |
| 5349 | audio_guide_desk | NULL | 3 | 5349 | 2020-02-02 12:56:19 |
| 5350 | audio_guide_desk | NULL | 2 | 5350 | 2020-02-02 13:06:39 |
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;