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

payment, page 184 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4576debit_card8002019-06-29 10:59:36
4577credit_card4002019-06-29 19:41:12
4578credit_card4002019-06-30 01:40:20
4579credit_card8002019-06-30 10:19:04
4580credit_card30002019-07-01 23:18:34
4581debit_card17002019-07-02 09:23:41
4582digital_wallet8002019-07-02 10:09:19
4583debit_card4002019-07-02 19:42:03
4584credit_card30002019-07-02 21:31:07
4585debit_card4002019-07-02 22:37:27
4586credit_card60002019-07-04 10:05:25
4587digital_wallet34002019-07-04 12:04:19
4588credit_card8002019-07-04 12:49:25
4589digital_wallet8002019-07-04 12:57:25
4590digital_wallet15002019-07-05 08:35:21
4591credit_card465002019-07-05 11:14:26
4592debit_card30002019-07-05 13:14:43
4593credit_card4002019-07-05 14:17:47
4594credit_card4002019-07-05 15:12:21
4595credit_card15002019-07-05 15:40:36
4596credit_card45002019-07-06 10:47:44
4597digital_wallet34002019-07-06 13:36:55
4598credit_card8002019-07-06 14:04:32
4599digital_wallet15002019-07-06 21:39:13
4600credit_card15002019-07-06 22:27: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;