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,726–4,750 of 5,412

payment, page 190 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4726digital_wallet60002019-08-04 18:44:34
4727credit_card4002019-08-04 19:42:44
4728debit_card17002019-08-05 10:16:04
4729digital_wallet15002019-08-05 11:57:20
4730cash8002019-08-05 13:45:55
4731credit_card15002019-08-05 17:11:22
4732credit_card4002019-08-05 22:08:50
4733debit_card30002019-08-06 07:39:57
4734cash8002019-08-06 09:30:55
4735credit_card8002019-08-06 12:09:03
4736cash51002019-08-06 12:31:45
4737credit_card8002019-08-06 13:21:58
4738digital_wallet8002019-08-06 14:41:49
4739debit_card8002019-08-06 15:11:15
4740credit_card4002019-08-07 03:18:29
4741credit_card30002019-08-07 08:16:38
4742digital_wallet45002019-08-07 08:38:00
4743cash17002019-08-07 09:53:46
4744cash8002019-08-07 10:42:35
4745credit_card68002019-08-07 11:49:22
4746credit_card30002019-08-07 20:43:47
4747debit_card30002019-08-08 11:09:49
4748digital_wallet30002019-08-08 11:55:51
4749debit_card45002019-08-08 20:15:19
4750digital_wallet15002019-08-08 22:31:07
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;