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,801–2,825 of 5,412

payment, page 113 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2801cash8002018-01-02 10:32:46
2802credit_card8002018-01-02 10:36:55
2803digital_wallet15002018-01-02 16:46:25
2804debit_card15002018-01-03 07:36:20
2805debit_card15002018-01-03 21:30:02
2806digital_wallet75002018-01-04 09:19:29
2807digital_wallet15002018-01-04 10:34:57
2808credit_card60002018-01-04 23:46:15
2809credit_card45002018-01-05 11:20:42
2810debit_card8002018-01-05 12:10:45
2811debit_card8002018-01-06 11:28:35
2812credit_card15002018-01-06 16:10:02
2813credit_card60002018-01-06 23:06:03
2814credit_card15002018-01-06 23:25:29
2815credit_card15002018-01-07 08:59:06
2816digital_wallet8002018-01-07 13:41:15
2817credit_card840002018-01-07 14:35:08
2818credit_card15002018-01-09 07:58:38
2819credit_card34002018-01-09 11:22:43
2820digital_wallet8002018-01-09 11:51:41
2821credit_card17002018-01-10 09:33:27
2822credit_card8002018-01-10 10:29:53
2823credit_card4002018-01-10 11:23:22
2824credit_card30002018-01-10 11:38:12
2825credit_card4002018-01-11 08:32:38
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;