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,551–4,575 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4551 | audio_guide_desk | NULL | 3 | 4551 | 2019-06-22 12:07:48 |
| 4552 | audio_guide_desk | NULL | 3 | 4552 | 2019-06-22 12:34:43 |
| 4553 | online | NULL | NULL | 4553 | 2019-06-22 21:58:12 |
| 4554 | online | NULL | NULL | 4554 | 2019-06-23 16:12:59 |
| 4555 | audio_guide_desk | NULL | 3 | 4555 | 2019-06-23 17:00:09 |
| 4556 | online | NULL | NULL | 4556 | 2019-06-23 22:31:04 |
| 4557 | app_store | NULL | NULL | 4557 | 2019-06-23 23:01:32 |
| 4558 | audio_guide_desk | NULL | 2 | 4558 | 2019-06-24 12:56:12 |
| 4559 | audio_guide_desk | NULL | 2 | 4559 | 2019-06-24 13:01:55 |
| 4560 | audio_guide_desk | NULL | 2 | 4560 | 2019-06-24 13:02:09 |
| 4561 | app_store | NULL | NULL | 4561 | 2019-06-24 17:04:47 |
| 4562 | online | NULL | NULL | 4562 | 2019-06-24 19:37:18 |
| 4563 | online | NULL | NULL | 4563 | 2019-06-24 23:48:54 |
| 4564 | ticket_desk | 2 | NULL | 4564 | 2019-06-25 10:37:13 |
| 4565 | online | NULL | NULL | 4565 | 2019-06-25 22:31:44 |
| 4566 | online | NULL | NULL | 4566 | 2019-06-26 10:46:22 |
| 4567 | app_store | NULL | NULL | 4567 | 2019-06-26 11:26:02 |
| 4568 | online | NULL | NULL | 4568 | 2019-06-26 22:26:55 |
| 4569 | ticket_desk | 4 | NULL | 4569 | 2019-06-27 13:44:11 |
| 4570 | online | NULL | NULL | 4570 | 2019-06-27 20:18:29 |
| 4571 | app_store | NULL | NULL | 4571 | 2019-06-27 22:43:53 |
| 4572 | audio_guide_desk | NULL | 1 | 4572 | 2019-06-28 14:28:37 |
| 4573 | online | NULL | NULL | 4573 | 2019-06-28 15:59:39 |
| 4574 | ticket_desk | 1 | NULL | 4574 | 2019-06-29 09:43:57 |
| 4575 | audio_guide_desk | NULL | 2 | 4575 | 2019-06-29 10:12:53 |
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;