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 4,001–4,025 of 5,412

payment, page 161 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4001debit_card51002018-12-23 13:14:00
4002cash8002018-12-23 13:45:03
4003credit_card17002018-12-23 14:02:57
4004digital_wallet60002018-12-25 08:51:25
4005debit_card4002018-12-25 11:36:47
4006cash8002018-12-25 14:43:10
4007credit_card4002018-12-25 18:35:57
4008debit_card4002018-12-25 22:47:38
4009digital_wallet60002018-12-26 08:32:57
4010credit_card60002018-12-26 10:50:32
4011cash68002018-12-26 13:11:38
4012credit_card15002018-12-27 15:54:21
4013digital_wallet15002018-12-27 19:38:30
4014digital_wallet8002018-12-28 10:54:28
4015credit_card4002018-12-28 11:09:55
4016cash34002018-12-28 14:31:01
4017debit_card34002018-12-29 11:05:03
4018credit_card8002018-12-29 11:24:16
4019credit_card4002018-12-29 18:24:34
4020credit_card30002018-12-31 10:32:16
4021credit_card4002019-01-03 08:13:35
4022debit_card4002019-01-03 21:57:17
4023credit_card4002019-01-03 23:55:26
4024credit_card8002019-01-04 11:01:21
4025digital_wallet8002019-01-04 13:09:47
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;