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,326–4,350 of 5,412

payment, page 174 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4326debit_card4002019-04-18 12:06:58
4327debit_card4002019-04-18 18:36:57
4328digital_wallet30002019-04-18 21:16:27
4329digital_wallet34002019-04-19 11:20:20
4330debit_card4002019-04-19 11:38:59
4331debit_card30002019-04-19 19:04:06
4332credit_card4002019-04-20 04:00:31
4333debit_card34002019-04-20 11:28:29
4334credit_card15002019-04-20 15:44:25
4335credit_card4002019-04-21 06:19:06
4336credit_card30002019-04-21 12:17:04
4337digital_wallet17002019-04-21 15:53:29
4338digital_wallet30002019-04-21 20:46:54
4339credit_card30002019-04-22 07:06:51
4340debit_card8002019-04-22 10:14:18
4341debit_card30002019-04-22 12:03:34
4342digital_wallet60002019-04-22 14:39:33
4343credit_card30002019-04-22 21:12:27
4344credit_card30002019-04-23 07:51:43
4345digital_wallet51002019-04-23 09:03:11
4346digital_wallet8002019-04-23 11:54:46
4347credit_card30002019-04-23 18:02:11
4348debit_card4002019-04-24 05:08:19
4349digital_wallet60002019-04-24 07:43:07
4350credit_card51002019-04-24 09:09:08
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;