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,401–4,425 of 5,412

payment, page 177 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4401credit_card30002019-05-08 18:44:35
4402credit_card15002019-05-08 23:54:16
4403debit_card34002019-05-09 09:22:00
4404credit_card34002019-05-09 10:41:12
4405credit_card8002019-05-09 11:38:22
4406digital_wallet30002019-05-10 10:11:08
4407credit_card8002019-05-10 11:23:08
4408credit_card30002019-05-10 16:26:12
4409credit_card8002019-05-11 09:45:40
4410digital_wallet17002019-05-12 09:39:56
4411debit_card45002019-05-12 10:17:13
4412credit_card4002019-05-12 14:53:29
4413digital_wallet30002019-05-12 15:10:41
4414digital_wallet45002019-05-12 15:12:20
4415credit_card34002019-05-13 11:44:07
4416cash51002019-05-13 13:17:46
4417credit_card8002019-05-13 13:44:35
4418credit_card30002019-05-14 17:19:49
4419credit_card45002019-05-15 08:21:14
4420debit_card30002019-05-15 08:35:18
4421digital_wallet45002019-05-15 18:44:53
4422credit_card30002019-05-16 15:38:15
4423credit_card4002019-05-16 16:16:48
4424debit_card51002019-05-17 09:17:51
4425digital_wallet30002019-05-17 09:25:14
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;