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 351–375 of 5,412

payment, page 15 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
351credit_card4002015-06-27 04:46:07
352digital_wallet15002015-06-27 08:10:14
353credit_card34002015-06-27 11:26:09
354debit_card8002015-06-27 11:51:27
355cash17002015-06-27 12:12:16
356credit_card4002015-06-27 19:47:51
357cash51002015-06-28 10:26:42
358cash17002015-06-28 11:14:04
359credit_card15002015-06-28 12:02:49
360credit_card17002015-06-28 13:02:40
361debit_card34002015-07-01 08:37:01
362credit_card34002015-07-01 10:32:06
363credit_card15002015-07-02 07:00:30
364cash17002015-07-02 10:40:36
365credit_card34002015-07-02 11:13:12
366debit_card15002015-07-02 11:30:35
367credit_card17002015-07-03 10:38:40
368cash8002015-07-03 11:08:00
369credit_card4002015-07-03 13:57:15
370credit_card51002015-07-03 14:01:50
371debit_card30002015-07-03 14:06:15
372credit_card30002015-07-03 21:25:37
373cash17002015-07-04 09:22:32
374cash17002015-07-05 09:18:49
375credit_card34002015-07-05 10:10:35
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;