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 3,101–3,125 of 5,412

payment, page 125 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3101credit_card34002018-04-12 14:04:15
3102debit_card4002018-04-12 16:06:36
3103debit_card15002018-04-12 16:16:22
3104debit_card51002018-04-13 10:12:01
3105digital_wallet15002018-04-13 15:09:39
3106cash8002018-04-13 16:56:10
3107credit_card30002018-04-14 08:18:03
3108debit_card85002018-04-14 10:27:41
3109debit_card8002018-04-14 11:04:05
3110debit_card4002018-04-14 15:50:20
3111debit_card15002018-04-14 21:57:02
3112credit_card30002018-04-15 07:06:32
3113credit_card17002018-04-15 14:30:52
3114digital_wallet15002018-04-15 19:43:12
3115credit_card60002018-04-16 09:06:43
3116credit_card4002018-04-16 12:16:56
3117credit_card8002018-04-16 16:42:52
3118credit_card60002018-04-17 09:31:04
3119debit_card4002018-04-17 13:17:13
3120credit_card15002018-04-17 18:50:00
3121debit_card17002018-04-18 11:44:33
3122credit_card8002018-04-18 14:39:36
3123credit_card15002018-04-18 14:57:44
3124debit_card30002018-04-19 16:46:43
3125credit_card4002018-04-20 05:11:17
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;