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

payment, page 206 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5126digital_wallet34002019-12-03 08:51:38
5127debit_card8002019-12-03 09:22:07
5128digital_wallet60002019-12-03 12:37:07
5129credit_card4002019-12-03 20:39:21
5130debit_card4002019-12-04 03:08:38
5131debit_card17002019-12-04 09:58:09
5132debit_card60002019-12-04 14:38:17
5133debit_card30002019-12-04 19:04:15
5134debit_card8002019-12-05 09:50:21
5135debit_card8002019-12-05 09:58:10
5136debit_card8002019-12-05 10:03:59
5137digital_wallet30002019-12-05 13:48:37
5138debit_card34002019-12-05 15:11:35
5139credit_card45002019-12-05 16:51:46
5140debit_card30002019-12-06 13:40:36
5141debit_card4002019-12-06 13:59:04
5142credit_card30002019-12-06 21:51:34
5143credit_card4002019-12-07 05:51:17
5144debit_card4002019-12-07 10:40:37
5145cash34002019-12-07 10:46:25
5146credit_card45002019-12-07 11:29:50
5147cash8002019-12-07 12:16:38
5148credit_card30002019-12-07 23:45:20
5149debit_card8002019-12-08 09:36:42
5150credit_card8002019-12-08 10:53:47
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;