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,276–5,300 of 5,412

payment, page 212 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5276digital_wallet45002020-01-12 14:40:29
5277credit_card8002020-01-12 15:49:02
5278credit_card60002020-01-13 12:33:27
5279digital_wallet30002020-01-14 07:48:35
5280credit_card17002020-01-14 10:02:36
5281cash17002020-01-14 11:16:36
5282debit_card75002020-01-14 13:35:21
5283credit_card30002020-01-15 10:48:16
5284credit_card34002020-01-15 14:09:14
5285credit_card60002020-01-16 19:03:07
5286credit_card45002020-01-17 18:41:48
5287credit_card4002020-01-18 00:02:40
5288debit_card30002020-01-18 08:19:28
5289credit_card8002020-01-18 09:27:56
5290credit_card34002020-01-18 11:38:50
5291digital_wallet17002020-01-18 11:58:00
5292credit_card8002020-01-18 12:40:29
5293credit_card15002020-01-18 14:00:45
5294digital_wallet8002020-01-18 15:07:23
5295debit_card8002020-01-18 15:21:29
5296debit_card4002020-01-19 02:51:04
5297cash34002020-01-19 09:11:10
5298debit_card30002020-01-19 21:17:06
5299digital_wallet15002020-01-20 10:14:16
5300cash51002020-01-21 13:34:39
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;