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

payment, page 29 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
701credit_card30002015-10-05 12:42:49
702digital_wallet30002015-10-05 19:09:33
703debit_card4002015-10-06 06:06:20
704credit_card4002015-10-06 16:40:05
705credit_card4002015-10-08 10:43:46
706credit_card4002015-10-09 09:33:46
707debit_card17002015-10-10 10:02:04
708credit_card4002015-10-10 22:48:54
709debit_card60002015-10-11 09:39:03
710credit_card51002015-10-11 11:35:35
711credit_card8002015-10-11 12:17:02
712debit_card30002015-10-11 20:44:33
713credit_card68002015-10-12 14:22:07
714cash34002015-10-12 15:37:38
715debit_card4002015-10-12 22:51:15
716debit_card4002015-10-12 23:57:34
717debit_card34002015-10-13 13:20:28
718credit_card4002015-10-13 15:30:20
719cash51002015-10-14 11:34:00
720credit_card30002015-10-14 18:21:17
721credit_card30002015-10-14 22:20:51
722credit_card17002015-10-15 09:25:59
723debit_card17002015-10-15 11:53:59
724digital_wallet8002015-10-15 12:14:53
725credit_card34002015-10-16 10:52: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;