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,351–4,375 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 4351 | online | NULL | NULL | 4351 | 2019-04-24 11:40:18 |
| 4352 | audio_guide_desk | NULL | 1 | 4352 | 2019-04-25 09:51:15 |
| 4353 | audio_guide_desk | NULL | 2 | 4353 | 2019-04-25 10:08:49 |
| 4354 | audio_guide_desk | NULL | 2 | 4354 | 2019-04-25 12:44:17 |
| 4355 | ticket_desk | 3 | NULL | 4355 | 2019-04-26 10:10:35 |
| 4356 | online | NULL | NULL | 4356 | 2019-04-27 07:26:24 |
| 4357 | app_store | NULL | NULL | 4357 | 2019-04-27 15:46:05 |
| 4358 | online | NULL | NULL | 4358 | 2019-04-28 09:00:15 |
| 4359 | audio_guide_desk | NULL | 2 | 4359 | 2019-04-28 09:49:36 |
| 4360 | app_store | NULL | NULL | 4360 | 2019-04-28 17:14:38 |
| 4361 | app_store | NULL | NULL | 4361 | 2019-04-29 06:34:14 |
| 4362 | ticket_desk | 5 | NULL | 4362 | 2019-04-29 11:31:52 |
| 4363 | audio_guide_desk | NULL | 2 | 4363 | 2019-04-29 12:08:35 |
| 4364 | online | NULL | NULL | 4364 | 2019-04-29 13:26:51 |
| 4365 | ticket_desk | 1 | NULL | 4365 | 2019-04-29 14:12:20 |
| 4366 | online | NULL | NULL | 4366 | 2019-04-29 18:18:43 |
| 4367 | online | NULL | NULL | 4367 | 2019-04-29 22:09:23 |
| 4368 | online | NULL | NULL | 4368 | 2019-04-29 23:34:15 |
| 4369 | online | NULL | NULL | 4369 | 2019-04-30 09:13:01 |
| 4370 | app_store | NULL | NULL | 4370 | 2019-04-30 10:06:00 |
| 4371 | ticket_desk | 1 | NULL | 4371 | 2019-04-30 13:14:01 |
| 4372 | online | NULL | NULL | 4372 | 2019-05-01 15:14:43 |
| 4373 | online | NULL | NULL | 4373 | 2019-05-02 10:41:40 |
| 4374 | ticket_desk | 2 | NULL | 4374 | 2019-05-02 11:00:23 |
| 4375 | online | NULL | NULL | 4375 | 2019-05-02 14:53:06 |
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;