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 5,026–5,050 of 5,412

payment, page 202 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5026digital_wallet45002019-11-03 23:03:21
5027credit_card4002019-11-04 00:24:09
5028credit_card68002019-11-04 11:26:24
5029credit_card30002019-11-04 22:46:36
5030digital_wallet45002019-11-05 10:03:15
5031credit_card4002019-11-05 11:22:04
5032credit_card4002019-11-05 17:30:03
5033digital_wallet15002019-11-05 17:52:48
5034credit_card45002019-11-05 22:33:26
5035credit_card4002019-11-05 22:58:25
5036digital_wallet34002019-11-06 08:55:36
5037cash34002019-11-07 08:43:41
5038credit_card15002019-11-07 10:25:58
5039cash8002019-11-07 13:09:08
5040debit_card30002019-11-07 19:26:54
5041credit_card34002019-11-08 09:49:00
5042debit_card30002019-11-08 11:00:14
5043digital_wallet15002019-11-08 11:50:45
5044credit_card17002019-11-08 12:12:21
5045debit_card30002019-11-08 12:39:22
5046debit_card8002019-11-08 12:53:48
5047digital_wallet8002019-11-08 13:54:49
5048debit_card15002019-11-08 17:48:42
5049credit_card15002019-11-09 17:24:44
5050credit_card15002019-11-10 10:12:16
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;