Table
purchase_order
One sale: the channel (website, ticket desk, audio-guide desk, app store), when, and its payment.
Replaces in 2020: Invoices
Rows 951–975 of 5,412
| order_idINTEGER | channelTEXT | entrance_id→ entrance.entrance_id | wing_id→ wing.wing_id | payment_id→ payment.payment_id | ordered_atTEXT |
|---|---|---|---|---|---|
| 951 | online | NULL | NULL | 951 | 2016-01-15 12:16:01 |
| 952 | audio_guide_desk | NULL | 2 | 952 | 2016-01-15 15:17:38 |
| 953 | ticket_desk | 5 | NULL | 953 | 2016-01-16 12:53:42 |
| 954 | online | NULL | NULL | 954 | 2016-01-16 18:16:39 |
| 955 | app_store | NULL | NULL | 955 | 2016-01-17 10:17:45 |
| 956 | ticket_desk | 1 | NULL | 956 | 2016-01-18 08:42:44 |
| 957 | audio_guide_desk | NULL | 2 | 957 | 2016-01-18 10:11:49 |
| 958 | online | NULL | NULL | 958 | 2016-01-18 11:12:57 |
| 959 | online | NULL | NULL | 959 | 2016-01-18 11:50:54 |
| 960 | online | NULL | NULL | 960 | 2016-01-21 14:11:39 |
| 961 | online | NULL | NULL | 961 | 2016-01-21 15:13:30 |
| 962 | audio_guide_desk | NULL | 2 | 962 | 2016-01-22 10:47:26 |
| 963 | ticket_desk | 2 | NULL | 963 | 2016-01-23 08:45:41 |
| 964 | ticket_desk | 5 | NULL | 964 | 2016-01-23 09:20:04 |
| 965 | audio_guide_desk | NULL | 3 | 965 | 2016-01-23 09:32:43 |
| 966 | ticket_desk | 1 | NULL | 966 | 2016-01-23 10:53:35 |
| 967 | audio_guide_desk | NULL | 1 | 967 | 2016-01-23 11:30:58 |
| 968 | ticket_desk | 1 | NULL | 968 | 2016-01-23 11:41:22 |
| 969 | audio_guide_desk | NULL | 3 | 969 | 2016-01-23 12:22:56 |
| 970 | app_store | NULL | NULL | 970 | 2016-01-23 17:47:32 |
| 971 | ticket_desk | 1 | NULL | 971 | 2016-01-24 10:12:57 |
| 972 | ticket_desk | 2 | NULL | 972 | 2016-01-26 10:29:00 |
| 973 | online | NULL | NULL | 973 | 2016-01-29 18:14:20 |
| 974 | app_store | NULL | NULL | 974 | 2016-01-30 00:33:43 |
| 975 | ticket_desk | 1 | NULL | 975 | 2016-01-30 12:23: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;