Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 501–525 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 501 | app_store | NULL | NULL | 501 | 2015-08-07 20:16:55 |
| 502 | online | NULL | NULL | 502 | 2015-08-08 08:30:27 |
| 503 | app_store | NULL | NULL | 503 | 2015-08-08 17:00:19 |
| 504 | ticket_desk | 1 | NULL | 504 | 2015-08-09 13:54:16 |
| 505 | online | NULL | NULL | 505 | 2015-08-09 22:08:59 |
| 506 | ticket_desk | 1 | NULL | 506 | 2015-08-10 09:24:29 |
| 507 | audio_guide_desk | NULL | 2 | 507 | 2015-08-10 09:50:25 |
| 508 | ticket_desk | 1 | NULL | 508 | 2015-08-10 12:25:20 |
| 509 | audio_guide_desk | NULL | 2 | 509 | 2015-08-10 13:03:06 |
| 510 | online | NULL | NULL | 510 | 2015-08-11 10:12:36 |
| 511 | ticket_desk | 3 | NULL | 511 | 2015-08-11 13:49:11 |
| 512 | online | NULL | NULL | 512 | 2015-08-11 19:57:50 |
| 513 | online | NULL | NULL | 513 | 2015-08-11 22:29:19 |
| 514 | app_store | NULL | NULL | 514 | 2015-08-12 05:24:55 |
| 515 | ticket_desk | 3 | NULL | 515 | 2015-08-12 09:59:38 |
| 516 | online | NULL | NULL | 516 | 2015-08-12 12:25:31 |
| 517 | app_store | NULL | NULL | 517 | 2015-08-12 14:58:24 |
| 518 | ticket_desk | 3 | NULL | 518 | 2015-08-12 15:39:12 |
| 519 | audio_guide_desk | NULL | 2 | 519 | 2015-08-12 16:05:27 |
| 520 | app_store | NULL | NULL | 520 | 2015-08-13 04:15:22 |
| 521 | online | NULL | NULL | 521 | 2015-08-13 08:32:44 |
| 522 | app_store | NULL | NULL | 522 | 2015-08-13 08:47:42 |
| 523 | online | NULL | NULL | 523 | 2015-08-13 09:22:07 |
| 524 | online | NULL | NULL | 524 | 2015-08-13 11:07:10 |
| 525 | app_store | NULL | NULL | 525 | 2015-08-13 15:52:58 |
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;