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

payment, page 185 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4601digital_wallet17002019-07-07 09:47:50
4602credit_card17002019-07-07 12:39:49
4603credit_card4002019-07-07 17:09:34
4604credit_card15002019-07-07 19:23:25
4605credit_card15002019-07-07 23:10:09
4606digital_wallet8002019-07-08 09:17:34
4607debit_card15002019-07-08 10:58:01
4608debit_card17002019-07-08 11:04:53
4609debit_card8002019-07-08 11:32:39
4610cash8002019-07-08 15:21:37
4611credit_card30002019-07-09 08:05:02
4612credit_card17002019-07-09 11:21:26
4613credit_card30002019-07-09 15:31:44
4614credit_card30002019-07-09 16:42:18
4615digital_wallet15002019-07-09 23:47:17
4616debit_card4002019-07-10 09:30:26
4617debit_card34002019-07-10 10:30:02
4618debit_card8002019-07-10 10:58:49
4619digital_wallet45002019-07-10 11:00:57
4620debit_card4002019-07-10 14:16:42
4621debit_card60002019-07-10 19:26:46
4622debit_card17002019-07-11 10:19:51
4623digital_wallet17002019-07-11 10:46:09
4624digital_wallet45002019-07-11 11:53:07
4625credit_card30002019-07-11 14:12:59
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;