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,376–4,400 of 5,412

payment, page 176 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4376digital_wallet30002019-05-02 17:37:05
4377credit_card15002019-05-02 18:03:49
4378credit_card8002019-05-03 15:30:48
4379digital_wallet60002019-05-03 19:02:48
4380credit_card4002019-05-04 03:08:08
4381debit_card75002019-05-04 07:29:05
4382debit_card8002019-05-04 10:49:22
4383credit_card51002019-05-04 10:52:13
4384debit_card8002019-05-04 11:24:15
4385digital_wallet8002019-05-04 11:28:37
4386digital_wallet17002019-05-04 13:18:42
4387digital_wallet30002019-05-05 10:19:14
4388credit_card4002019-05-05 13:35:08
4389credit_card8002019-05-05 16:12:03
4390debit_card4002019-05-06 08:36:45
4391digital_wallet45002019-05-06 11:51:10
4392digital_wallet60002019-05-06 17:12:43
4393credit_card30002019-05-06 23:05:52
4394credit_card4002019-05-07 11:26:16
4395credit_card4002019-05-07 13:47:46
4396credit_card45002019-05-07 14:11:18
4397debit_card8002019-05-07 15:17:23
4398credit_card4002019-05-07 19:55:39
4399credit_card30002019-05-08 11:51:39
4400credit_card45002019-05-08 15:34:30
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;