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 3,876–3,900 of 5,412

payment, page 156 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3876debit_card8002018-11-18 11:24:30
3877credit_card51002018-11-19 10:00:33
3878credit_card8002018-11-19 12:37:26
3879debit_card68002018-11-19 14:20:50
3880cash8002018-11-19 15:05:51
3881credit_card4002018-11-20 12:02:36
3882debit_card4002018-11-20 16:54:26
3883credit_card15002018-11-20 21:35:15
3884credit_card30002018-11-20 21:58:13
3885credit_card15002018-11-21 07:33:18
3886credit_card15002018-11-21 10:19:29
3887credit_card900002018-11-21 11:56:32
3888credit_card75002018-11-21 19:47:50
3889debit_card4002018-11-22 05:44:07
3890credit_card68002018-11-22 10:38:33
3891credit_card60002018-11-22 13:31:02
3892digital_wallet75002018-11-22 17:00:02
3893credit_card60002018-11-22 18:34:07
3894debit_card30002018-11-22 22:50:39
3895credit_card30002018-11-23 10:59:03
3896credit_card17002018-11-23 13:29:09
3897debit_card68002018-11-23 14:38:47
3898credit_card8002018-11-23 15:06:52
3899credit_card30002018-11-23 22:13:58
3900credit_card30002018-11-24 07:39: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;