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 2,476–2,500 of 5,412

payment, page 100 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2476credit_card30002017-08-20 09:37:27
2477debit_card17002017-08-20 12:23:44
2478credit_card645002017-08-20 12:49:00
2479cash8002017-08-20 15:17:04
2480credit_card34002017-08-21 14:39:57
2481debit_card30002017-08-21 20:33:22
2482debit_card15002017-08-22 09:43:40
2483digital_wallet15002017-08-22 11:27:09
2484digital_wallet85002017-08-22 11:44:09
2485credit_card8002017-08-22 12:16:43
2486credit_card34002017-08-22 12:22:43
2487credit_card68002017-08-22 15:41:29
2488debit_card8002017-08-22 16:13:09
2489debit_card15002017-08-23 10:33:44
2490credit_card30002017-08-23 14:10:17
2491debit_card30002017-08-24 08:06:21
2492credit_card45002017-08-24 08:53:10
2493debit_card17002017-08-24 11:47:31
2494cash68002017-08-24 11:49:14
2495debit_card60002017-08-24 13:43:31
2496debit_card4002017-08-24 23:05:05
2497debit_card4002017-08-25 01:21:49
2498credit_card8002017-08-25 10:26:11
2499digital_wallet30002017-08-25 11:56:49
2500credit_card30002017-08-25 20:14:52
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;