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,551–3,575 of 5,412

payment, page 143 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3551digital_wallet15002018-08-10 10:13:53
3552credit_card60002018-08-10 10:20:51
3553debit_card17002018-08-10 13:05:23
3554debit_card17002018-08-10 13:49:55
3555cash8002018-08-10 13:57:45
3556credit_card30002018-08-10 17:56:04
3557digital_wallet30002018-08-10 22:49:30
3558credit_card4002018-08-11 02:19:28
3559debit_card4002018-08-11 08:21:24
3560debit_card8002018-08-11 11:08:09
3561debit_card17002018-08-11 11:15:09
3562digital_wallet8002018-08-11 11:54:54
3563credit_card4002018-08-11 16:25:26
3564digital_wallet15002018-08-11 20:24:06
3565debit_card75002018-08-11 21:37:28
3566digital_wallet34002018-08-12 09:57:31
3567credit_card8002018-08-12 13:55:11
3568credit_card8002018-08-12 15:19:57
3569debit_card8002018-08-12 15:45:10
3570credit_card30002018-08-12 16:25:38
3571credit_card34002018-08-13 11:21:22
3572digital_wallet15002018-08-13 11:53:26
3573credit_card8002018-08-13 11:58:18
3574credit_card4002018-08-14 00:13:34
3575credit_card30002018-08-14 07:23:16
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;