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,451–3,475 of 5,412

payment, page 139 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3451cash34002018-07-18 11:43:55
3452digital_wallet17002018-07-18 12:12:38
3453digital_wallet34002018-07-18 16:22:02
3454digital_wallet8002018-07-18 17:02:18
3455credit_card15002018-07-18 18:02:37
3456credit_card45002018-07-18 21:14:07
3457credit_card30002018-07-19 08:08:12
3458credit_card30002018-07-19 21:59:12
3459credit_card17002018-07-20 10:40:47
3460cash34002018-07-21 09:20:53
3461credit_card34002018-07-21 09:36:31
3462credit_card34002018-07-21 10:11:21
3463digital_wallet8002018-07-21 12:04:07
3464credit_card17002018-07-21 15:11:57
3465cash8002018-07-21 15:57:29
3466credit_card30002018-07-21 21:30:59
3467credit_card30002018-07-23 21:17:28
3468credit_card30002018-07-24 23:59:05
3469debit_card30002018-07-25 07:45:41
3470debit_card8002018-07-25 12:14:07
3471credit_card75002018-07-25 13:29:32
3472debit_card4002018-07-25 22:51:35
3473debit_card45002018-07-26 11:44:09
3474digital_wallet30002018-07-26 12:12:46
3475cash34002018-07-27 09:42:04
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;