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 451–475 of 5,412

payment, page 19 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
451credit_card4002015-07-25 01:30:49
452credit_card75002015-07-25 07:53:36
453cash8002015-07-25 10:36:08
454cash17002015-07-25 14:42:09
455credit_card8002015-07-25 15:03:31
456debit_card17002015-07-25 15:03:55
457cash8002015-07-25 15:32:08
458debit_card30002015-07-25 18:40:53
459cash68002015-07-26 08:51:16
460debit_card8002015-07-26 09:34:55
461debit_card30002015-07-26 23:49:10
462debit_card60002015-07-27 12:34:51
463credit_card30002015-07-27 16:56:34
464credit_card60002015-07-27 22:27:37
465credit_card45002015-07-28 07:04:54
466digital_wallet60002015-07-28 15:24:06
467debit_card4002015-07-29 03:22:18
468digital_wallet8002015-07-29 11:33:27
469digital_wallet45002015-07-29 11:47:04
470credit_card34002015-07-29 12:51:25
471debit_card8002015-07-29 13:15:50
472credit_card8002015-07-29 13:23:43
473credit_card4002015-07-29 20:02:07
474credit_card30002015-07-30 09:14:42
475cash34002015-07-30 10:24:47
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;