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

payment, page 169 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4201credit_card30002019-03-14 12:59:59
4202credit_card4002019-03-14 18:02:09
4203credit_card30002019-03-14 23:56:42
4204credit_card8002019-03-15 09:23:11
4205credit_card4002019-03-15 13:02:50
4206credit_card8002019-03-15 17:20:15
4207debit_card15002019-03-15 17:25:32
4208credit_card4002019-03-15 19:12:49
4209credit_card30002019-03-15 22:50:23
4210debit_card4002019-03-16 02:12:14
4211digital_wallet15002019-03-16 08:16:23
4212debit_card60002019-03-16 09:11:26
4213credit_card4002019-03-16 11:17:47
4214debit_card15002019-03-17 18:52:10
4215digital_wallet17002019-03-18 14:42:55
4216debit_card4002019-03-18 16:15:23
4217credit_card60002019-03-18 21:17:17
4218debit_card4002019-03-19 01:23:15
4219debit_card750002019-03-19 08:52:54
4220credit_card15002019-03-19 10:56:41
4221debit_card34002019-03-19 13:03:00
4222debit_card60002019-03-19 14:35:52
4223credit_card8002019-03-19 15:06:35
4224debit_card4002019-03-20 01:12:25
4225credit_card30002019-03-20 07:35:15
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;