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,301–3,325 of 5,412

payment, page 133 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3301debit_card30002018-06-05 07:28:10
3302debit_card60002018-06-06 07:00:49
3303debit_card4002018-06-06 11:59:42
3304credit_card60002018-06-06 16:57:24
3305credit_card15002018-06-06 18:04:41
3306credit_card45002018-06-06 18:44:35
3307cash34002018-06-07 10:23:44
3308credit_card17002018-06-07 13:01:51
3309credit_card4002018-06-07 19:17:38
3310credit_card30002018-06-08 07:34:02
3311credit_card15002018-06-08 11:18:39
3312debit_card825002018-06-08 13:27:02
3313credit_card4002018-06-09 01:21:00
3314credit_card8002018-06-09 13:50:03
3315debit_card8002018-06-09 13:58:52
3316debit_card15002018-06-10 07:07:55
3317digital_wallet34002018-06-10 10:46:23
3318debit_card45002018-06-10 10:59:34
3319debit_card17002018-06-10 12:26:28
3320cash8002018-06-10 12:58:04
3321digital_wallet15002018-06-10 14:46:17
3322digital_wallet30002018-06-10 22:57:47
3323credit_card15002018-06-11 13:47:50
3324credit_card30002018-06-11 14:11:59
3325debit_card17002018-06-12 14:33: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;