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 3,126–3,150 of 5,412

payment, page 126 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3126debit_card15002018-04-20 08:20:18
3127cash34002018-04-20 09:24:46
3128digital_wallet630002018-04-20 14:31:56
3129credit_card4002018-04-20 21:30:10
3130debit_card4002018-04-21 04:06:13
3131debit_card4002018-04-21 10:07:46
3132debit_card4002018-04-21 14:34:39
3133cash34002018-04-21 14:36:26
3134cash8002018-04-21 15:04:32
3135credit_card30002018-04-22 07:18:27
3136debit_card30002018-04-22 08:53:12
3137debit_card30002018-04-22 09:37:19
3138credit_card8002018-04-23 15:50:54
3139digital_wallet30002018-04-24 11:05:57
3140credit_card45002018-04-25 08:01:39
3141credit_card8002018-04-25 11:32:52
3142debit_card34002018-04-25 12:43:37
3143digital_wallet85002018-04-25 14:32:36
3144cash8002018-04-25 14:56:09
3145cash8002018-04-25 14:57:15
3146credit_card15002018-04-26 08:41:22
3147debit_card34002018-04-26 09:25:17
3148credit_card30002018-04-26 14:49:14
3149credit_card30002018-04-26 15:04:29
3150digital_wallet30002018-04-26 15:33:52
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;