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 826–850 of 5,412

payment, page 34 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
826credit_card30002015-11-27 19:51:45
827credit_card30002015-11-27 20:32:27
828credit_card8002015-11-28 16:02:00
829credit_card17002015-11-29 10:14:55
830credit_card34002015-11-29 10:28:52
831credit_card4002015-11-29 11:11:08
832credit_card8002015-11-29 11:25:30
833debit_card4002015-11-29 20:30:01
834cash34002015-11-30 12:38:42
835cash17002015-11-30 14:42:31
836credit_card30002015-12-01 08:57:01
837credit_card75002015-12-01 19:27:01
838credit_card15002015-12-01 19:40:44
839debit_card30002015-12-02 07:56:43
840cash17002015-12-02 14:46:53
841cash34002015-12-03 12:10:20
842credit_card45002015-12-04 08:59:53
843credit_card8002015-12-04 10:12:26
844credit_card8002015-12-04 10:14:54
845cash17002015-12-04 10:38:03
846digital_wallet17002015-12-04 11:31:27
847debit_card34002015-12-04 14:28:02
848credit_card34002015-12-05 11:23:02
849cash8002015-12-05 12:01:13
850credit_card4002015-12-06 07:46:03
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;