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–25 of 5,412

payment, page 1 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1debit_card30002015-02-08 10:44:02
2debit_card30002015-02-09 14:11:10
3credit_card30002015-02-13 20:52:51
4credit_card15002015-02-17 12:45:36
5debit_card870002015-02-19 16:08:44
6debit_card30002015-02-28 14:34:41
7digital_wallet60002015-03-01 07:49:56
8debit_card8002015-03-01 10:39:00
9debit_card15002015-03-01 14:52:29
10credit_card4002015-03-02 05:03:32
11debit_card4002015-03-02 05:52:53
12credit_card34002015-03-02 09:58:14
13credit_card15002015-03-02 22:24:08
14credit_card30002015-03-02 23:54:32
15debit_card30002015-03-04 11:27:43
16debit_card15002015-03-05 10:37:01
17cash17002015-03-05 11:36:43
18credit_card15002015-03-05 23:00:21
19debit_card4002015-03-06 05:58:37
20debit_card45002015-03-06 09:58:12
21cash17002015-03-06 10:13:39
22debit_card17002015-03-06 10:38:19
23debit_card34002015-03-06 12:43:40
24credit_card8002015-03-06 13:24:52
25cash17002015-03-07 10:39:25
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;