Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 351–375 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 351 | app_store | NULL | NULL | 351 | 2015-06-27 04:46:07 |
| 352 | online | NULL | NULL | 352 | 2015-06-27 08:10:14 |
| 353 | ticket_desk | 5 | NULL | 353 | 2015-06-27 11:26:09 |
| 354 | audio_guide_desk | NULL | 2 | 354 | 2015-06-27 11:51:27 |
| 355 | ticket_desk | 5 | NULL | 355 | 2015-06-27 12:12:16 |
| 356 | app_store | NULL | NULL | 356 | 2015-06-27 19:47:51 |
| 357 | ticket_desk | 4 | NULL | 357 | 2015-06-28 10:26:42 |
| 358 | ticket_desk | 3 | NULL | 358 | 2015-06-28 11:14:04 |
| 359 | online | NULL | NULL | 359 | 2015-06-28 12:02:49 |
| 360 | ticket_desk | 1 | NULL | 360 | 2015-06-28 13:02:40 |
| 361 | ticket_desk | 2 | NULL | 361 | 2015-07-01 08:37:01 |
| 362 | ticket_desk | 1 | NULL | 362 | 2015-07-01 10:32:06 |
| 363 | online | NULL | NULL | 363 | 2015-07-02 07:00:30 |
| 364 | ticket_desk | 1 | NULL | 364 | 2015-07-02 10:40:36 |
| 365 | ticket_desk | 3 | NULL | 365 | 2015-07-02 11:13:12 |
| 366 | online | NULL | NULL | 366 | 2015-07-02 11:30:35 |
| 367 | ticket_desk | 1 | NULL | 367 | 2015-07-03 10:38:40 |
| 368 | audio_guide_desk | NULL | 2 | 368 | 2015-07-03 11:08:00 |
| 369 | app_store | NULL | NULL | 369 | 2015-07-03 13:57:15 |
| 370 | ticket_desk | 4 | NULL | 370 | 2015-07-03 14:01:50 |
| 371 | online | NULL | NULL | 371 | 2015-07-03 14:06:15 |
| 372 | online | NULL | NULL | 372 | 2015-07-03 21:25:37 |
| 373 | ticket_desk | 1 | NULL | 373 | 2015-07-04 09:22:32 |
| 374 | ticket_desk | 1 | NULL | 374 | 2015-07-05 09:18:49 |
| 375 | ticket_desk | 3 | NULL | 375 | 2015-07-05 10:10:35 |
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;