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,801–4,825 of 5,412

payment, page 193 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4801credit_card4002019-08-24 01:59:32
4802debit_card60002019-08-24 07:55:31
4803credit_card51002019-08-24 09:31:57
4804digital_wallet30002019-08-24 23:10:30
4805credit_card75002019-08-24 23:10:53
4806digital_wallet30002019-08-25 07:48:01
4807digital_wallet45002019-08-25 13:03:29
4808debit_card34002019-08-25 14:01:46
4809cash8002019-08-25 14:33:59
4810credit_card30002019-08-25 14:40:26
4811credit_card4002019-08-25 15:52:58
4812credit_card60002019-08-25 18:02:11
4813credit_card15002019-08-26 12:23:33
4814debit_card34002019-08-26 13:30:05
4815credit_card4002019-08-26 14:31:33
4816debit_card30002019-08-26 22:57:02
4817debit_card15002019-08-27 07:35:27
4818credit_card15002019-08-27 07:58:46
4819credit_card4002019-08-27 09:05:17
4820debit_card85002019-08-27 09:50:14
4821debit_card8002019-08-27 10:36:27
4822debit_card8002019-08-28 09:37:26
4823credit_card68002019-08-28 10:17:44
4824debit_card17002019-08-28 10:53:43
4825digital_wallet8002019-08-28 11:13:48
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;