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

payment, page 96 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2376credit_card17002017-07-20 14:49:35
2377credit_card8002017-07-20 15:03:58
2378credit_card15002017-07-21 13:47:29
2379debit_card8002017-07-22 12:37:29
2380credit_card8002017-07-22 12:42:42
2381credit_card45002017-07-23 07:39:10
2382cash17002017-07-23 10:02:26
2383credit_card8002017-07-23 11:13:36
2384credit_card15002017-07-23 21:01:32
2385credit_card8002017-07-24 11:36:26
2386debit_card30002017-07-25 09:22:26
2387credit_card34002017-07-25 09:46:08
2388credit_card15002017-07-26 23:46:16
2389credit_card30002017-07-27 09:38:21
2390credit_card15002017-07-28 07:53:24
2391debit_card15002017-07-28 08:08:14
2392debit_card15002017-07-28 11:30:09
2393cash34002017-07-28 11:32:06
2394debit_card8002017-07-28 11:52:19
2395cash8002017-07-28 11:54:27
2396cash17002017-07-28 13:46:16
2397debit_card4002017-07-29 09:13:59
2398digital_wallet30002017-07-29 17:44:00
2399cash8002017-07-30 10:43:07
2400credit_card17002017-07-30 11:47:05
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;