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,776–2,800 of 5,412

payment, page 112 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2776credit_card30002017-12-20 16:14:34
2777debit_card4002017-12-20 22:29:00
2778debit_card75002017-12-21 17:39:56
2779credit_card30002017-12-23 09:34:21
2780cash85002017-12-23 10:29:41
2781debit_card30002017-12-23 15:07:24
2782credit_card34002017-12-24 09:52:08
2783debit_card8002017-12-24 14:04:11
2784debit_card30002017-12-25 12:03:53
2785debit_card15002017-12-26 08:56:30
2786debit_card585002017-12-27 08:01:09
2787credit_card34002017-12-27 09:38:13
2788debit_card4002017-12-27 12:47:51
2789credit_card4002017-12-27 23:19:25
2790credit_card17002017-12-28 13:43:10
2791cash8002017-12-30 12:09:29
2792digital_wallet8002017-12-30 12:12:21
2793debit_card30002017-12-30 21:29:29
2794credit_card15002017-12-31 12:16:25
2795debit_card4002017-12-31 13:23:28
2796credit_card15002017-12-31 16:17:33
2797digital_wallet17002018-01-01 11:54:42
2798debit_card30002018-01-01 13:36:53
2799credit_card4002018-01-02 10:02:20
2800digital_wallet34002018-01-02 10:12:08
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;