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,576–4,600 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4576 | audio_guide_desk | NULL | 3 | 4576 | 2019-06-29 10:59:36 |
| 4577 | app_store | NULL | NULL | 4577 | 2019-06-29 19:41:12 |
| 4578 | app_store | NULL | NULL | 4578 | 2019-06-30 01:40:20 |
| 4579 | audio_guide_desk | NULL | 2 | 4579 | 2019-06-30 10:19:04 |
| 4580 | online | NULL | NULL | 4580 | 2019-07-01 23:18:34 |
| 4581 | ticket_desk | 1 | NULL | 4581 | 2019-07-02 09:23:41 |
| 4582 | audio_guide_desk | NULL | 2 | 4582 | 2019-07-02 10:09:19 |
| 4583 | app_store | NULL | NULL | 4583 | 2019-07-02 19:42:03 |
| 4584 | online | NULL | NULL | 4584 | 2019-07-02 21:31:07 |
| 4585 | app_store | NULL | NULL | 4585 | 2019-07-02 22:37:27 |
| 4586 | online | NULL | NULL | 4586 | 2019-07-04 10:05:25 |
| 4587 | ticket_desk | 1 | NULL | 4587 | 2019-07-04 12:04:19 |
| 4588 | audio_guide_desk | NULL | 2 | 4588 | 2019-07-04 12:49:25 |
| 4589 | audio_guide_desk | NULL | 2 | 4589 | 2019-07-04 12:57:25 |
| 4590 | online | NULL | NULL | 4590 | 2019-07-05 08:35:21 |
| 4591 | online | NULL | NULL | 4591 | 2019-07-05 11:14:26 |
| 4592 | online | NULL | NULL | 4592 | 2019-07-05 13:14:43 |
| 4593 | app_store | NULL | NULL | 4593 | 2019-07-05 14:17:47 |
| 4594 | app_store | NULL | NULL | 4594 | 2019-07-05 15:12:21 |
| 4595 | online | NULL | NULL | 4595 | 2019-07-05 15:40:36 |
| 4596 | online | NULL | NULL | 4596 | 2019-07-06 10:47:44 |
| 4597 | ticket_desk | 1 | NULL | 4597 | 2019-07-06 13:36:55 |
| 4598 | audio_guide_desk | NULL | 3 | 4598 | 2019-07-06 14:04:32 |
| 4599 | online | NULL | NULL | 4599 | 2019-07-06 21:39:13 |
| 4600 | online | NULL | NULL | 4600 | 2019-07-06 22:27:02 |
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;