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,326–2,350 of 5,412

payment, page 94 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2326debit_card30002017-07-06 10:39:29
2327debit_card30002017-07-06 11:49:05
2328credit_card15002017-07-06 15:32:31
2329debit_card15002017-07-06 15:44:43
2330credit_card30002017-07-07 08:12:24
2331credit_card34002017-07-07 10:13:44
2332debit_card15002017-07-07 14:04:04
2333credit_card4002017-07-08 10:35:18
2334credit_card85002017-07-08 11:36:32
2335debit_card15002017-07-08 12:53:25
2336cash8002017-07-08 13:18:38
2337digital_wallet8002017-07-08 13:21:18
2338credit_card8002017-07-08 13:54:40
2339debit_card8002017-07-09 09:27:46
2340cash17002017-07-09 13:11:49
2341credit_card34002017-07-09 13:23:56
2342credit_card4002017-07-09 23:08:09
2343credit_card645002017-07-10 15:17:32
2344credit_card30002017-07-10 20:22:21
2345debit_card30002017-07-10 20:59:18
2346credit_card34002017-07-11 11:19:31
2347debit_card45002017-07-11 14:13:31
2348credit_card4002017-07-11 19:53:46
2349credit_card15002017-07-11 20:28:03
2350credit_card15002017-07-11 23:04:20
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;