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,601–3,625 of 5,412

payment, page 145 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3601credit_card30002018-08-22 09:25:49
3602credit_card68002018-08-22 09:39:56
3603credit_card8002018-08-22 09:59:27
3604debit_card15002018-08-22 22:03:21
3605credit_card45002018-08-22 23:26:39
3606credit_card15002018-08-23 07:24:53
3607credit_card8002018-08-23 09:50:22
3608debit_card540002018-08-23 12:07:49
3609debit_card34002018-08-23 12:21:16
3610digital_wallet45002018-08-23 19:02:32
3611credit_card4002018-08-24 03:08:55
3612credit_card15002018-08-24 14:45:56
3613digital_wallet15002018-08-24 19:41:53
3614debit_card8002018-08-25 10:34:15
3615credit_card15002018-08-25 11:34:43
3616credit_card34002018-08-25 12:55:16
3617credit_card8002018-08-25 16:11:48
3618credit_card8002018-08-26 14:32:22
3619credit_card30002018-08-26 16:41:08
3620cash17002018-08-27 09:58:32
3621cash8002018-08-27 10:40:16
3622credit_card17002018-08-27 15:36:08
3623credit_card45002018-08-28 11:23:26
3624credit_card30002018-08-28 13:20:16
3625debit_card17002018-08-29 11:15:00
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;