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,551–1,575 of 5,412

payment, page 63 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1551credit_card4002016-08-29 22:03:01
1552credit_card75002016-08-31 07:02:43
1553cash17002016-08-31 12:55:49
1554cash34002016-08-31 13:30:49
1555debit_card4002016-09-01 08:41:37
1556credit_card17002016-09-01 09:17:59
1557credit_card60002016-09-01 09:29:35
1558cash51002016-09-01 10:45:48
1559credit_card30002016-09-01 16:06:54
1560credit_card15002016-09-01 16:18:44
1561debit_card34002016-09-02 11:00:41
1562debit_card8002016-09-02 11:36:54
1563credit_card4002016-09-04 10:10:38
1564credit_card17002016-09-04 11:52:15
1565credit_card30002016-09-04 23:22:31
1566credit_card15002016-09-05 09:08:53
1567digital_wallet17002016-09-05 09:35:04
1568debit_card30002016-09-05 17:50:48
1569credit_card15002016-09-06 18:43:42
1570credit_card51002016-09-07 11:07:35
1571credit_card34002016-09-07 12:24:53
1572debit_card45002016-09-08 17:28:09
1573credit_card68002016-09-09 15:15:37
1574cash8002016-09-10 09:54:34
1575credit_card17002016-09-10 13:25:53
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;