Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 301–325 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 301 | ticket_desk | 1 | NULL | 301 | 2015-06-11 08:56:04 |
| 302 | audio_guide_desk | NULL | 1 | 302 | 2015-06-11 09:23:14 |
| 303 | audio_guide_desk | NULL | 2 | 303 | 2015-06-11 09:33:34 |
| 304 | ticket_desk | 1 | NULL | 304 | 2015-06-11 12:53:22 |
| 305 | audio_guide_desk | NULL | 2 | 305 | 2015-06-11 13:18:08 |
| 306 | audio_guide_desk | NULL | 2 | 306 | 2015-06-11 13:20:26 |
| 307 | audio_guide_desk | NULL | 3 | 307 | 2015-06-11 17:03:44 |
| 308 | app_store | NULL | NULL | 308 | 2015-06-11 17:31:26 |
| 309 | audio_guide_desk | NULL | 2 | 309 | 2015-06-12 11:03:58 |
| 310 | ticket_desk | 4 | NULL | 310 | 2015-06-12 12:42:07 |
| 311 | online | NULL | NULL | 311 | 2015-06-12 23:26:08 |
| 312 | ticket_desk | 4 | NULL | 312 | 2015-06-13 14:29:57 |
| 313 | audio_guide_desk | NULL | 2 | 313 | 2015-06-13 14:56:58 |
| 314 | app_store | NULL | NULL | 314 | 2015-06-13 20:20:19 |
| 315 | app_store | NULL | NULL | 315 | 2015-06-13 23:10:15 |
| 316 | audio_guide_desk | NULL | 2 | 316 | 2015-06-14 09:33:51 |
| 317 | online | NULL | NULL | 317 | 2015-06-14 12:15:02 |
| 318 | ticket_desk | 1 | NULL | 318 | 2015-06-15 10:04:11 |
| 319 | online | NULL | NULL | 319 | 2015-06-16 11:59:24 |
| 320 | app_store | NULL | NULL | 320 | 2015-06-16 13:10:13 |
| 321 | ticket_desk | 2 | NULL | 321 | 2015-06-16 14:56:39 |
| 322 | app_store | NULL | NULL | 322 | 2015-06-16 15:27:52 |
| 323 | audio_guide_desk | NULL | 2 | 323 | 2015-06-16 15:39:32 |
| 324 | ticket_desk | 1 | NULL | 324 | 2015-06-17 13:19:31 |
| 325 | audio_guide_desk | NULL | 2 | 325 | 2015-06-17 13:55:39 |
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;