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,351–4,375 of 5,412

payment, page 175 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4351debit_card30002019-04-24 11:40:18
4352debit_card8002019-04-25 09:51:15
4353credit_card8002019-04-25 10:08:49
4354debit_card8002019-04-25 12:44:17
4355digital_wallet17002019-04-26 10:10:35
4356credit_card30002019-04-27 07:26:24
4357credit_card4002019-04-27 15:46:05
4358credit_card75002019-04-28 09:00:15
4359credit_card8002019-04-28 09:49:36
4360credit_card4002019-04-28 17:14:38
4361debit_card4002019-04-29 06:34:14
4362credit_card34002019-04-29 11:31:52
4363digital_wallet8002019-04-29 12:08:35
4364digital_wallet15002019-04-29 13:26:51
4365digital_wallet34002019-04-29 14:12:20
4366debit_card15002019-04-29 18:18:43
4367digital_wallet30002019-04-29 22:09:23
4368debit_card15002019-04-29 23:34:15
4369credit_card45002019-04-30 09:13:01
4370credit_card4002019-04-30 10:06:00
4371cash34002019-04-30 13:14:01
4372debit_card15002019-05-01 15:14:43
4373debit_card15002019-05-02 10:41:40
4374credit_card34002019-05-02 11:00:23
4375digital_wallet30002019-05-02 14:53:06
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;