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 151–175 of 5,412

payment, page 7 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
151digital_wallet75002015-04-20 15:46:43
152credit_card4002015-04-21 08:13:07
153debit_card34002015-04-21 16:48:10
154credit_card17002015-04-23 08:53:40
155debit_card15002015-04-24 09:42:20
156debit_card17002015-04-24 12:50:39
157debit_card30002015-04-24 15:53:06
158digital_wallet85002015-04-24 16:11:33
159debit_card15002015-04-24 16:12:28
160digital_wallet8002015-04-24 16:31:56
161credit_card45002015-04-25 08:44:40
162debit_card4002015-04-26 00:24:16
163credit_card4002015-04-26 07:00:45
164credit_card8002015-04-26 11:07:15
165cash17002015-04-26 13:00:43
166credit_card8002015-04-26 13:32:43
167credit_card60002015-04-26 19:01:42
168credit_card45002015-04-26 23:07:41
169credit_card4002015-04-27 13:00:08
170debit_card4002015-04-28 09:12:54
171debit_card30002015-04-28 16:07:52
172cash34002015-04-29 10:58:20
173credit_card75002015-04-29 11:31:03
174debit_card17002015-04-29 11:48:56
175credit_card8002015-04-29 12:27:36
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;