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 3,751–3,775 of 5,412

payment, page 151 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3751debit_card30002018-10-07 09:32:00
3752digital_wallet30002018-10-07 09:38:28
3753credit_card51002018-10-07 12:00:33
3754credit_card8002018-10-07 12:18:04
3755debit_card34002018-10-07 14:14:36
3756credit_card8002018-10-07 14:56:29
3757cash8002018-10-07 16:22:11
3758credit_card4002018-10-08 09:42:53
3759credit_card34002018-10-09 09:34:57
3760credit_card17002018-10-09 09:45:31
3761credit_card51002018-10-09 12:24:02
3762credit_card8002018-10-09 12:52:46
3763cash8002018-10-09 13:03:59
3764cash8002018-10-10 17:03:19
3765credit_card4002018-10-11 07:49:39
3766digital_wallet17002018-10-11 10:39:32
3767credit_card34002018-10-11 11:36:30
3768cash17002018-10-12 09:01:02
3769cash85002018-10-13 11:58:59
3770debit_card30002018-10-13 13:12:03
3771cash34002018-10-13 13:41:26
3772cash34002018-10-14 09:53:09
3773credit_card8002018-10-14 10:26:29
3774debit_card30002018-10-14 21:02:05
3775digital_wallet15002018-10-15 08:01:31
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;