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,426–2,450 of 5,412

payment, page 98 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2426credit_card4002017-08-07 09:17:39
2427digital_wallet15002017-08-07 09:28:14
2428debit_card4002017-08-07 10:13:05
2429digital_wallet34002017-08-07 10:27:16
2430credit_card34002017-08-07 12:45:27
2431credit_card4002017-08-07 16:46:52
2432digital_wallet45002017-08-08 21:34:09
2433credit_card30002017-08-08 23:49:51
2434credit_card30002017-08-09 16:06:37
2435credit_card30002017-08-09 20:51:28
2436credit_card4002017-08-10 14:31:56
2437cash8002017-08-10 15:14:15
2438debit_card8002017-08-10 15:17:16
2439debit_card75002017-08-11 18:15:32
2440credit_card15002017-08-11 20:59:55
2441digital_wallet15002017-08-12 08:02:26
2442debit_card34002017-08-12 10:46:08
2443digital_wallet8002017-08-12 11:58:27
2444debit_card15002017-08-12 16:04:47
2445cash8002017-08-13 10:54:21
2446credit_card30002017-08-13 13:53:04
2447credit_card8002017-08-13 14:03:00
2448cash17002017-08-13 16:32:43
2449credit_card8002017-08-13 17:02:33
2450credit_card30002017-08-14 08:36:13
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;