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 2,851–2,875 of 5,412

payment, page 115 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2851credit_card4002018-01-19 06:55:50
2852debit_card4002018-01-19 16:44:07
2853credit_card15002018-01-19 19:53:03
2854debit_card4002018-01-20 06:05:26
2855cash51002018-01-20 10:54:10
2856credit_card8002018-01-20 11:08:55
2857credit_card60002018-01-21 08:31:25
2858credit_card30002018-01-21 18:12:55
2859debit_card4002018-01-21 20:06:42
2860debit_card4002018-01-22 03:58:24
2861debit_card34002018-01-22 09:03:31
2862digital_wallet8002018-01-22 12:49:00
2863cash8002018-01-22 12:50:36
2864debit_card15002018-01-22 13:15:25
2865debit_card17002018-01-22 13:58:35
2866debit_card30002018-01-22 15:03:10
2867cash34002018-01-23 08:47:43
2868debit_card8002018-01-23 09:21:48
2869credit_card60002018-01-23 13:40:22
2870digital_wallet45002018-01-23 15:56:10
2871credit_card17002018-01-24 13:16:18
2872credit_card4002018-01-24 17:06:16
2873credit_card30002018-01-25 08:01:52
2874debit_card45002018-01-26 08:57:57
2875debit_card30002018-01-26 09:21:59
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;