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 726–750 of 5,412

payment, page 30 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
726credit_card8002015-10-16 13:03:47
727credit_card4002015-10-16 22:22:21
728credit_card45002015-10-17 07:40:21
729credit_card4002015-10-18 07:22:32
730cash17002015-10-18 10:43:46
731digital_wallet68002015-10-18 13:21:03
732credit_card45002015-10-18 17:12:16
733credit_card4002015-10-18 18:13:16
734debit_card34002015-10-19 11:56:22
735debit_card8002015-10-19 17:01:17
736digital_wallet45002015-10-20 11:56:19
737debit_card17002015-10-20 14:34:30
738credit_card4002015-10-21 03:59:45
739cash17002015-10-22 10:23:24
740debit_card4002015-10-22 15:07:09
741credit_card68002015-10-23 10:22:30
742credit_card15002015-10-23 16:12:04
743credit_card30002015-10-23 18:59:06
744credit_card30002015-10-24 20:37:10
745credit_card4002015-10-25 07:35:00
746debit_card17002015-10-25 09:09:40
747debit_card8002015-10-26 13:32:42
748debit_card4002015-10-27 04:13:56
749credit_card4002015-10-28 04:14:59
750debit_card15002015-10-28 11:59: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;