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,901–2,925 of 5,412

payment, page 117 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2901credit_card30002018-02-07 22:21:31
2902cash34002018-02-08 09:07:50
2903debit_card8002018-02-08 11:26:43
2904cash34002018-02-08 13:18:21
2905digital_wallet30002018-02-08 16:43:53
2906digital_wallet15002018-02-09 07:15:23
2907debit_card4002018-02-09 08:17:25
2908credit_card8002018-02-09 12:16:46
2909credit_card60002018-02-10 07:38:51
2910credit_card15002018-02-10 19:33:02
2911credit_card15002018-02-10 20:37:56
2912credit_card30002018-02-10 21:07:27
2913credit_card45002018-02-11 09:25:36
2914credit_card4002018-02-11 12:25:33
2915debit_card8002018-02-11 13:09:22
2916credit_card30002018-02-11 13:48:09
2917debit_card15002018-02-11 14:23:17
2918digital_wallet8002018-02-11 14:39:14
2919credit_card8002018-02-11 14:43:19
2920debit_card4002018-02-12 06:19:31
2921debit_card60002018-02-12 16:18:06
2922digital_wallet15002018-02-13 12:12:08
2923cash8002018-02-13 13:03:34
2924debit_card34002018-02-14 09:42:17
2925debit_card68002018-02-15 13:06:37
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;