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 301–325 of 5,412

payment, page 13 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
301debit_card34002015-06-11 08:56:04
302credit_card8002015-06-11 09:23:14
303debit_card8002015-06-11 09:33:34
304debit_card68002015-06-11 12:53:22
305credit_card8002015-06-11 13:18:08
306debit_card8002015-06-11 13:20:26
307cash8002015-06-11 17:03:44
308credit_card4002015-06-11 17:31:26
309credit_card8002015-06-12 11:03:58
310credit_card68002015-06-12 12:42:07
311credit_card75002015-06-12 23:26:08
312credit_card68002015-06-13 14:29:57
313debit_card8002015-06-13 14:56:58
314credit_card4002015-06-13 20:20:19
315debit_card4002015-06-13 23:10:15
316debit_card8002015-06-14 09:33:51
317debit_card45002015-06-14 12:15:02
318credit_card34002015-06-15 10:04:11
319debit_card45002015-06-16 11:59:24
320debit_card4002015-06-16 13:10:13
321cash34002015-06-16 14:56:39
322debit_card4002015-06-16 15:27:52
323debit_card8002015-06-16 15:39:32
324debit_card34002015-06-17 13:19:31
325cash8002015-06-17 13:55:39
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;