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 526–550 of 5,412

payment, page 22 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
526debit_card15002015-08-14 11:44:32
527credit_card15002015-08-14 14:49:54
528cash51002015-08-14 15:18:07
529cash51002015-08-15 10:37:37
530credit_card8002015-08-15 11:08:13
531credit_card17002015-08-15 11:30:59
532credit_card8002015-08-15 13:42:16
533cash34002015-08-15 14:40:41
534credit_card17002015-08-15 15:05:55
535debit_card8002015-08-16 12:15:26
536credit_card17002015-08-16 15:17:48
537credit_card51002015-08-17 09:28:23
538credit_card60002015-08-18 07:36:37
539cash34002015-08-18 10:16:52
540cash8002015-08-18 11:00:48
541cash34002015-08-18 14:43:12
542cash8002015-08-18 15:17:24
543credit_card15002015-08-18 19:20:12
544credit_card15002015-08-19 09:24:05
545debit_card15002015-08-19 16:10:01
546debit_card4002015-08-19 18:02:23
547credit_card15002015-08-20 07:56:11
548digital_wallet15002015-08-20 08:05:14
549credit_card8002015-08-20 11:21:11
550debit_card68002015-08-20 12:46:25
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;