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,626–2,650 of 5,412

payment, page 106 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2626digital_wallet15002017-10-17 19:49:37
2627debit_card51002017-10-18 14:20:05
2628credit_card30002017-10-18 17:20:48
2629debit_card4002017-10-19 11:15:30
2630credit_card45002017-10-19 14:37:12
2631credit_card60002017-10-19 16:08:49
2632digital_wallet15002017-10-19 18:06:28
2633digital_wallet34002017-10-20 09:07:05
2634credit_card30002017-10-20 22:45:08
2635debit_card17002017-10-21 08:43:45
2636credit_card60002017-10-21 11:55:02
2637credit_card4002017-10-21 12:37:09
2638credit_card45002017-10-21 13:32:34
2639credit_card4002017-10-21 13:44:17
2640cash8002017-10-21 14:58:36
2641credit_card30002017-10-21 15:34:02
2642debit_card4002017-10-21 19:26:12
2643credit_card4002017-10-22 01:00:29
2644cash8002017-10-22 11:51:43
2645cash8002017-10-23 11:50:39
2646cash17002017-10-23 13:43:31
2647debit_card4002017-10-24 00:08:21
2648credit_card4002017-10-24 08:37:15
2649debit_card4002017-10-24 12:42:21
2650credit_card15002017-10-24 20:50:35
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;