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,326–3,350 of 5,412

payment, page 134 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3326credit_card51002018-06-12 15:06:10
3327credit_card8002018-06-12 15:29:21
3328debit_card75002018-06-12 15:42:28
3329credit_card4002018-06-12 21:44:53
3330credit_card75002018-06-13 08:46:10
3331debit_card15002018-06-13 10:11:00
3332debit_card8002018-06-13 12:53:09
3333digital_wallet8002018-06-13 15:12:13
3334debit_card34002018-06-13 15:23:18
3335digital_wallet15002018-06-14 17:30:09
3336credit_card4002018-06-14 21:16:32
3337debit_card15002018-06-15 09:31:46
3338digital_wallet30002018-06-15 09:58:26
3339cash17002018-06-15 10:20:29
3340credit_card8002018-06-15 13:41:27
3341debit_card30002018-06-15 18:00:59
3342digital_wallet30002018-06-15 20:26:57
3343credit_card30002018-06-16 23:17:12
3344digital_wallet60002018-06-17 11:15:40
3345digital_wallet8002018-06-17 12:41:27
3346digital_wallet34002018-06-18 15:48:36
3347credit_card4002018-06-19 04:49:36
3348credit_card34002018-06-19 10:17:09
3349digital_wallet30002018-06-19 15:58:09
3350credit_card30002018-06-19 21:56:07
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;