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 751–775 of 5,412

payment, page 31 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
751debit_card30002015-10-28 12:33:59
752debit_card15002015-10-28 21:34:03
753debit_card4002015-10-29 07:13:32
754credit_card4002015-10-30 00:01:11
755debit_card17002015-10-30 11:42:11
756debit_card4002015-10-30 18:26:09
757credit_card15002015-10-31 07:41:09
758cash34002015-10-31 09:33:03
759cash85002015-10-31 09:50:36
760cash34002015-10-31 09:55:23
761cash8002015-10-31 10:27:47
762credit_card8002015-10-31 10:32:06
763cash8002015-10-31 10:32:29
764credit_card15002015-10-31 12:51:30
765debit_card4002015-11-01 20:37:49
766credit_card15002015-11-01 23:35:15
767digital_wallet15002015-11-02 08:28:17
768debit_card630002015-11-02 16:16:12
769credit_card15002015-11-02 20:37:39
770credit_card15002015-11-03 09:51:19
771credit_card8002015-11-03 10:49:43
772debit_card30002015-11-03 16:58:36
773digital_wallet17002015-11-04 10:14:16
774debit_card45002015-11-06 15:12:08
775credit_card4002015-11-06 15:32:41
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;