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,626–1,650 of 5,412

payment, page 66 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1626credit_card30002016-09-30 15:59:19
1627credit_card8002016-10-01 10:40:40
1628credit_card4002016-10-02 10:57:15
1629credit_card15002016-10-02 11:39:40
1630digital_wallet15002016-10-02 16:16:04
1631credit_card4002016-10-02 18:37:18
1632credit_card60002016-10-03 11:55:35
1633debit_card45002016-10-04 22:53:04
1634debit_card8002016-10-05 11:38:01
1635debit_card68002016-10-06 11:58:59
1636cash8002016-10-06 12:42:38
1637debit_card34002016-10-07 14:35:08
1638debit_card45002016-10-07 20:16:05
1639credit_card34002016-10-08 08:41:39
1640debit_card8002016-10-08 09:26:03
1641credit_card45002016-10-08 10:00:33
1642credit_card30002016-10-08 11:22:37
1643credit_card68002016-10-09 08:49:28
1644debit_card8002016-10-09 09:18:30
1645credit_card60002016-10-10 22:07:36
1646debit_card75002016-10-11 10:04:11
1647cash68002016-10-11 10:20:18
1648credit_card45002016-10-11 19:28:41
1649debit_card4002016-10-13 00:24:39
1650debit_card30002016-10-14 15:08:02
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;