Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 576–600 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 576 | ticket_desk | 1 | NULL | 576 | 2015-08-28 12:39:07 |
| 577 | app_store | NULL | NULL | 577 | 2015-08-28 12:53:44 |
| 578 | audio_guide_desk | NULL | 1 | 578 | 2015-08-28 12:54:26 |
| 579 | audio_guide_desk | NULL | 1 | 579 | 2015-08-28 12:55:17 |
| 580 | app_store | NULL | NULL | 580 | 2015-08-28 18:36:45 |
| 581 | app_store | NULL | NULL | 581 | 2015-08-28 21:31:58 |
| 582 | online | NULL | NULL | 582 | 2015-08-28 23:52:59 |
| 583 | app_store | NULL | NULL | 583 | 2015-08-29 01:49:04 |
| 584 | online | NULL | NULL | 584 | 2015-08-29 07:55:24 |
| 585 | ticket_desk | 4 | NULL | 585 | 2015-08-29 11:10:54 |
| 586 | ticket_desk | 2 | NULL | 586 | 2015-08-29 11:26:09 |
| 587 | ticket_desk | 1 | NULL | 587 | 2015-08-29 12:36:12 |
| 588 | audio_guide_desk | NULL | 3 | 588 | 2015-08-29 12:38:06 |
| 589 | audio_guide_desk | NULL | 1 | 589 | 2015-08-29 12:50:22 |
| 590 | ticket_desk | 4 | NULL | 590 | 2015-08-29 13:57:58 |
| 591 | ticket_desk | 1 | NULL | 591 | 2015-08-29 16:04:32 |
| 592 | audio_guide_desk | NULL | 3 | 592 | 2015-08-29 16:48:50 |
| 593 | audio_guide_desk | NULL | 3 | 593 | 2015-08-29 16:52:27 |
| 594 | audio_guide_desk | NULL | 2 | 594 | 2015-08-30 11:12:54 |
| 595 | audio_guide_desk | NULL | 2 | 595 | 2015-08-30 13:09:54 |
| 596 | online | NULL | NULL | 596 | 2015-08-30 23:42:09 |
| 597 | ticket_desk | 1 | NULL | 597 | 2015-08-31 09:48:39 |
| 598 | ticket_desk | 3 | NULL | 598 | 2015-08-31 10:06:03 |
| 599 | audio_guide_desk | NULL | 2 | 599 | 2015-08-31 10:11:50 |
| 600 | ticket_desk | 2 | NULL | 600 | 2015-08-31 11:05:14 |
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;