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,701–2,725 of 5,412

payment, page 109 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2701cash34002017-11-22 09:45:16
2702credit_card34002017-11-22 10:00:49
2703credit_card8002017-11-22 10:10:42
2704cash8002017-11-22 10:31:10
2705debit_card30002017-11-22 12:53:40
2706digital_wallet8002017-11-22 14:46:49
2707cash68002017-11-23 12:11:20
2708debit_card34002017-11-23 14:16:35
2709credit_card17002017-11-23 16:20:10
2710credit_card30002017-11-24 18:56:09
2711credit_card4002017-11-24 22:37:56
2712debit_card34002017-11-25 12:23:15
2713cash8002017-11-25 13:05:32
2714credit_card15002017-11-25 14:21:25
2715credit_card30002017-11-25 17:23:18
2716digital_wallet34002017-11-26 14:01:27
2717cash17002017-11-26 15:39:03
2718credit_card4002017-11-27 14:38:59
2719credit_card30002017-11-27 23:39:42
2720debit_card17002017-11-28 13:44:12
2721credit_card4002017-11-28 14:56:51
2722credit_card4002017-11-28 21:54:45
2723credit_card4002017-11-29 01:47:43
2724debit_card17002017-11-29 13:20:18
2725credit_card8002017-11-29 13:34:15
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;