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,951–2,975 of 5,412

payment, page 119 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2951cash34002018-02-24 10:42:42
2952credit_card17002018-02-24 10:49:01
2953credit_card34002018-02-24 11:05:07
2954credit_card8002018-02-24 11:57:31
2955debit_card15002018-02-25 07:39:33
2956credit_card60002018-02-25 08:11:17
2957credit_card45002018-02-26 08:16:52
2958credit_card60002018-02-26 14:56:11
2959credit_card8002018-02-26 15:11:22
2960credit_card17002018-02-27 09:00:39
2961credit_card4002018-02-28 05:36:56
2962credit_card15002018-03-01 09:03:30
2963debit_card34002018-03-01 09:55:22
2964debit_card4002018-03-01 20:34:50
2965credit_card4002018-03-02 04:06:29
2966debit_card30002018-03-02 08:21:11
2967credit_card4002018-03-03 05:58:21
2968debit_card15002018-03-03 12:05:19
2969debit_card8002018-03-04 09:25:24
2970credit_card8002018-03-04 09:36:34
2971credit_card4002018-03-04 19:15:17
2972digital_wallet60002018-03-05 10:27:47
2973digital_wallet45002018-03-05 16:39:21
2974debit_card4002018-03-05 18:33:56
2975credit_card4002018-03-06 17:16:02
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;