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,926–2,950 of 5,412

payment, page 118 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2926debit_card4002018-02-16 07:24:51
2927credit_card34002018-02-16 13:42:16
2928credit_card30002018-02-16 19:43:06
2929digital_wallet17002018-02-17 13:50:59
2930credit_card30002018-02-17 17:05:23
2931credit_card15002018-02-17 19:55:16
2932digital_wallet30002018-02-18 11:59:56
2933debit_card34002018-02-18 15:20:36
2934digital_wallet8002018-02-18 15:55:53
2935credit_card8002018-02-18 16:03:06
2936credit_card4002018-02-19 04:42:45
2937digital_wallet30002018-02-19 08:53:51
2938credit_card15002018-02-19 11:46:16
2939debit_card4002018-02-20 07:50:18
2940credit_card15002018-02-21 13:07:03
2941credit_card8002018-02-21 16:48:48
2942credit_card45002018-02-21 16:57:55
2943cash8002018-02-22 10:18:29
2944credit_card17002018-02-22 10:39:07
2945credit_card45002018-02-22 18:55:53
2946credit_card45002018-02-23 08:22:11
2947credit_card34002018-02-23 12:03:59
2948debit_card15002018-02-23 15:11:31
2949debit_card4002018-02-23 23:00:32
2950credit_card4002018-02-24 07:58:01
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;