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 476–500 of 5,412

payment, page 20 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
476credit_card30002015-07-30 13:59:20
477credit_card4002015-08-01 06:15:10
478debit_card34002015-08-01 09:29:34
479cash17002015-08-01 11:18:58
480debit_card30002015-08-01 17:17:12
481debit_card45002015-08-03 07:09:40
482credit_card30002015-08-03 07:31:40
483digital_wallet15002015-08-03 09:21:02
484debit_card17002015-08-04 08:45:05
485debit_card8002015-08-04 10:53:50
486credit_card60002015-08-04 13:28:17
487credit_card4002015-08-04 21:13:20
488credit_card34002015-08-05 08:59:22
489debit_card34002015-08-05 09:56:02
490credit_card45002015-08-05 16:36:38
491debit_card15002015-08-05 18:22:50
492digital_wallet15002015-08-05 19:50:32
493credit_card75002015-08-05 23:47:58
494credit_card8002015-08-06 09:58:08
495credit_card15002015-08-06 13:19:27
496credit_card8002015-08-06 17:04:05
497debit_card17002015-08-07 10:35:31
498credit_card15002015-08-07 10:45:59
499digital_wallet8002015-08-07 11:15:26
500credit_card15002015-08-07 15:55:45
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;