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 651–675 of 5,412

payment, page 27 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
651debit_card8002015-09-20 12:33:09
652credit_card34002015-09-20 14:47:58
653digital_wallet30002015-09-20 20:16:08
654credit_card4002015-09-20 21:01:10
655debit_card17002015-09-22 11:04:00
656digital_wallet8002015-09-22 11:45:41
657cash34002015-09-22 12:07:19
658credit_card15002015-09-22 20:11:54
659cash34002015-09-23 09:49:49
660credit_card8002015-09-23 10:31:33
661credit_card68002015-09-23 11:09:51
662debit_card8002015-09-23 11:45:29
663cash17002015-09-23 12:21:52
664cash8002015-09-23 12:59:17
665credit_card4002015-09-23 16:41:11
666debit_card15002015-09-23 22:09:19
667cash8002015-09-24 10:34:39
668debit_card4002015-09-24 11:14:35
669credit_card765002015-09-24 12:59:00
670cash17002015-09-25 10:21:32
671digital_wallet17002015-09-25 10:41:50
672credit_card4002015-09-25 16:48:14
673debit_card85002015-09-27 10:18:45
674credit_card17002015-09-27 10:46:13
675credit_card34002015-09-27 12:23:37
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;