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 3,476–3,500 of 5,412

payment, page 140 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3476debit_card17002018-07-27 11:46:01
3477debit_card15002018-07-27 16:05:39
3478credit_card30002018-07-27 19:12:38
3479credit_card4002018-07-28 02:23:05
3480digital_wallet15002018-07-28 12:43:49
3481cash17002018-07-28 12:45:06
3482credit_card30002018-07-28 16:02:28
3483digital_wallet15002018-07-28 21:37:49
3484credit_card4002018-07-29 01:55:13
3485credit_card68002018-07-29 09:02:52
3486debit_card8002018-07-29 09:35:31
3487debit_card4002018-07-29 09:58:57
3488digital_wallet75002018-07-29 12:34:27
3489credit_card30002018-07-30 07:42:24
3490debit_card8002018-07-30 13:37:10
3491digital_wallet85002018-07-30 15:11:07
3492cash8002018-07-30 15:53:30
3493credit_card68002018-07-31 09:32:31
3494debit_card17002018-07-31 12:43:06
3495credit_card15002018-07-31 15:29:47
3496credit_card4002018-08-01 05:51:30
3497digital_wallet45002018-08-01 07:49:26
3498credit_card75002018-08-01 15:34:35
3499credit_card4002018-08-01 15:37:58
3500credit_card15002018-08-02 07:37: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;