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

payment, page 154 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3826credit_card15002018-10-31 10:02:42
3827digital_wallet17002018-10-31 10:29:14
3828digital_wallet780002018-10-31 11:16:25
3829debit_card34002018-10-31 15:05:00
3830debit_card15002018-10-31 20:32:31
3831credit_card4002018-11-01 12:08:35
3832credit_card15002018-11-01 14:17:58
3833credit_card8002018-11-02 10:29:27
3834credit_card8002018-11-02 10:30:52
3835debit_card30002018-11-02 13:31:57
3836credit_card4002018-11-03 14:45:07
3837credit_card60002018-11-03 15:18:43
3838debit_card45002018-11-03 18:58:24
3839credit_card4002018-11-03 20:04:02
3840debit_card45002018-11-04 09:19:28
3841cash17002018-11-04 09:55:23
3842debit_card15002018-11-04 15:29:41
3843debit_card51002018-11-05 12:25:43
3844debit_card8002018-11-05 13:06:45
3845cash8002018-11-05 13:12:29
3846cash34002018-11-05 14:20:10
3847credit_card8002018-11-05 14:41:20
3848cash51002018-11-06 12:51:40
3849debit_card45002018-11-07 22:28:39
3850debit_card60002018-11-09 11:27:02
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;