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 5,251–5,275 of 5,412

payment, page 211 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5251credit_card4002020-01-04 12:58:42
5252credit_card4002020-01-05 02:47:23
5253digital_wallet34002020-01-05 13:17:22
5254credit_card15002020-01-06 09:25:27
5255credit_card4002020-01-06 12:55:01
5256debit_card4002020-01-06 14:05:11
5257debit_card8002020-01-06 15:11:12
5258credit_card30002020-01-06 21:38:55
5259debit_card4002020-01-07 08:25:48
5260credit_card17002020-01-07 09:56:18
5261digital_wallet8002020-01-07 10:43:04
5262digital_wallet17002020-01-07 11:29:09
5263digital_wallet30002020-01-07 18:42:18
5264credit_card30002020-01-07 20:00:41
5265cash17002020-01-08 10:34:01
5266digital_wallet15002020-01-08 16:44:30
5267credit_card30002020-01-08 23:21:14
5268cash34002020-01-09 11:23:09
5269credit_card17002020-01-09 13:25:55
5270digital_wallet8002020-01-09 15:41:58
5271debit_card8002020-01-09 15:59:42
5272debit_card4002020-01-10 15:37:54
5273debit_card45002020-01-10 17:43:21
5274debit_card30002020-01-10 23:24:45
5275digital_wallet30002020-01-11 11:27:00
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;