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,576–3,600 of 5,412

payment, page 144 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3576digital_wallet8002018-08-14 11:39:05
3577debit_card30002018-08-15 08:04:36
3578credit_card4002018-08-15 12:00:27
3579digital_wallet60002018-08-15 22:04:42
3580debit_card15002018-08-16 11:32:56
3581credit_card45002018-08-17 08:31:53
3582credit_card8002018-08-17 10:14:57
3583credit_card68002018-08-17 11:10:22
3584credit_card17002018-08-17 11:10:54
3585credit_card15002018-08-17 15:55:37
3586credit_card60002018-08-17 18:59:11
3587debit_card8002018-08-18 10:51:01
3588credit_card45002018-08-18 11:59:22
3589credit_card34002018-08-18 15:38:52
3590debit_card15002018-08-18 15:48:10
3591digital_wallet17002018-08-19 09:00:47
3592credit_card51002018-08-19 10:46:18
3593debit_card34002018-08-19 12:30:25
3594digital_wallet8002018-08-19 15:40:21
3595debit_card8002018-08-19 15:52:09
3596credit_card30002018-08-19 19:08:49
3597cash34002018-08-20 12:43:40
3598credit_card4002018-08-21 00:40:15
3599debit_card34002018-08-21 09:24:47
3600credit_card4002018-08-22 01:00:35
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;