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 5,376–5,400 of 5,412

payment, page 216 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5376credit_card8002020-02-10 15:59:47
5377credit_card8002020-02-11 10:31:09
5378debit_card30002020-02-11 15:50:18
5379credit_card4002020-02-11 18:43:00
5380credit_card4002020-02-11 23:42:38
5381credit_card4002020-02-13 08:11:54
5382digital_wallet75002020-02-13 11:34:21
5383credit_card8002020-02-13 14:02:35
5384credit_card30002020-02-13 16:48:23
5385digital_wallet17002020-02-15 09:27:25
5386credit_card30002020-02-15 14:36:36
5387digital_wallet60002020-02-16 07:55:03
5388debit_card15002020-02-16 12:36:10
5389debit_card15002020-02-16 14:42:43
5390digital_wallet17002020-02-16 14:49:01
5391credit_card30002020-02-17 09:00:42
5392cash8002020-02-17 11:55:27
5393credit_card51002020-02-17 13:21:28
5394digital_wallet75002020-02-17 15:57:05
5395credit_card8002020-02-18 14:21:08
5396credit_card4002020-02-18 15:14:57
5397debit_card60002020-02-18 15:32:05
5398credit_card30002020-02-19 10:06:37
5399debit_card15002020-02-20 09:07:49
5400digital_wallet30002020-02-20 14:00:09
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;