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 501–525 of 5,412

payment, page 21 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
501credit_card4002015-08-07 20:16:55
502debit_card45002015-08-08 08:30:27
503debit_card4002015-08-08 17:00:19
504digital_wallet34002015-08-09 13:54:16
505credit_card60002015-08-09 22:08:59
506digital_wallet34002015-08-10 09:24:29
507cash8002015-08-10 09:50:25
508credit_card17002015-08-10 12:25:20
509cash8002015-08-10 13:03:06
510credit_card45002015-08-11 10:12:36
511credit_card17002015-08-11 13:49:11
512credit_card30002015-08-11 19:57:50
513credit_card30002015-08-11 22:29:19
514credit_card4002015-08-12 05:24:55
515credit_card34002015-08-12 09:59:38
516debit_card30002015-08-12 12:25:31
517debit_card4002015-08-12 14:58:24
518cash34002015-08-12 15:39:12
519cash8002015-08-12 16:05:27
520debit_card4002015-08-13 04:15:22
521credit_card45002015-08-13 08:32:44
522debit_card4002015-08-13 08:47:42
523debit_card60002015-08-13 09:22:07
524credit_card15002015-08-13 11:07:10
525credit_card4002015-08-13 15:52:58
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;