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,226–5,250 of 5,412

payment, page 210 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5226credit_card75002019-12-27 16:11:02
5227credit_card4002019-12-27 21:22:24
5228debit_card45002019-12-28 08:38:06
5229credit_card17002019-12-28 11:31:51
5230digital_wallet8002019-12-28 12:08:05
5231debit_card30002019-12-28 12:28:47
5232credit_card4002019-12-28 19:25:07
5233credit_card17002019-12-29 09:35:56
5234digital_wallet34002019-12-29 10:47:46
5235credit_card8002019-12-29 11:30:35
5236credit_card34002019-12-30 08:56:21
5237cash8002019-12-30 09:28:34
5238digital_wallet17002019-12-30 10:49:55
5239debit_card34002019-12-30 11:22:25
5240digital_wallet8002019-12-30 11:57:23
5241cash8002019-12-30 12:09:24
5242debit_card4002019-12-30 15:35:24
5243credit_card34002020-01-01 11:02:57
5244debit_card30002020-01-02 13:44:30
5245debit_card30002020-01-02 16:32:52
5246credit_card4002020-01-02 20:11:20
5247credit_card60002020-01-03 09:21:00
5248credit_card30002020-01-03 21:03:13
5249credit_card15002020-01-04 10:20:47
5250credit_card8002020-01-04 10:24:59
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;