Skip to content
Louvre Ops DB

Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Download CSV Query in playground

Rows 2,151–2,175 of 5,412

payment, page 87 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2151cash8002017-05-11 10:58:08
2152credit_card30002017-05-11 11:40:01
2153digital_wallet34002017-05-11 14:06:42
2154cash34002017-05-11 15:40:11
2155credit_card45002017-05-11 17:23:36
2156debit_card34002017-05-12 09:01:26
2157cash8002017-05-12 09:28:47
2158digital_wallet60002017-05-12 09:57:03
2159cash17002017-05-12 13:43:03
2160credit_card8002017-05-12 14:28:47
2161credit_card15002017-05-12 16:35:24
2162debit_card51002017-05-13 15:18:05
2163digital_wallet8002017-05-13 15:51:15
2164debit_card15002017-05-14 15:43:41
2165credit_card4002017-05-14 17:55:47
2166debit_card15002017-05-14 20:15:12
2167credit_card15002017-05-15 12:36:18
2168debit_card4002017-05-16 10:19:43
2169credit_card75002017-05-17 14:47:01
2170credit_card34002017-05-18 09:08:56
2171credit_card30002017-05-18 21:58:25
2172credit_card4002017-05-19 06:12:47
2173debit_card17002017-05-19 10:50:08
2174credit_card4002017-05-20 03:34:18
2175credit_card4002017-05-20 08:46:46
Table definition
CREATE TABLE payment (
  payment_id   INTEGER PRIMARY KEY,
  method       TEXT NOT NULL
               CHECK (method IN ('credit_card', 'debit_card', 'digital_wallet', 'cash')),
  amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),
  paid_at      TEXT NOT NULL CHECK (paid_at GLOB '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]')
) STRICT;