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,651–4,675 of 5,412

payment, page 187 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4651debit_card34002019-07-19 09:17:24
4652debit_card8002019-07-19 09:46:09
4653credit_card45002019-07-19 10:43:08
4654debit_card45002019-07-19 10:44:01
4655credit_card17002019-07-19 10:54:55
4656cash8002019-07-19 15:19:25
4657debit_card30002019-07-19 19:18:13
4658credit_card4002019-07-19 21:43:36
4659credit_card68002019-07-20 09:50:04
4660debit_card4002019-07-20 11:18:57
4661cash34002019-07-20 11:55:17
4662digital_wallet8002019-07-20 12:36:37
4663digital_wallet17002019-07-20 14:33:19
4664credit_card34002019-07-20 14:34:10
4665credit_card8002019-07-20 16:25:51
4666credit_card15002019-07-20 18:26:41
4667credit_card30002019-07-21 18:35:28
4668credit_card4002019-07-22 08:25:46
4669cash34002019-07-22 13:14:51
4670credit_card8002019-07-22 13:52:02
4671debit_card60002019-07-22 23:59:40
4672credit_card15002019-07-23 08:38:24
4673credit_card34002019-07-23 10:45:41
4674debit_card15002019-07-23 11:26:47
4675debit_card15002019-07-23 20:00:09
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;