Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 3,501–3,525 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3501 | ticket_desk | 1 | NULL | 3501 | 2018-08-02 10:35:26 |
| 3502 | online | NULL | NULL | 3502 | 2018-08-02 11:18:51 |
| 3503 | ticket_desk | 1 | NULL | 3503 | 2018-08-02 11:26:49 |
| 3504 | ticket_desk | 1 | NULL | 3504 | 2018-08-02 11:34:05 |
| 3505 | online | NULL | NULL | 3505 | 2018-08-02 15:33:11 |
| 3506 | audio_guide_desk | NULL | 2 | 3506 | 2018-08-02 16:11:51 |
| 3507 | online | NULL | NULL | 3507 | 2018-08-02 23:51:07 |
| 3508 | ticket_desk | 2 | NULL | 3508 | 2018-08-03 11:04:19 |
| 3509 | audio_guide_desk | NULL | 3 | 3509 | 2018-08-03 11:28:58 |
| 3510 | online | NULL | NULL | 3510 | 2018-08-03 12:28:33 |
| 3511 | online | NULL | NULL | 3511 | 2018-08-03 23:14:36 |
| 3512 | app_store | NULL | NULL | 3512 | 2018-08-04 05:16:05 |
| 3513 | online | NULL | NULL | 3513 | 2018-08-04 07:07:28 |
| 3514 | online | NULL | NULL | 3514 | 2018-08-04 12:12:08 |
| 3515 | ticket_desk | 1 | NULL | 3515 | 2018-08-04 13:04:21 |
| 3516 | audio_guide_desk | NULL | 3 | 3516 | 2018-08-04 13:26:09 |
| 3517 | audio_guide_desk | NULL | 3 | 3517 | 2018-08-04 13:31:45 |
| 3518 | ticket_desk | 5 | NULL | 3518 | 2018-08-04 16:27:28 |
| 3519 | audio_guide_desk | NULL | 2 | 3519 | 2018-08-04 17:12:22 |
| 3520 | audio_guide_desk | NULL | 2 | 3520 | 2018-08-04 17:13:11 |
| 3521 | ticket_desk | 1 | NULL | 3521 | 2018-08-05 10:56:35 |
| 3522 | ticket_desk | 1 | NULL | 3522 | 2018-08-05 12:38:19 |
| 3523 | audio_guide_desk | NULL | 2 | 3523 | 2018-08-05 13:14:22 |
| 3524 | app_store | NULL | NULL | 3524 | 2018-08-05 17:54:07 |
| 3525 | online | NULL | NULL | 3525 | 2018-08-06 08:14:28 |
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;