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,501–4,525 of 5,412

payment, page 181 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4501cash8002019-06-09 09:32:58
4502debit_card45002019-06-09 10:07:47
4503credit_card15002019-06-10 09:04:26
4504digital_wallet17002019-06-10 15:19:17
4505cash34002019-06-11 09:32:22
4506debit_card8002019-06-11 09:48:15
4507digital_wallet8002019-06-11 09:48:52
4508credit_card34002019-06-11 10:20:13
4509digital_wallet8002019-06-11 15:16:55
4510debit_card4002019-06-11 20:46:15
4511debit_card4002019-06-12 00:36:10
4512credit_card75002019-06-12 20:44:36
4513debit_card68002019-06-13 12:25:12
4514credit_card8002019-06-13 12:59:03
4515debit_card30002019-06-13 21:00:42
4516debit_card30002019-06-13 21:59:27
4517debit_card45002019-06-14 08:01:58
4518credit_card30002019-06-14 09:18:25
4519debit_card4002019-06-14 11:46:48
4520cash34002019-06-14 12:16:01
4521debit_card45002019-06-14 12:57:08
4522credit_card30002019-06-14 14:04:02
4523credit_card30002019-06-14 17:43:41
4524credit_card75002019-06-14 20:37:29
4525credit_card8002019-06-15 11:09:42
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;