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,826–1,850 of 5,412

payment, page 74 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1826debit_card4002016-12-31 01:36:55
1827debit_card15002016-12-31 12:30:22
1828credit_card8002016-12-31 13:08:54
1829credit_card8002016-12-31 13:16:05
1830debit_card15002016-12-31 22:28:33
1831credit_card30002017-01-01 11:04:00
1832credit_card15002017-01-02 08:40:39
1833debit_card15002017-01-04 07:00:42
1834credit_card4002017-01-04 18:28:34
1835credit_card17002017-01-05 10:30:20
1836credit_card600002017-01-05 12:27:04
1837debit_card45002017-01-06 10:13:39
1838debit_card4002017-01-06 14:50:39
1839credit_card8002017-01-07 09:35:31
1840credit_card8002017-01-07 11:20:18
1841cash51002017-01-07 11:28:52
1842debit_card17002017-01-07 15:00:08
1843cash34002017-01-08 11:55:06
1844debit_card4002017-01-08 12:58:33
1845credit_card4002017-01-09 16:21:22
1846credit_card8002017-01-10 12:10:21
1847credit_card4002017-01-10 14:14:24
1848digital_wallet34002017-01-10 16:00:58
1849debit_card15002017-01-10 22:51:47
1850credit_card4002017-01-11 08:42:13
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;