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,776–3,800 of 5,412

payment, page 152 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3776cash17002018-10-15 13:29:00
3777debit_card8002018-10-15 15:31:27
3778debit_card4002018-10-15 21:32:02
3779digital_wallet15002018-10-16 15:39:18
3780credit_card4002018-10-16 20:21:20
3781credit_card30002018-10-17 17:32:02
3782debit_card17002018-10-18 13:56:22
3783digital_wallet8002018-10-18 14:23:18
3784debit_card30002018-10-18 14:56:11
3785credit_card30002018-10-18 22:43:36
3786debit_card4002018-10-18 23:51:57
3787credit_card4002018-10-19 05:52:22
3788debit_card4002018-10-19 10:51:43
3789digital_wallet30002018-10-19 13:52:20
3790debit_card4002018-10-19 14:00:47
3791credit_card15002018-10-19 16:51:09
3792credit_card15002018-10-19 16:54:55
3793credit_card4002018-10-19 18:47:07
3794digital_wallet8002018-10-20 12:41:45
3795credit_card4002018-10-20 18:14:37
3796cash17002018-10-21 14:42:02
3797credit_card15002018-10-21 15:31:45
3798credit_card60002018-10-22 08:32:01
3799debit_card4002018-10-22 21:25:22
3800credit_card4002018-10-23 10:38:42
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;