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 851–875 of 5,412

payment, page 35 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
851cash68002015-12-06 09:46:44
852credit_card17002015-12-06 10:06:28
853credit_card8002015-12-06 12:02:00
854credit_card34002015-12-06 14:03:36
855debit_card8002015-12-06 14:51:30
856debit_card68002015-12-06 14:51:45
857credit_card4002015-12-06 14:52:05
858debit_card17002015-12-07 12:01:50
859credit_card4002015-12-08 05:04:02
860credit_card17002015-12-08 10:12:38
861cash85002015-12-09 09:04:30
862debit_card17002015-12-09 09:37:34
863credit_card15002015-12-09 11:45:08
864credit_card51002015-12-09 13:04:37
865credit_card4002015-12-10 06:08:19
866debit_card4002015-12-10 10:30:00
867credit_card4002015-12-10 18:16:33
868debit_card15002015-12-10 20:02:31
869credit_card4002015-12-10 20:13:40
870cash8002015-12-11 12:47:14
871credit_card17002015-12-11 14:26:48
872cash17002015-12-12 09:28:55
873credit_card17002015-12-12 15:04:03
874debit_card8002015-12-12 15:29:53
875digital_wallet17002015-12-13 16:05:48
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;