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 4,676–4,700 of 5,412

payment, page 188 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4676digital_wallet480002019-07-24 08:23:37
4677debit_card8002019-07-24 10:51:08
4678credit_card17002019-07-24 11:39:21
4679digital_wallet15002019-07-24 12:30:21
4680debit_card30002019-07-24 13:07:00
4681credit_card17002019-07-24 14:16:43
4682debit_card8002019-07-24 15:49:13
4683credit_card17002019-07-25 09:51:16
4684credit_card45002019-07-25 10:06:09
4685credit_card8002019-07-25 13:14:09
4686credit_card4002019-07-26 07:35:15
4687digital_wallet15002019-07-26 19:15:37
4688debit_card60002019-07-26 19:35:23
4689cash8002019-07-27 10:27:09
4690credit_card8002019-07-27 11:32:53
4691credit_card51002019-07-27 11:52:13
4692debit_card34002019-07-27 12:13:46
4693digital_wallet34002019-07-27 14:31:58
4694debit_card8002019-07-27 15:12:27
4695digital_wallet30002019-07-27 22:12:01
4696credit_card4002019-07-28 08:47:22
4697debit_card8002019-07-28 09:18:10
4698credit_card17002019-07-28 13:34:04
4699credit_card15002019-07-29 07:56:51
4700debit_card8002019-07-29 14:12: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;