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 376–400 of 5,412

payment, page 16 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
376cash68002015-07-05 11:28:02
377debit_card30002015-07-05 20:53:29
378debit_card4002015-07-06 02:55:16
379credit_card34002015-07-06 09:02:56
380credit_card17002015-07-06 11:13:15
381cash17002015-07-07 12:03:37
382debit_card4002015-07-07 19:38:01
383debit_card34002015-07-08 12:29:02
384cash8002015-07-08 13:00:20
385debit_card15002015-07-08 17:24:26
386credit_card4002015-07-08 22:58:34
387cash34002015-07-09 10:41:45
388credit_card8002015-07-09 11:16:03
389credit_card30002015-07-09 21:47:54
390debit_card34002015-07-10 10:17:32
391credit_card51002015-07-10 11:27:13
392credit_card8002015-07-10 12:15:51
393cash34002015-07-11 09:37:45
394cash17002015-07-11 10:05:23
395digital_wallet8002015-07-11 10:08:34
396debit_card34002015-07-11 10:53:56
397credit_card8002015-07-11 11:46:52
398credit_card30002015-07-11 19:36:05
399credit_card15002015-07-11 21:05:04
400debit_card4002015-07-12 00:49:50
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;