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 576–600 of 5,412

payment, page 24 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
576credit_card34002015-08-28 12:39:07
577credit_card4002015-08-28 12:53:44
578cash8002015-08-28 12:54:26
579debit_card8002015-08-28 12:55:17
580credit_card4002015-08-28 18:36:45
581credit_card4002015-08-28 21:31:58
582digital_wallet30002015-08-28 23:52:59
583credit_card4002015-08-29 01:49:04
584credit_card15002015-08-29 07:55:24
585cash34002015-08-29 11:10:54
586cash17002015-08-29 11:26:09
587cash17002015-08-29 12:36:12
588cash8002015-08-29 12:38:06
589debit_card8002015-08-29 12:50:22
590debit_card17002015-08-29 13:57:58
591credit_card34002015-08-29 16:04:32
592cash8002015-08-29 16:48:50
593credit_card8002015-08-29 16:52:27
594credit_card8002015-08-30 11:12:54
595cash8002015-08-30 13:09:54
596debit_card45002015-08-30 23:42:09
597cash17002015-08-31 09:48:39
598debit_card34002015-08-31 10:06:03
599digital_wallet8002015-08-31 10:11:50
600debit_card68002015-08-31 11:05:14
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;