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

payment, page 14 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
326digital_wallet8002015-06-17 13:59:28
327debit_card4002015-06-17 15:15:03
328debit_card68002015-06-18 12:56:58
329debit_card17002015-06-19 10:29:13
330credit_card34002015-06-19 10:55:38
331debit_card34002015-06-20 10:02:52
332credit_card8002015-06-20 10:32:20
333debit_card75002015-06-20 16:07:49
334cash51002015-06-21 12:17:17
335cash17002015-06-22 10:08:34
336credit_card4002015-06-22 21:42:15
337credit_card45002015-06-23 07:35:50
338debit_card45002015-06-23 07:57:01
339debit_card34002015-06-23 09:17:47
340debit_card8002015-06-23 09:58:45
341credit_card17002015-06-23 11:05:41
342cash8002015-06-23 11:23:45
343credit_card8002015-06-24 10:03:18
344credit_card4002015-06-24 12:49:22
345cash34002015-06-25 08:44:41
346credit_card8002015-06-25 09:27:24
347credit_card8002015-06-26 09:30:51
348cash17002015-06-26 14:01:05
349credit_card8002015-06-26 14:38:58
350credit_card4002015-06-26 20:55:59
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;