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,701–3,725 of 5,412

payment, page 149 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3701credit_card17002018-09-25 12:25:22
3702credit_card34002018-09-25 14:30:57
3703digital_wallet15002018-09-25 22:18:29
3704digital_wallet30002018-09-26 07:03:11
3705credit_card68002018-09-26 08:28:04
3706credit_card8002018-09-26 09:08:41
3707credit_card8002018-09-26 09:57:14
3708credit_card8002018-09-26 10:50:48
3709credit_card17002018-09-26 11:15:43
3710debit_card8002018-09-26 11:48:51
3711debit_card4002018-09-26 14:35:20
3712credit_card4002018-09-26 23:49:48
3713credit_card15002018-09-27 09:56:26
3714debit_card8002018-09-27 11:01:52
3715debit_card30002018-09-27 20:08:48
3716digital_wallet34002018-09-28 13:59:01
3717cash8002018-09-28 14:39:46
3718debit_card15002018-09-28 18:40:42
3719debit_card4002018-09-29 03:13:57
3720credit_card30002018-09-29 07:48:40
3721credit_card30002018-09-29 11:57:52
3722debit_card30002018-09-29 18:39:17
3723credit_card4002018-09-29 22:59:03
3724debit_card15002018-09-29 23:46:30
3725debit_card4002018-09-30 04:01:05
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;