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

payment, page 107 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2651debit_card45002017-10-25 20:13:15
2652cash17002017-10-26 09:54:40
2653digital_wallet30002017-10-26 22:29:50
2654debit_card30002017-10-27 17:27:56
2655credit_card8002017-10-28 10:16:13
2656digital_wallet8002017-10-28 11:01:48
2657credit_card45002017-10-28 16:41:49
2658credit_card30002017-10-28 19:00:34
2659digital_wallet45002017-10-29 17:04:29
2660debit_card15002017-10-29 19:52:09
2661credit_card68002017-10-30 10:09:11
2662credit_card51002017-10-31 10:08:42
2663credit_card30002017-11-01 07:24:17
2664cash8002017-11-02 11:13:41
2665credit_card4002017-11-02 19:59:37
2666credit_card4002017-11-03 10:41:15
2667debit_card4002017-11-03 17:26:29
2668credit_card4002017-11-04 06:12:51
2669credit_card8002017-11-04 12:10:48
2670credit_card4002017-11-05 01:58:35
2671debit_card30002017-11-05 17:15:40
2672credit_card30002017-11-06 08:03:49
2673debit_card4002017-11-06 09:14:57
2674credit_card4002017-11-06 10:28:24
2675digital_wallet15002017-11-06 14:28:50
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;