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,676–2,700 of 5,412

payment, page 108 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2676credit_card34002017-11-07 11:26:02
2677credit_card30002017-11-09 14:05:26
2678debit_card4002017-11-10 03:33:24
2679credit_card17002017-11-10 08:50:13
2680credit_card15002017-11-11 14:51:07
2681cash17002017-11-12 10:09:50
2682debit_card34002017-11-13 09:49:24
2683credit_card4002017-11-14 01:25:10
2684credit_card30002017-11-14 23:03:08
2685debit_card4002017-11-15 06:58:29
2686credit_card68002017-11-17 11:44:47
2687credit_card30002017-11-17 17:51:16
2688debit_card4002017-11-17 22:05:19
2689digital_wallet8002017-11-18 10:21:46
2690credit_card15002017-11-18 17:24:38
2691credit_card15002017-11-18 18:45:09
2692credit_card30002017-11-19 13:26:46
2693credit_card4002017-11-20 05:23:02
2694credit_card45002017-11-20 15:49:17
2695credit_card15002017-11-20 15:49:26
2696credit_card30002017-11-20 23:20:58
2697debit_card8002017-11-21 09:54:18
2698digital_wallet34002017-11-21 10:51:29
2699debit_card4002017-11-21 16:12:00
2700digital_wallet68002017-11-22 09:21:13
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;