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,351–3,375 of 5,412

payment, page 135 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3351credit_card30002018-06-20 18:38:57
3352digital_wallet15002018-06-21 08:50:14
3353debit_card15002018-06-21 10:48:05
3354debit_card17002018-06-22 14:06:51
3355credit_card4002018-06-22 18:05:12
3356digital_wallet8002018-06-23 14:13:58
3357digital_wallet30002018-06-23 17:59:30
3358digital_wallet45002018-06-24 08:32:01
3359credit_card51002018-06-24 10:03:30
3360debit_card8002018-06-24 10:40:12
3361credit_card15002018-06-24 15:41:09
3362debit_card15002018-06-24 19:40:34
3363debit_card4002018-06-25 07:26:56
3364debit_card4002018-06-26 01:30:27
3365debit_card75002018-06-26 19:14:19
3366credit_card4002018-06-27 07:48:32
3367credit_card30002018-06-27 17:17:00
3368debit_card45002018-06-27 18:34:04
3369debit_card60002018-06-27 19:53:16
3370credit_card30002018-06-27 20:46:25
3371debit_card15002018-06-27 21:32:38
3372credit_card4002018-06-27 21:44:29
3373cash8002018-06-28 12:58:15
3374credit_card15002018-06-28 17:23:50
3375debit_card4002018-06-28 20:41:58
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;