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,976–3,000 of 5,412

payment, page 120 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2976debit_card30002018-03-06 21:13:38
2977debit_card4002018-03-07 12:17:13
2978credit_card15002018-03-07 15:34:45
2979credit_card4002018-03-07 21:34:47
2980debit_card30002018-03-08 11:02:31
2981digital_wallet15002018-03-09 11:55:41
2982cash68002018-03-09 12:22:29
2983debit_card15002018-03-09 17:34:44
2984credit_card17002018-03-10 10:12:18
2985debit_card15002018-03-10 17:26:06
2986debit_card34002018-03-11 09:18:07
2987credit_card15002018-03-11 10:52:42
2988credit_card30002018-03-12 10:48:33
2989credit_card4002018-03-12 11:44:05
2990digital_wallet60002018-03-12 21:45:22
2991credit_card4002018-03-13 09:32:56
2992credit_card30002018-03-13 23:11:38
2993debit_card30002018-03-14 13:28:41
2994credit_card4002018-03-14 16:29:36
2995credit_card4002018-03-15 05:50:51
2996debit_card34002018-03-15 11:38:28
2997digital_wallet34002018-03-15 13:39:26
2998debit_card8002018-03-15 14:03:42
2999cash8002018-03-15 15:35:14
3000digital_wallet750002018-03-15 16:28:16
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;