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,526–3,550 of 5,412

payment, page 142 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3526debit_card17002018-08-06 09:46:10
3527credit_card34002018-08-06 11:08:28
3528credit_card8002018-08-06 11:50:26
3529debit_card8002018-08-06 12:13:37
3530credit_card34002018-08-06 12:35:50
3531debit_card8002018-08-06 13:13:14
3532debit_card15002018-08-06 22:39:53
3533debit_card8002018-08-07 09:40:39
3534digital_wallet30002018-08-07 10:08:50
3535cash51002018-08-07 10:27:15
3536credit_card8002018-08-07 11:04:29
3537credit_card34002018-08-07 16:04:33
3538credit_card17002018-08-08 10:56:21
3539digital_wallet30002018-08-08 19:39:25
3540credit_card4002018-08-09 07:37:29
3541debit_card4002018-08-09 08:41:03
3542debit_card75002018-08-09 09:49:38
3543credit_card34002018-08-09 10:16:48
3544digital_wallet85002018-08-09 11:02:05
3545debit_card68002018-08-09 13:23:25
3546credit_card8002018-08-09 13:48:53
3547credit_card15002018-08-09 16:30:00
3548digital_wallet30002018-08-09 17:36:31
3549digital_wallet60002018-08-09 20:16:50
3550digital_wallet15002018-08-09 23:28:51
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;