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 276–300 of 5,412

payment, page 12 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
276debit_card60002015-06-03 09:05:57
277cash34002015-06-03 11:13:36
278debit_card15002015-06-03 14:26:28
279debit_card30002015-06-03 14:49:12
280credit_card30002015-06-04 14:03:44
281credit_card4002015-06-05 09:42:06
282cash8002015-06-06 10:45:14
283cash17002015-06-06 10:55:10
284cash8002015-06-06 11:24:40
285credit_card17002015-06-06 13:03:57
286credit_card8002015-06-06 14:05:27
287debit_card17002015-06-06 15:41:07
288credit_card45002015-06-07 12:59:38
289debit_card68002015-06-08 10:27:51
290debit_card34002015-06-08 11:12:14
291debit_card8002015-06-08 11:14:53
292credit_card8002015-06-08 11:39:10
293credit_card4002015-06-08 13:59:45
294credit_card17002015-06-08 14:36:59
295credit_card60002015-06-08 21:12:14
296debit_card4002015-06-09 12:41:42
297credit_card15002015-06-09 16:28:38
298debit_card15002015-06-09 17:29:43
299credit_card8002015-06-10 15:24:25
300debit_card15002015-06-10 16:37:56
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;