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,951–3,975 of 5,412

payment, page 159 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3951debit_card4002018-12-08 00:10:16
3952credit_card4002018-12-09 03:16:53
3953credit_card15002018-12-09 08:26:34
3954credit_card34002018-12-09 10:11:32
3955debit_card4002018-12-09 13:00:43
3956credit_card30002018-12-10 11:46:15
3957credit_card4002018-12-10 19:00:58
3958credit_card4002018-12-11 01:39:20
3959cash17002018-12-11 09:09:52
3960digital_wallet8002018-12-11 09:49:45
3961credit_card15002018-12-11 11:30:28
3962debit_card30002018-12-11 18:37:16
3963debit_card34002018-12-12 10:09:58
3964debit_card30002018-12-12 11:30:39
3965credit_card8002018-12-12 12:16:25
3966credit_card30002018-12-13 18:13:50
3967credit_card60002018-12-13 19:13:24
3968credit_card30002018-12-14 07:44:28
3969credit_card34002018-12-14 10:32:41
3970debit_card8002018-12-14 11:08:07
3971debit_card51002018-12-14 11:16:22
3972credit_card8002018-12-14 12:06:07
3973debit_card4002018-12-15 04:19:35
3974debit_card60002018-12-15 10:10:35
3975digital_wallet30002018-12-15 19:10:27
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;