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,276–4,300 of 5,412

payment, page 172 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4276debit_card4002019-04-06 00:27:14
4277credit_card17002019-04-06 09:10:22
4278debit_card17002019-04-06 09:32:50
4279digital_wallet8002019-04-06 09:51:43
4280digital_wallet34002019-04-07 09:26:24
4281credit_card4002019-04-07 10:08:59
4282debit_card8002019-04-07 10:14:36
4283cash8002019-04-07 11:26:23
4284credit_card4002019-04-08 08:26:23
4285digital_wallet30002019-04-08 08:32:48
4286digital_wallet15002019-04-08 09:02:32
4287digital_wallet30002019-04-08 09:10:50
4288debit_card4002019-04-08 09:18:15
4289debit_card570002019-04-08 09:47:59
4290debit_card8002019-04-08 09:53:38
4291credit_card34002019-04-08 11:48:24
4292credit_card15002019-04-09 09:55:20
4293credit_card51002019-04-09 11:55:52
4294credit_card34002019-04-09 15:37:10
4295debit_card30002019-04-09 16:50:14
4296credit_card17002019-04-11 10:18:10
4297digital_wallet30002019-04-12 07:49:15
4298debit_card4002019-04-12 08:00:24
4299cash34002019-04-12 09:59:53
4300cash17002019-04-12 13:09:08
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;