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 4,126–4,150 of 5,412

payment, page 166 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4126credit_card4002019-02-16 10:02:21
4127credit_card17002019-02-16 10:11:23
4128credit_card34002019-02-16 11:39:04
4129credit_card34002019-02-16 15:19:40
4130debit_card15002019-02-16 20:43:33
4131debit_card4002019-02-16 21:14:10
4132credit_card4002019-02-18 03:12:00
4133credit_card30002019-02-18 08:46:38
4134credit_card15002019-02-18 09:00:55
4135digital_wallet780002019-02-18 10:23:36
4136debit_card4002019-02-19 02:42:37
4137credit_card4002019-02-19 14:45:03
4138debit_card15002019-02-19 21:25:08
4139digital_wallet45002019-02-20 11:08:58
4140debit_card30002019-02-20 11:25:36
4141debit_card4002019-02-21 02:56:55
4142debit_card15002019-02-21 17:11:40
4143credit_card15002019-02-21 23:47:11
4144digital_wallet8002019-02-22 11:40:29
4145debit_card4002019-02-22 17:00:36
4146credit_card34002019-02-23 09:18:22
4147debit_card30002019-02-23 14:51:40
4148credit_card4002019-02-24 01:59:31
4149credit_card4002019-02-24 05:45:48
4150digital_wallet34002019-02-24 11:17:46
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;