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,176–3,200 of 5,412

payment, page 128 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3176credit_card15002018-05-05 07:52:12
3177digital_wallet34002018-05-05 09:32:51
3178debit_card8002018-05-05 09:50:00
3179digital_wallet34002018-05-05 09:52:58
3180credit_card8002018-05-05 10:30:09
3181credit_card4002018-05-05 12:37:32
3182credit_card34002018-05-06 09:24:34
3183debit_card68002018-05-06 09:32:44
3184credit_card8002018-05-06 10:06:45
3185debit_card8002018-05-06 10:27:40
3186credit_card15002018-05-06 13:42:28
3187credit_card30002018-05-08 10:21:00
3188cash17002018-05-08 11:01:12
3189debit_card15002018-05-08 11:47:34
3190cash17002018-05-09 13:24:03
3191debit_card465002018-05-10 09:59:42
3192digital_wallet30002018-05-10 12:29:48
3193credit_card15002018-05-10 21:50:12
3194debit_card60002018-05-11 17:58:54
3195credit_card4002018-05-12 08:42:20
3196credit_card45002018-05-12 09:12:29
3197credit_card34002018-05-12 11:27:25
3198credit_card60002018-05-12 11:40:52
3199credit_card30002018-05-12 13:27:23
3200credit_card34002018-05-12 15:30:19
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;