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,426–3,450 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 3426 | app_store | NULL | NULL | 3426 | 2018-07-12 20:24:46 |
| 3427 | online | NULL | NULL | 3427 | 2018-07-12 21:22:41 |
| 3428 | online | NULL | NULL | 3428 | 2018-07-13 13:06:36 |
| 3429 | online | NULL | NULL | 3429 | 2018-07-13 16:53:02 |
| 3430 | online | NULL | NULL | 3430 | 2018-07-14 09:46:19 |
| 3431 | ticket_desk | 1 | NULL | 3431 | 2018-07-14 10:35:25 |
| 3432 | audio_guide_desk | NULL | 3 | 3432 | 2018-07-14 10:54:48 |
| 3433 | audio_guide_desk | NULL | 2 | 3433 | 2018-07-14 11:05:21 |
| 3434 | online | NULL | NULL | 3434 | 2018-07-14 11:37:49 |
| 3435 | online | NULL | NULL | 3435 | 2018-07-15 07:40:55 |
| 3436 | ticket_desk | 2 | NULL | 3436 | 2018-07-15 11:04:04 |
| 3437 | audio_guide_desk | NULL | 2 | 3437 | 2018-07-15 11:25:45 |
| 3438 | ticket_desk | 1 | NULL | 3438 | 2018-07-15 11:36:08 |
| 3439 | ticket_desk | 2 | NULL | 3439 | 2018-07-15 13:48:45 |
| 3440 | online | NULL | NULL | 3440 | 2018-07-15 14:22:15 |
| 3441 | online | NULL | NULL | 3441 | 2018-07-16 10:23:12 |
| 3442 | online | NULL | NULL | 3442 | 2018-07-16 13:22:32 |
| 3443 | ticket_desk | 4 | NULL | 3443 | 2018-07-17 08:49:24 |
| 3444 | app_store | NULL | NULL | 3444 | 2018-07-17 09:14:45 |
| 3445 | online | NULL | NULL | 3445 | 2018-07-17 11:52:09 |
| 3446 | ticket_desk | 2 | NULL | 3446 | 2018-07-17 14:08:33 |
| 3447 | ticket_desk | 1 | NULL | 3447 | 2018-07-17 14:08:38 |
| 3448 | audio_guide_desk | NULL | 1 | 3448 | 2018-07-17 14:31:11 |
| 3449 | audio_guide_desk | NULL | 1 | 3449 | 2018-07-17 14:37:45 |
| 3450 | ticket_desk | 2 | NULL | 3450 | 2018-07-18 09:30:01 |
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;