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 1,376–1,400 of 5,412

payment, page 56 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1376credit_card15002016-07-08 16:50:31
1377credit_card34002016-07-09 08:52:26
1378digital_wallet45002016-07-09 12:19:04
1379credit_card4002016-07-11 09:24:08
1380debit_card34002016-07-11 10:35:58
1381digital_wallet68002016-07-11 10:54:39
1382cash34002016-07-11 11:04:49
1383credit_card8002016-07-11 11:29:37
1384cash34002016-07-11 14:14:50
1385digital_wallet15002016-07-11 23:22:32
1386credit_card4002016-07-12 08:24:05
1387credit_card34002016-07-12 11:43:35
1388credit_card60002016-07-12 19:25:59
1389debit_card30002016-07-13 07:31:51
1390credit_card30002016-07-13 10:54:37
1391debit_card34002016-07-14 10:00:16
1392credit_card51002016-07-14 16:00:56
1393debit_card15002016-07-15 07:24:13
1394credit_card45002016-07-15 07:32:58
1395debit_card30002016-07-15 08:16:53
1396cash34002016-07-15 09:36:54
1397cash8002016-07-15 10:26:14
1398credit_card8002016-07-15 15:00:38
1399debit_card4002016-07-15 21:33:59
1400debit_card85002016-07-16 08:57:07
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;