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,526–4,550 of 5,412

payment, page 182 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4526credit_card51002019-06-15 12:56:45
4527debit_card30002019-06-15 14:59:48
4528debit_card75002019-06-16 07:03:14
4529credit_card17002019-06-16 09:54:54
4530debit_card8002019-06-16 13:43:30
4531debit_card30002019-06-16 14:52:41
4532credit_card15002019-06-16 17:37:37
4533credit_card8002019-06-17 09:52:30
4534credit_card45002019-06-17 10:03:52
4535credit_card75002019-06-17 11:52:01
4536digital_wallet15002019-06-18 11:12:23
4537cash17002019-06-18 11:17:08
4538credit_card15002019-06-18 14:47:01
4539credit_card4002019-06-19 07:58:58
4540debit_card15002019-06-19 17:52:47
4541digital_wallet60002019-06-20 09:05:58
4542digital_wallet45002019-06-20 23:34:40
4543credit_card4002019-06-21 00:50:11
4544credit_card30002019-06-21 09:59:58
4545debit_card30002019-06-21 10:24:08
4546credit_card15002019-06-21 17:17:09
4547credit_card60002019-06-21 18:30:25
4548debit_card68002019-06-22 09:29:26
4549credit_card8002019-06-22 10:07:00
4550credit_card8002019-06-22 12:02:50
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;