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 626–650 of 5,412

payment, page 26 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
626debit_card8002015-09-11 12:28:10
627credit_card8002015-09-11 12:34:59
628credit_card8002015-09-11 12:45:55
629debit_card17002015-09-12 15:33:28
630credit_card4002015-09-13 04:14:06
631debit_card34002015-09-13 10:21:19
632cash8002015-09-13 10:49:12
633digital_wallet34002015-09-13 10:57:39
634credit_card525002015-09-13 12:41:04
635debit_card30002015-09-14 11:21:09
636credit_card30002015-09-14 20:27:51
637debit_card30002015-09-15 21:58:32
638credit_card4002015-09-16 06:57:27
639debit_card30002015-09-16 07:09:08
640credit_card8002015-09-16 12:01:23
641debit_card4002015-09-16 21:29:53
642credit_card615002015-09-17 12:06:57
643credit_card34002015-09-18 11:52:08
644credit_card15002015-09-18 23:01:41
645credit_card4002015-09-19 04:17:44
646digital_wallet15002015-09-19 08:19:25
647debit_card30002015-09-19 09:38:45
648credit_card34002015-09-20 10:13:37
649cash34002015-09-20 10:59:30
650credit_card17002015-09-20 12:11:02
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;