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,426–4,450 of 5,412

payment, page 178 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4426credit_card30002019-05-17 14:23:44
4427debit_card34002019-05-17 14:23:56
4428digital_wallet30002019-05-18 07:51:12
4429debit_card15002019-05-18 13:28:39
4430digital_wallet60002019-05-19 09:55:57
4431credit_card34002019-05-19 10:52:20
4432debit_card8002019-05-19 11:10:22
4433debit_card34002019-05-19 12:38:17
4434digital_wallet17002019-05-20 10:06:03
4435credit_card15002019-05-20 13:15:24
4436digital_wallet60002019-05-21 15:06:12
4437credit_card8002019-05-21 16:24:26
4438credit_card4002019-05-21 17:46:52
4439credit_card60002019-05-21 18:28:06
4440digital_wallet45002019-05-21 20:15:28
4441credit_card4002019-05-22 11:32:07
4442digital_wallet15002019-05-22 19:12:57
4443credit_card4002019-05-22 23:43:30
4444credit_card4002019-05-23 06:22:09
4445debit_card68002019-05-24 12:08:56
4446debit_card8002019-05-24 13:37:28
4447credit_card34002019-05-24 15:02:38
4448credit_card30002019-05-24 21:37:59
4449debit_card4002019-05-25 02:55:31
4450debit_card4002019-05-25 03:28:57
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;