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,601–2,625 of 5,412

payment, page 105 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2601credit_card15002017-10-02 17:06:54
2602debit_card30002017-10-03 17:11:36
2603credit_card15002017-10-04 07:44:08
2604credit_card15002017-10-05 09:38:40
2605debit_card30002017-10-05 16:34:11
2606credit_card17002017-10-07 10:21:13
2607digital_wallet60002017-10-07 21:03:43
2608cash17002017-10-09 16:15:41
2609credit_card60002017-10-09 23:13:38
2610cash34002017-10-10 08:37:32
2611credit_card17002017-10-10 10:13:08
2612digital_wallet8002017-10-10 16:00:23
2613credit_card17002017-10-11 10:58:46
2614credit_card4002017-10-12 07:26:46
2615debit_card17002017-10-12 09:53:05
2616debit_card30002017-10-13 12:51:50
2617credit_card4002017-10-13 22:16:58
2618debit_card17002017-10-14 14:22:36
2619debit_card4002017-10-15 06:02:43
2620debit_card51002017-10-15 12:48:26
2621cash8002017-10-15 13:16:41
2622cash17002017-10-15 13:51:44
2623credit_card15002017-10-15 14:39:51
2624cash85002017-10-17 16:03:24
2625debit_card15002017-10-17 17:10:07
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;