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,551–3,575 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3551 | online | NULL | NULL | 3551 | 2018-08-10 10:13:53 |
| 3552 | online | NULL | NULL | 3552 | 2018-08-10 10:20:51 |
| 3553 | ticket_desk | 2 | NULL | 3553 | 2018-08-10 13:05:23 |
| 3554 | ticket_desk | 4 | NULL | 3554 | 2018-08-10 13:49:55 |
| 3555 | audio_guide_desk | NULL | 2 | 3555 | 2018-08-10 13:57:45 |
| 3556 | online | NULL | NULL | 3556 | 2018-08-10 17:56:04 |
| 3557 | online | NULL | NULL | 3557 | 2018-08-10 22:49:30 |
| 3558 | app_store | NULL | NULL | 3558 | 2018-08-11 02:19:28 |
| 3559 | app_store | NULL | NULL | 3559 | 2018-08-11 08:21:24 |
| 3560 | audio_guide_desk | NULL | 2 | 3560 | 2018-08-11 11:08:09 |
| 3561 | ticket_desk | 1 | NULL | 3561 | 2018-08-11 11:15:09 |
| 3562 | audio_guide_desk | NULL | 2 | 3562 | 2018-08-11 11:54:54 |
| 3563 | app_store | NULL | NULL | 3563 | 2018-08-11 16:25:26 |
| 3564 | online | NULL | NULL | 3564 | 2018-08-11 20:24:06 |
| 3565 | online | NULL | NULL | 3565 | 2018-08-11 21:37:28 |
| 3566 | ticket_desk | 1 | NULL | 3566 | 2018-08-12 09:57:31 |
| 3567 | audio_guide_desk | NULL | 1 | 3567 | 2018-08-12 13:55:11 |
| 3568 | audio_guide_desk | NULL | 2 | 3568 | 2018-08-12 15:19:57 |
| 3569 | audio_guide_desk | NULL | 2 | 3569 | 2018-08-12 15:45:10 |
| 3570 | online | NULL | NULL | 3570 | 2018-08-12 16:25:38 |
| 3571 | ticket_desk | 3 | NULL | 3571 | 2018-08-13 11:21:22 |
| 3572 | online | NULL | NULL | 3572 | 2018-08-13 11:53:26 |
| 3573 | audio_guide_desk | NULL | 3 | 3573 | 2018-08-13 11:58:18 |
| 3574 | app_store | NULL | NULL | 3574 | 2018-08-14 00:13:34 |
| 3575 | online | NULL | NULL | 3575 | 2018-08-14 07:23:16 |
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;