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,876–2,900 of 5,412

payment, page 116 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2876debit_card4002018-01-26 21:37:26
2877debit_card4002018-01-28 01:12:59
2878credit_card4002018-01-29 02:57:33
2879credit_card15002018-01-29 08:07:40
2880debit_card51002018-01-29 09:39:08
2881cash8002018-01-29 14:23:43
2882debit_card4002018-01-31 00:17:59
2883credit_card15002018-02-01 13:29:21
2884credit_card4002018-02-02 21:00:01
2885credit_card4002018-02-02 21:57:40
2886credit_card4002018-02-03 12:18:31
2887debit_card4002018-02-03 15:05:44
2888credit_card30002018-02-03 15:30:29
2889credit_card4002018-02-03 15:42:32
2890credit_card15002018-02-03 18:43:28
2891debit_card4002018-02-03 23:46:55
2892digital_wallet34002018-02-04 10:31:54
2893credit_card8002018-02-04 11:17:04
2894credit_card4002018-02-05 12:08:31
2895credit_card15002018-02-05 16:34:28
2896credit_card4002018-02-05 19:12:27
2897credit_card34002018-02-06 09:32:56
2898credit_card4002018-02-06 16:26:39
2899credit_card30002018-02-06 16:34:46
2900debit_card15002018-02-07 20:22:43
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;