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 5,301–5,325 of 5,412

payment, page 213 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5301credit_card30002020-01-21 21:45:42
5302debit_card30002020-01-21 22:29:03
5303digital_wallet15002020-01-22 07:58:08
5304debit_card30002020-01-22 09:42:47
5305credit_card8002020-01-22 10:08:36
5306credit_card8002020-01-22 10:56:07
5307credit_card30002020-01-22 12:19:30
5308credit_card8002020-01-22 14:41:35
5309credit_card15002020-01-22 20:25:00
5310credit_card60002020-01-23 07:26:11
5311credit_card4002020-01-23 09:51:49
5312credit_card8002020-01-23 13:45:46
5313digital_wallet34002020-01-23 14:11:58
5314credit_card8002020-01-23 14:47:43
5315credit_card45002020-01-23 15:09:09
5316digital_wallet75002020-01-24 20:08:55
5317credit_card15002020-01-24 20:23:36
5318cash34002020-01-25 08:43:29
5319debit_card30002020-01-25 14:38:50
5320digital_wallet15002020-01-25 17:33:54
5321debit_card4002020-01-26 10:42:26
5322debit_card45002020-01-26 13:08:52
5323credit_card4002020-01-27 00:03:04
5324debit_card4002020-01-27 01:45:48
5325credit_card17002020-01-27 08:56:31
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;