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,651–4,675 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4651 | ticket_desk | 1 | NULL | 4651 | 2019-07-19 09:17:24 |
| 4652 | audio_guide_desk | NULL | 2 | 4652 | 2019-07-19 09:46:09 |
| 4653 | online | NULL | NULL | 4653 | 2019-07-19 10:43:08 |
| 4654 | online | NULL | NULL | 4654 | 2019-07-19 10:44:01 |
| 4655 | ticket_desk | 4 | NULL | 4655 | 2019-07-19 10:54:55 |
| 4656 | audio_guide_desk | NULL | 3 | 4656 | 2019-07-19 15:19:25 |
| 4657 | online | NULL | NULL | 4657 | 2019-07-19 19:18:13 |
| 4658 | app_store | NULL | NULL | 4658 | 2019-07-19 21:43:36 |
| 4659 | ticket_desk | 1 | NULL | 4659 | 2019-07-20 09:50:04 |
| 4660 | app_store | NULL | NULL | 4660 | 2019-07-20 11:18:57 |
| 4661 | ticket_desk | 1 | NULL | 4661 | 2019-07-20 11:55:17 |
| 4662 | audio_guide_desk | NULL | 1 | 4662 | 2019-07-20 12:36:37 |
| 4663 | ticket_desk | 3 | NULL | 4663 | 2019-07-20 14:33:19 |
| 4664 | ticket_desk | 2 | NULL | 4664 | 2019-07-20 14:34:10 |
| 4665 | audio_guide_desk | NULL | 2 | 4665 | 2019-07-20 16:25:51 |
| 4666 | online | NULL | NULL | 4666 | 2019-07-20 18:26:41 |
| 4667 | online | NULL | NULL | 4667 | 2019-07-21 18:35:28 |
| 4668 | app_store | NULL | NULL | 4668 | 2019-07-22 08:25:46 |
| 4669 | ticket_desk | 1 | NULL | 4669 | 2019-07-22 13:14:51 |
| 4670 | audio_guide_desk | NULL | 3 | 4670 | 2019-07-22 13:52:02 |
| 4671 | online | NULL | NULL | 4671 | 2019-07-22 23:59:40 |
| 4672 | online | NULL | NULL | 4672 | 2019-07-23 08:38:24 |
| 4673 | ticket_desk | 2 | NULL | 4673 | 2019-07-23 10:45:41 |
| 4674 | online | NULL | NULL | 4674 | 2019-07-23 11:26:47 |
| 4675 | online | NULL | NULL | 4675 | 2019-07-23 20:00:09 |
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;