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,726–4,750 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4726 | online | NULL | NULL | 4726 | 2019-08-04 18:44:34 |
| 4727 | app_store | NULL | NULL | 4727 | 2019-08-04 19:42:44 |
| 4728 | ticket_desk | 2 | NULL | 4728 | 2019-08-05 10:16:04 |
| 4729 | online | NULL | NULL | 4729 | 2019-08-05 11:57:20 |
| 4730 | audio_guide_desk | NULL | 1 | 4730 | 2019-08-05 13:45:55 |
| 4731 | online | NULL | NULL | 4731 | 2019-08-05 17:11:22 |
| 4732 | app_store | NULL | NULL | 4732 | 2019-08-05 22:08:50 |
| 4733 | online | NULL | NULL | 4733 | 2019-08-06 07:39:57 |
| 4734 | audio_guide_desk | NULL | 2 | 4734 | 2019-08-06 09:30:55 |
| 4735 | audio_guide_desk | NULL | 2 | 4735 | 2019-08-06 12:09:03 |
| 4736 | ticket_desk | 2 | NULL | 4736 | 2019-08-06 12:31:45 |
| 4737 | audio_guide_desk | NULL | 2 | 4737 | 2019-08-06 13:21:58 |
| 4738 | audio_guide_desk | NULL | 2 | 4738 | 2019-08-06 14:41:49 |
| 4739 | audio_guide_desk | NULL | 2 | 4739 | 2019-08-06 15:11:15 |
| 4740 | app_store | NULL | NULL | 4740 | 2019-08-07 03:18:29 |
| 4741 | online | NULL | NULL | 4741 | 2019-08-07 08:16:38 |
| 4742 | online | NULL | NULL | 4742 | 2019-08-07 08:38:00 |
| 4743 | ticket_desk | 2 | NULL | 4743 | 2019-08-07 09:53:46 |
| 4744 | audio_guide_desk | NULL | 1 | 4744 | 2019-08-07 10:42:35 |
| 4745 | ticket_desk | 2 | NULL | 4745 | 2019-08-07 11:49:22 |
| 4746 | online | NULL | NULL | 4746 | 2019-08-07 20:43:47 |
| 4747 | online | NULL | NULL | 4747 | 2019-08-08 11:09:49 |
| 4748 | online | NULL | NULL | 4748 | 2019-08-08 11:55:51 |
| 4749 | online | NULL | NULL | 4749 | 2019-08-08 20:15:19 |
| 4750 | online | NULL | NULL | 4750 | 2019-08-08 22:31:07 |
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;