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,276–4,300 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4276 | app_store | NULL | NULL | 4276 | 2019-04-06 00:27:14 |
| 4277 | ticket_desk | 1 | NULL | 4277 | 2019-04-06 09:10:22 |
| 4278 | ticket_desk | 1 | NULL | 4278 | 2019-04-06 09:32:50 |
| 4279 | audio_guide_desk | NULL | 3 | 4279 | 2019-04-06 09:51:43 |
| 4280 | ticket_desk | 2 | NULL | 4280 | 2019-04-07 09:26:24 |
| 4281 | app_store | NULL | NULL | 4281 | 2019-04-07 10:08:59 |
| 4282 | audio_guide_desk | NULL | 2 | 4282 | 2019-04-07 10:14:36 |
| 4283 | audio_guide_desk | NULL | 3 | 4283 | 2019-04-07 11:26:23 |
| 4284 | app_store | NULL | NULL | 4284 | 2019-04-08 08:26:23 |
| 4285 | online | NULL | NULL | 4285 | 2019-04-08 08:32:48 |
| 4286 | online | NULL | NULL | 4286 | 2019-04-08 09:02:32 |
| 4287 | online | NULL | NULL | 4287 | 2019-04-08 09:10:50 |
| 4288 | app_store | NULL | NULL | 4288 | 2019-04-08 09:18:15 |
| 4289 | online | NULL | NULL | 4289 | 2019-04-08 09:47:59 |
| 4290 | audio_guide_desk | NULL | 2 | 4290 | 2019-04-08 09:53:38 |
| 4291 | ticket_desk | 1 | NULL | 4291 | 2019-04-08 11:48:24 |
| 4292 | online | NULL | NULL | 4292 | 2019-04-09 09:55:20 |
| 4293 | ticket_desk | 2 | NULL | 4293 | 2019-04-09 11:55:52 |
| 4294 | ticket_desk | 1 | NULL | 4294 | 2019-04-09 15:37:10 |
| 4295 | online | NULL | NULL | 4295 | 2019-04-09 16:50:14 |
| 4296 | ticket_desk | 1 | NULL | 4296 | 2019-04-11 10:18:10 |
| 4297 | online | NULL | NULL | 4297 | 2019-04-12 07:49:15 |
| 4298 | app_store | NULL | NULL | 4298 | 2019-04-12 08:00:24 |
| 4299 | ticket_desk | 2 | NULL | 4299 | 2019-04-12 09:59:53 |
| 4300 | ticket_desk | 5 | NULL | 4300 | 2019-04-12 13:09:08 |
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;