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 426–450 of 5,412

payment, page 18 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
426credit_card15002015-07-21 07:29:09
427credit_card45002015-07-21 07:38:21
428debit_card34002015-07-21 11:28:10
429credit_card34002015-07-21 11:37:11
430credit_card4002015-07-21 13:27:33
431credit_card15002015-07-21 22:13:04
432debit_card17002015-07-22 11:32:05
433cash17002015-07-22 11:41:18
434cash34002015-07-22 12:06:07
435credit_card8002015-07-22 12:39:25
436cash34002015-07-22 12:47:32
437cash17002015-07-23 10:51:08
438credit_card17002015-07-23 11:10:04
439credit_card8002015-07-23 11:31:00
440credit_card17002015-07-23 12:40:08
441cash17002015-07-23 14:06:40
442credit_card4002015-07-23 21:03:53
443digital_wallet60002015-07-23 22:11:25
444credit_card75002015-07-24 07:21:58
445credit_card34002015-07-24 08:31:35
446debit_card17002015-07-24 09:21:50
447debit_card8002015-07-24 09:22:07
448credit_card34002015-07-24 10:24:02
449cash8002015-07-24 11:40:08
450credit_card30002015-07-24 18:15:32
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;