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

payment, page 110 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2726debit_card60002017-11-29 18:13:05
2727debit_card15002017-11-29 18:31:48
2728debit_card4002017-11-30 21:58:39
2729credit_card68002017-12-01 11:54:53
2730credit_card8002017-12-01 12:03:04
2731debit_card8002017-12-01 12:26:21
2732debit_card15002017-12-01 23:50:44
2733digital_wallet30002017-12-01 23:58:30
2734digital_wallet30002017-12-02 10:14:46
2735debit_card4002017-12-03 11:00:24
2736credit_card45002017-12-04 12:21:14
2737debit_card4002017-12-05 02:15:56
2738debit_card30002017-12-05 16:31:18
2739debit_card4002017-12-06 12:13:02
2740credit_card4002017-12-08 09:16:13
2741digital_wallet51002017-12-08 11:39:57
2742credit_card15002017-12-08 18:30:09
2743debit_card8002017-12-09 12:08:01
2744cash8002017-12-09 12:13:40
2745credit_card4002017-12-09 22:36:54
2746credit_card4002017-12-10 03:27:41
2747credit_card45002017-12-10 09:44:39
2748cash8002017-12-10 11:07:16
2749debit_card15002017-12-10 13:24:01
2750credit_card68002017-12-10 15:57:38
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;