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,701–4,725 of 5,412

payment, page 189 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4701credit_card45002019-07-29 15:54:01
4702debit_card4002019-07-30 01:02:56
4703credit_card60002019-07-30 10:40:28
4704credit_card34002019-07-30 10:56:49
4705credit_card8002019-07-30 13:32:08
4706credit_card60002019-07-30 14:55:56
4707credit_card15002019-07-31 13:30:13
4708debit_card45002019-07-31 14:29:22
4709digital_wallet15002019-07-31 22:38:42
4710credit_card4002019-08-01 20:28:16
4711credit_card68002019-08-02 08:45:21
4712cash85002019-08-02 08:57:41
4713digital_wallet34002019-08-02 13:28:17
4714debit_card8002019-08-02 14:11:31
4715debit_card34002019-08-02 16:23:37
4716credit_card60002019-08-02 23:16:24
4717digital_wallet30002019-08-03 07:00:34
4718digital_wallet45002019-08-03 09:25:44
4719credit_card30002019-08-03 09:27:27
4720debit_card4002019-08-03 10:13:43
4721credit_card60002019-08-03 17:12:19
4722digital_wallet30002019-08-03 22:28:52
4723credit_card4002019-08-04 03:08:32
4724debit_card17002019-08-04 10:56:17
4725cash8002019-08-04 11:35:18
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;