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 551–575 of 5,412

payment, page 23 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
551credit_card45002015-08-20 13:24:56
552debit_card8002015-08-20 13:31:21
553credit_card15002015-08-20 20:31:58
554credit_card15002015-08-21 14:09:52
555credit_card68002015-08-21 15:54:48
556debit_card8002015-08-21 16:19:36
557cash8002015-08-22 10:39:38
558debit_card60002015-08-22 14:06:07
559digital_wallet30002015-08-22 15:33:07
560debit_card60002015-08-23 07:35:50
561cash17002015-08-23 09:17:29
562credit_card60002015-08-23 10:46:00
563debit_card4002015-08-23 17:05:43
564credit_card8002015-08-23 17:11:50
565debit_card4002015-08-23 19:44:04
566digital_wallet30002015-08-24 10:13:14
567credit_card17002015-08-24 10:14:29
568debit_card60002015-08-24 18:37:43
569credit_card34002015-08-25 09:56:22
570credit_card15002015-08-27 07:25:29
571credit_card4002015-08-27 14:15:49
572cash34002015-08-27 14:35:40
573debit_card30002015-08-28 08:37:23
574debit_card30002015-08-28 11:38:27
575cash68002015-08-28 12:07:42
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;