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,201–5,225 of 5,412

payment, page 209 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5201debit_card4002019-12-21 20:34:41
5202credit_card8002019-12-22 11:13:02
5203digital_wallet15002019-12-22 17:05:00
5204credit_card15002019-12-22 17:06:50
5205digital_wallet17002019-12-23 12:34:11
5206credit_card8002019-12-23 13:10:51
5207debit_card75002019-12-23 13:52:44
5208debit_card30002019-12-23 14:34:56
5209credit_card4002019-12-23 17:58:41
5210credit_card15002019-12-23 19:56:51
5211credit_card30002019-12-24 07:56:14
5212cash34002019-12-24 10:18:52
5213cash51002019-12-24 13:24:35
5214digital_wallet17002019-12-24 13:56:25
5215digital_wallet8002019-12-24 15:38:53
5216credit_card8002019-12-24 15:55:09
5217cash8002019-12-24 16:00:38
5218credit_card30002019-12-25 10:28:28
5219credit_card8002019-12-25 11:54:34
5220debit_card60002019-12-25 11:57:37
5221cash8002019-12-25 11:59:57
5222cash8002019-12-26 12:47:27
5223digital_wallet34002019-12-27 09:01:20
5224credit_card34002019-12-27 10:30:36
5225credit_card8002019-12-27 11:29:44
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;