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,326–5,350 of 5,412

payment, page 214 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5326credit_card15002020-01-27 23:30:11
5327credit_card45002020-01-28 09:42:10
5328credit_card17002020-01-29 10:25:58
5329cash8002020-01-29 11:19:00
5330cash8002020-01-29 11:32:18
5331credit_card4002020-01-30 00:46:19
5332debit_card60002020-01-30 16:22:23
5333debit_card15002020-01-30 23:22:12
5334credit_card4002020-01-31 02:03:56
5335debit_card4002020-01-31 08:57:58
5336credit_card8002020-01-31 12:51:41
5337credit_card15002020-01-31 14:23:01
5338digital_wallet34002020-02-01 10:57:37
5339credit_card30002020-02-01 11:12:44
5340cash8002020-02-01 11:46:42
5341debit_card34002020-02-01 12:05:38
5342credit_card15002020-02-01 19:51:25
5343credit_card30002020-02-01 20:44:24
5344credit_card4002020-02-02 01:05:58
5345debit_card4002020-02-02 04:47:35
5346credit_card4002020-02-02 05:36:27
5347digital_wallet30002020-02-02 08:08:02
5348credit_card8002020-02-02 11:02:20
5349credit_card8002020-02-02 12:56:19
5350credit_card8002020-02-02 13:06: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;