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,126–2,150 of 5,412

payment, page 86 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2126credit_card60002017-05-02 07:02:06
2127debit_card34002017-05-02 09:37:53
2128cash17002017-05-02 10:11:01
2129debit_card8002017-05-02 10:41:56
2130credit_card75002017-05-03 19:29:18
2131credit_card4002017-05-04 07:08:47
2132cash17002017-05-04 11:20:21
2133credit_card17002017-05-05 10:47:49
2134credit_card4002017-05-05 15:06:04
2135debit_card60002017-05-05 19:33:12
2136debit_card4002017-05-05 22:29:11
2137credit_card8002017-05-06 09:45:48
2138debit_card17002017-05-06 14:40:15
2139digital_wallet45002017-05-06 17:07:37
2140credit_card30002017-05-07 09:21:24
2141credit_card60002017-05-07 18:33:02
2142credit_card15002017-05-07 22:01:11
2143debit_card68002017-05-08 10:42:28
2144debit_card34002017-05-08 13:39:25
2145credit_card60002017-05-08 14:05:08
2146credit_card30002017-05-08 16:03:23
2147debit_card15002017-05-09 07:07:51
2148credit_card30002017-05-10 12:44:44
2149credit_card30002017-05-11 10:26:39
2150debit_card17002017-05-11 10:33:43
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;