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,576–1,600 of 5,412

payment, page 64 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1576credit_card8002016-09-11 11:21:46
1577credit_card8002016-09-11 11:31:24
1578debit_card15002016-09-11 17:12:17
1579cash34002016-09-12 11:11:58
1580credit_card15002016-09-12 22:37:35
1581digital_wallet30002016-09-12 23:14:50
1582credit_card30002016-09-12 23:35:03
1583credit_card4002016-09-13 02:06:06
1584credit_card17002016-09-13 09:34:33
1585credit_card17002016-09-13 14:25:15
1586credit_card4002016-09-13 18:36:49
1587debit_card4002016-09-14 02:21:14
1588cash17002016-09-15 14:25:24
1589credit_card4002016-09-17 05:20:48
1590credit_card8002016-09-17 16:43:34
1591credit_card30002016-09-17 18:00:29
1592credit_card30002016-09-17 20:44:28
1593debit_card17002016-09-18 09:54:22
1594debit_card4002016-09-19 03:44:22
1595credit_card51002016-09-19 12:20:55
1596debit_card15002016-09-19 13:39:59
1597credit_card51002016-09-19 16:01:36
1598credit_card4002016-09-19 21:19:59
1599debit_card8002016-09-20 09:51:40
1600debit_card15002016-09-20 16:52:55
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;