Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 4,826–4,850 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4826 | online | NULL | NULL | 4826 | 2019-08-29 07:16:30 |
| 4827 | ticket_desk | 2 | NULL | 4827 | 2019-08-29 09:06:22 |
| 4828 | online | NULL | NULL | 4828 | 2019-08-29 10:42:26 |
| 4829 | audio_guide_desk | NULL | 2 | 4829 | 2019-08-29 11:10:30 |
| 4830 | online | NULL | NULL | 4830 | 2019-08-29 12:37:25 |
| 4831 | ticket_desk | 1 | NULL | 4831 | 2019-08-30 09:10:05 |
| 4832 | ticket_desk | 1 | NULL | 4832 | 2019-08-30 10:00:26 |
| 4833 | audio_guide_desk | NULL | 2 | 4833 | 2019-08-30 10:47:06 |
| 4834 | app_store | NULL | NULL | 4834 | 2019-08-30 14:45:33 |
| 4835 | online | NULL | NULL | 4835 | 2019-08-30 17:28:03 |
| 4836 | ticket_desk | 2 | NULL | 4836 | 2019-08-31 09:44:40 |
| 4837 | ticket_desk | 1 | NULL | 4837 | 2019-08-31 10:05:07 |
| 4838 | audio_guide_desk | NULL | 1 | 4838 | 2019-08-31 10:43:01 |
| 4839 | audio_guide_desk | NULL | 3 | 4839 | 2019-08-31 13:19:56 |
| 4840 | online | NULL | NULL | 4840 | 2019-08-31 20:53:22 |
| 4841 | online | NULL | NULL | 4841 | 2019-09-01 07:35:50 |
| 4842 | online | NULL | NULL | 4842 | 2019-09-01 10:05:01 |
| 4843 | ticket_desk | 1 | NULL | 4843 | 2019-09-01 11:34:46 |
| 4844 | online | NULL | NULL | 4844 | 2019-09-02 21:21:34 |
| 4845 | online | NULL | NULL | 4845 | 2019-09-03 17:42:13 |
| 4846 | online | NULL | NULL | 4846 | 2019-09-03 18:06:34 |
| 4847 | app_store | NULL | NULL | 4847 | 2019-09-04 06:28:22 |
| 4848 | ticket_desk | 2 | NULL | 4848 | 2019-09-04 15:35:37 |
| 4849 | audio_guide_desk | NULL | 2 | 4849 | 2019-09-04 16:05:16 |
| 4850 | online | NULL | NULL | 4850 | 2019-09-04 16:07:14 |
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;