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,401–2,425 of 5,412

payment, page 97 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2401debit_card30002017-07-30 18:04:26
2402digital_wallet34002017-07-31 08:55:05
2403credit_card30002017-07-31 10:35:19
2404credit_card17002017-07-31 10:51:09
2405debit_card8002017-07-31 14:09:50
2406digital_wallet8002017-07-31 14:23:18
2407credit_card15002017-08-01 09:08:10
2408debit_card45002017-08-02 08:55:06
2409cash85002017-08-02 15:37:58
2410credit_card15002017-08-02 16:05:13
2411credit_card8002017-08-02 16:06:07
2412credit_card4002017-08-03 12:45:42
2413credit_card60002017-08-03 14:25:19
2414debit_card45002017-08-03 15:20:14
2415credit_card4002017-08-03 22:16:36
2416credit_card30002017-08-04 12:17:02
2417digital_wallet15002017-08-04 18:18:14
2418credit_card30002017-08-05 09:39:46
2419debit_card30002017-08-05 10:48:37
2420cash34002017-08-05 14:46:32
2421credit_card4002017-08-05 21:45:57
2422credit_card15002017-08-05 22:06:59
2423debit_card34002017-08-06 11:00:26
2424debit_card4002017-08-07 02:18:07
2425credit_card30002017-08-07 09:15:53
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;