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,826–4,850 of 5,412

payment, page 194 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4826credit_card15002019-08-29 07:16:30
4827debit_card34002019-08-29 09:06:22
4828credit_card60002019-08-29 10:42:26
4829credit_card8002019-08-29 11:10:30
4830credit_card30002019-08-29 12:37:25
4831credit_card34002019-08-30 09:10:05
4832credit_card51002019-08-30 10:00:26
4833debit_card8002019-08-30 10:47:06
4834credit_card4002019-08-30 14:45:33
4835debit_card75002019-08-30 17:28:03
4836cash34002019-08-31 09:44:40
4837debit_card34002019-08-31 10:05:07
4838credit_card8002019-08-31 10:43:01
4839digital_wallet8002019-08-31 13:19:56
4840digital_wallet15002019-08-31 20:53:22
4841debit_card15002019-09-01 07:35:50
4842debit_card15002019-09-01 10:05:01
4843cash34002019-09-01 11:34:46
4844digital_wallet30002019-09-02 21:21:34
4845debit_card30002019-09-03 17:42:13
4846debit_card30002019-09-03 18:06:34
4847credit_card4002019-09-04 06:28:22
4848debit_card68002019-09-04 15:35:37
4849cash8002019-09-04 16:05:16
4850debit_card30002019-09-04 16:07:14
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;