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,951–4,975 of 5,412

payment, page 199 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4951debit_card15002019-10-13 12:27:01
4952credit_card15002019-10-13 15:27:15
4953debit_card15002019-10-13 23:24:11
4954credit_card8002019-10-14 10:59:14
4955debit_card15002019-10-14 20:38:42
4956credit_card4002019-10-15 06:09:43
4957digital_wallet15002019-10-15 08:00:29
4958credit_card30002019-10-15 10:54:19
4959credit_card15002019-10-15 17:32:06
4960credit_card4002019-10-16 01:23:30
4961credit_card4002019-10-16 02:16:02
4962debit_card30002019-10-16 10:30:59
4963credit_card8002019-10-16 11:08:42
4964credit_card30002019-10-16 11:09:45
4965debit_card8002019-10-17 11:08:12
4966cash8002019-10-17 11:17:24
4967digital_wallet660002019-10-17 12:29:12
4968credit_card34002019-10-17 15:02:40
4969debit_card60002019-10-18 08:41:20
4970cash34002019-10-18 10:03:02
4971credit_card8002019-10-18 10:46:42
4972credit_card45002019-10-18 21:24:06
4973credit_card30002019-10-19 08:58:14
4974credit_card750002019-10-19 17:07:10
4975debit_card4002019-10-19 21:28:18
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;