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 601–625 of 5,412

payment, page 25 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
601digital_wallet30002015-08-31 13:09:33
602cash17002015-09-01 11:35:26
603debit_card4002015-09-02 02:54:55
604cash34002015-09-02 12:16:14
605credit_card8002015-09-02 16:42:54
606cash8002015-09-03 11:04:24
607credit_card8002015-09-03 11:08:33
608credit_card4002015-09-03 15:07:33
609credit_card17002015-09-04 09:35:13
610cash8002015-09-04 10:19:22
611debit_card8002015-09-04 12:01:06
612cash17002015-09-05 11:18:15
613debit_card17002015-09-05 13:52:47
614credit_card8002015-09-05 14:12:23
615debit_card8002015-09-05 14:23:22
616debit_card30002015-09-05 17:15:36
617debit_card34002015-09-07 14:30:42
618debit_card8002015-09-07 14:57:36
619credit_card8002015-09-08 15:01:35
620cash34002015-09-09 16:29:20
621credit_card4002015-09-10 13:05:06
622credit_card60002015-09-10 18:53:23
623cash17002015-09-11 09:08:53
624credit_card30002015-09-11 10:29:45
625credit_card51002015-09-11 12:01:13
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;