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,151–4,175 of 5,412

payment, page 167 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4151debit_card4002019-02-24 21:19:34
4152credit_card30002019-02-25 09:38:35
4153credit_card15002019-02-25 21:06:31
4154debit_card4002019-02-26 00:25:00
4155digital_wallet30002019-02-26 22:07:53
4156digital_wallet75002019-02-28 08:48:30
4157digital_wallet45002019-02-28 11:33:56
4158debit_card15002019-02-28 17:19:08
4159debit_card4002019-03-01 17:06:59
4160credit_card15002019-03-01 21:19:45
4161cash85002019-03-02 10:31:58
4162digital_wallet8002019-03-02 10:48:38
4163credit_card8002019-03-02 10:49:06
4164credit_card4002019-03-02 20:56:11
4165digital_wallet75002019-03-02 23:55:36
4166cash8002019-03-03 12:51:49
4167debit_card45002019-03-03 19:10:55
4168credit_card45002019-03-03 21:49:02
4169credit_card75002019-03-05 07:06:13
4170digital_wallet60002019-03-05 08:28:18
4171digital_wallet30002019-03-05 11:10:38
4172cash51002019-03-05 11:23:26
4173digital_wallet30002019-03-05 13:24:10
4174debit_card4002019-03-06 07:45:06
4175digital_wallet15002019-03-06 08:50:28
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;