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,826–2,850 of 5,412

payment, page 114 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2826debit_card15002018-01-11 09:05:23
2827debit_card30002018-01-11 09:09:07
2828credit_card30002018-01-11 11:38:43
2829debit_card8002018-01-11 12:12:01
2830credit_card30002018-01-11 13:10:41
2831credit_card4002018-01-12 04:55:49
2832credit_card30002018-01-12 07:22:27
2833digital_wallet34002018-01-12 09:07:36
2834digital_wallet34002018-01-12 14:34:51
2835debit_card8002018-01-12 15:03:34
2836credit_card60002018-01-12 19:01:26
2837debit_card4002018-01-12 23:03:23
2838credit_card4002018-01-13 10:36:18
2839credit_card30002018-01-13 21:17:03
2840credit_card30002018-01-14 19:40:55
2841cash8002018-01-15 10:43:12
2842credit_card4002018-01-16 06:25:25
2843debit_card750002018-01-16 10:48:15
2844debit_card8002018-01-16 13:27:05
2845debit_card17002018-01-17 12:33:31
2846debit_card4002018-01-17 20:28:11
2847debit_card51002018-01-18 10:13:35
2848credit_card8002018-01-18 12:06:35
2849cash8002018-01-18 12:10:47
2850credit_card4002018-01-18 17:15:31
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;