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,051–2,075 of 5,412

payment, page 83 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2051credit_card30002017-04-10 14:50:03
2052credit_card4002017-04-10 15:32:58
2053digital_wallet60002017-04-10 19:48:29
2054digital_wallet17002017-04-11 11:20:51
2055cash8002017-04-11 11:48:26
2056credit_card75002017-04-11 14:06:08
2057credit_card15002017-04-11 15:07:57
2058credit_card75002017-04-11 18:46:06
2059credit_card60002017-04-12 09:34:56
2060credit_card15002017-04-12 10:09:24
2061cash8002017-04-12 12:12:49
2062debit_card17002017-04-12 14:34:46
2063credit_card30002017-04-12 20:07:09
2064credit_card8002017-04-13 13:21:08
2065debit_card4002017-04-13 18:50:50
2066debit_card15002017-04-13 19:01:26
2067credit_card68002017-04-14 10:40:56
2068credit_card8002017-04-14 11:40:10
2069debit_card15002017-04-14 12:27:47
2070credit_card60002017-04-14 19:20:52
2071debit_card15002017-04-15 07:07:41
2072debit_card4002017-04-16 02:08:35
2073credit_card8002017-04-16 12:17:08
2074credit_card60002017-04-16 15:51:14
2075credit_card15002017-04-16 21:49:39
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;