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,451–2,475 of 5,412

payment, page 99 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2451debit_card17002017-08-14 09:13:30
2452cash17002017-08-14 12:50:02
2453credit_card68002017-08-14 14:05:37
2454debit_card8002017-08-14 14:42:31
2455credit_card15002017-08-14 15:33:49
2456credit_card30002017-08-14 20:07:46
2457credit_card4002017-08-15 07:29:32
2458credit_card4002017-08-15 07:57:33
2459debit_card15002017-08-15 08:31:12
2460cash34002017-08-15 09:33:11
2461debit_card60002017-08-15 13:57:53
2462cash17002017-08-16 08:59:25
2463cash8002017-08-16 09:47:09
2464debit_card30002017-08-16 21:45:50
2465debit_card4002017-08-17 07:43:31
2466credit_card68002017-08-17 11:28:46
2467cash8002017-08-17 12:58:53
2468credit_card17002017-08-17 13:52:52
2469credit_card15002017-08-18 09:16:40
2470credit_card30002017-08-18 10:34:43
2471debit_card4002017-08-18 12:48:56
2472credit_card30002017-08-18 18:10:58
2473debit_card30002017-08-18 21:50:52
2474cash34002017-08-19 13:54:16
2475digital_wallet30002017-08-19 17:22:00
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;