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 251–275 of 5,412

payment, page 11 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
251cash8002015-05-21 14:20:00
252debit_card17002015-05-22 09:59:50
253credit_card8002015-05-22 10:15:37
254debit_card8002015-05-22 10:59:42
255cash34002015-05-22 11:08:59
256cash8002015-05-22 14:15:40
257cash17002015-05-22 15:26:45
258debit_card17002015-05-23 10:05:54
259credit_card15002015-05-23 19:26:30
260credit_card34002015-05-24 09:20:10
261digital_wallet15002015-05-24 20:08:41
262cash8002015-05-25 11:13:52
263credit_card8002015-05-25 11:19:14
264cash17002015-05-25 15:11:29
265credit_card51002015-05-25 15:20:52
266credit_card4002015-05-26 15:36:35
267debit_card15002015-05-28 09:38:18
268credit_card4002015-05-28 13:07:51
269credit_card4002015-05-28 18:33:26
270credit_card68002015-05-29 10:27:59
271credit_card8002015-05-29 11:05:49
272credit_card8002015-05-31 16:12:36
273credit_card30002015-05-31 16:39:05
274credit_card34002015-06-01 12:44:41
275credit_card30002015-06-02 14:17:35
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;