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 3,676–3,700 of 5,412

payment, page 148 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3676credit_card34002018-09-17 11:06:08
3677cash8002018-09-17 11:27:25
3678credit_card8002018-09-17 11:36:25
3679credit_card30002018-09-17 21:13:30
3680cash8002018-09-18 11:56:07
3681credit_card15002018-09-18 12:58:23
3682credit_card68002018-09-18 15:43:26
3683credit_card8002018-09-18 16:05:58
3684credit_card45002018-09-18 18:04:05
3685cash8002018-09-19 12:02:16
3686credit_card8002018-09-19 12:10:33
3687debit_card4002018-09-20 02:14:07
3688credit_card30002018-09-20 08:35:42
3689debit_card15002018-09-20 21:24:58
3690credit_card30002018-09-20 22:24:40
3691digital_wallet30002018-09-23 13:01:34
3692credit_card30002018-09-23 13:20:30
3693credit_card51002018-09-23 13:47:07
3694credit_card8002018-09-23 14:15:30
3695credit_card8002018-09-23 14:16:56
3696debit_card45002018-09-23 18:30:14
3697debit_card15002018-09-24 12:16:32
3698debit_card30002018-09-24 22:26:39
3699credit_card85002018-09-25 10:17:20
3700debit_card8002018-09-25 11:15:33
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;