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,751–4,775 of 5,412

payment, page 191 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4751credit_card4002019-08-09 08:15:17
4752credit_card4002019-08-09 08:17:27
4753cash8002019-08-09 09:17:22
4754credit_card34002019-08-09 10:42:12
4755debit_card30002019-08-09 10:50:47
4756debit_card8002019-08-09 10:57:53
4757debit_card4002019-08-09 14:55:06
4758digital_wallet68002019-08-10 11:25:08
4759debit_card8002019-08-10 11:49:26
4760credit_card8002019-08-10 11:52:23
4761credit_card34002019-08-10 14:09:00
4762credit_card8002019-08-10 14:41:50
4763digital_wallet85002019-08-11 11:48:59
4764debit_card30002019-08-12 08:37:24
4765credit_card45002019-08-12 14:55:54
4766cash17002019-08-13 09:28:53
4767credit_card15002019-08-13 21:41:12
4768credit_card15002019-08-13 22:13:30
4769digital_wallet17002019-08-14 12:59:04
4770debit_card4002019-08-15 02:24:31
4771debit_card15002019-08-15 07:41:45
4772debit_card75002019-08-15 07:58:44
4773digital_wallet30002019-08-15 09:54:31
4774credit_card17002019-08-15 12:51:54
4775credit_card60002019-08-15 13:19:33
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;