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,201–2,225 of 5,412

payment, page 89 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2201debit_card30002017-05-31 21:24:52
2202credit_card30002017-06-01 21:03:36
2203credit_card4002017-06-02 13:49:27
2204digital_wallet15002017-06-02 14:33:24
2205debit_card4002017-06-03 16:25:30
2206digital_wallet30002017-06-03 23:00:09
2207credit_card4002017-06-04 06:36:10
2208cash8002017-06-04 10:32:13
2209debit_card51002017-06-04 11:17:03
2210debit_card15002017-06-04 11:23:19
2211credit_card4002017-06-04 15:07:40
2212cash34002017-06-05 10:35:17
2213cash8002017-06-05 10:40:57
2214credit_card8002017-06-05 10:58:50
2215credit_card75002017-06-05 21:07:15
2216credit_card17002017-06-06 08:50:53
2217digital_wallet8002017-06-06 09:28:53
2218digital_wallet34002017-06-06 10:02:41
2219cash8002017-06-06 10:28:44
2220cash8002017-06-06 10:33:09
2221credit_card17002017-06-06 10:40:21
2222cash17002017-06-06 11:36:49
2223cash8002017-06-06 13:07:19
2224cash8002017-06-06 13:13:49
2225credit_card15002017-06-07 08:05:58
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;