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 3,726–3,750 of 5,412

payment, page 150 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3726credit_card60002018-09-30 10:55:16
3727credit_card8002018-09-30 11:01:13
3728digital_wallet30002018-09-30 20:09:58
3729credit_card4002018-10-01 12:30:42
3730debit_card585002018-10-01 14:22:44
3731debit_card30002018-10-02 16:02:55
3732digital_wallet15002018-10-02 16:13:22
3733cash34002018-10-03 09:51:43
3734credit_card30002018-10-03 10:40:52
3735debit_card45002018-10-03 11:10:07
3736digital_wallet15002018-10-04 07:12:21
3737credit_card4002018-10-04 21:08:13
3738digital_wallet60002018-10-05 10:19:36
3739credit_card75002018-10-05 13:29:24
3740debit_card15002018-10-05 16:44:29
3741credit_card4002018-10-05 18:26:39
3742debit_card4002018-10-05 21:28:06
3743debit_card4002018-10-05 22:38:58
3744debit_card4002018-10-06 03:44:42
3745credit_card34002018-10-06 09:04:36
3746debit_card8002018-10-06 09:36:09
3747cash17002018-10-06 10:27:20
3748credit_card17002018-10-06 10:36:13
3749credit_card8002018-10-06 10:52:21
3750debit_card4002018-10-06 22:36:09
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;