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

payment, page 9 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
201debit_card17002015-05-06 14:57:51
202digital_wallet45002015-05-06 18:08:18
203debit_card75002015-05-06 19:05:24
204debit_card8002015-05-07 11:09:39
205credit_card690002015-05-07 13:50:18
206debit_card68002015-05-08 12:27:23
207debit_card30002015-05-09 12:17:33
208credit_card15002015-05-10 09:06:49
209credit_card4002015-05-10 11:50:43
210credit_card17002015-05-10 14:57:51
211debit_card4002015-05-10 15:31:57
212credit_card4002015-05-11 12:15:23
213credit_card4002015-05-11 17:48:02
214credit_card15002015-05-12 07:30:20
215debit_card17002015-05-12 10:17:44
216credit_card8002015-05-12 11:19:02
217cash34002015-05-13 12:02:38
218cash17002015-05-13 12:42:27
219digital_wallet51002015-05-13 14:26:48
220credit_card8002015-05-13 15:01:18
221credit_card60002015-05-13 17:03:27
222credit_card17002015-05-14 11:16:13
223credit_card60002015-05-15 08:20:59
224credit_card15002015-05-15 08:35:08
225credit_card34002015-05-15 09:18:57
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;