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,201–3,225 of 5,412

payment, page 129 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3201credit_card8002018-05-12 16:05:37
3202credit_card4002018-05-13 09:31:09
3203credit_card34002018-05-13 09:43:43
3204cash8002018-05-13 09:48:59
3205cash8002018-05-13 10:17:09
3206digital_wallet34002018-05-13 10:22:50
3207debit_card8002018-05-13 12:22:36
3208credit_card8002018-05-13 12:23:55
3209credit_card17002018-05-13 12:32:11
3210cash17002018-05-13 12:42:35
3211credit_card75002018-05-13 18:48:34
3212debit_card60002018-05-13 23:45:57
3213digital_wallet30002018-05-14 07:25:50
3214credit_card4002018-05-15 03:14:03
3215credit_card68002018-05-15 09:36:22
3216credit_card68002018-05-15 09:54:46
3217debit_card8002018-05-15 10:26:15
3218credit_card30002018-05-15 16:33:01
3219debit_card4002018-05-16 08:38:08
3220credit_card30002018-05-16 09:46:15
3221debit_card8002018-05-16 11:18:23
3222cash8002018-05-16 11:28:25
3223cash8002018-05-16 11:50:16
3224credit_card15002018-05-16 19:09:03
3225cash68002018-05-17 10:54:25
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;