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,751–2,775 of 5,412

payment, page 111 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2751debit_card8002017-12-10 16:34:18
2752cash8002017-12-10 16:40:19
2753debit_card4002017-12-10 22:47:42
2754credit_card4002017-12-11 18:24:16
2755credit_card30002017-12-12 09:29:54
2756digital_wallet15002017-12-12 10:02:20
2757cash68002017-12-12 15:00:43
2758digital_wallet8002017-12-12 15:38:10
2759debit_card4002017-12-13 03:20:43
2760credit_card30002017-12-13 19:42:48
2761credit_card30002017-12-14 08:42:31
2762credit_card51002017-12-15 11:36:11
2763digital_wallet8002017-12-15 12:05:58
2764credit_card15002017-12-16 21:39:18
2765credit_card17002017-12-17 09:01:46
2766debit_card45002017-12-17 22:54:42
2767digital_wallet60002017-12-18 07:06:55
2768credit_card75002017-12-18 08:11:09
2769credit_card30002017-12-18 09:11:50
2770cash8002017-12-18 10:01:28
2771cash68002017-12-18 11:55:50
2772credit_card8002017-12-18 12:44:34
2773credit_card51002017-12-18 13:24:05
2774credit_card15002017-12-19 10:02:18
2775credit_card15002017-12-20 15:42:50
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;