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,176–2,200 of 5,412

payment, page 88 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2176credit_card34002017-05-20 09:21:07
2177cash8002017-05-20 13:27:38
2178debit_card4002017-05-20 15:54:32
2179digital_wallet34002017-05-21 10:45:45
2180debit_card45002017-05-21 19:22:39
2181credit_card4002017-05-22 12:46:49
2182debit_card30002017-05-22 12:53:55
2183credit_card4002017-05-23 10:07:11
2184debit_card8002017-05-23 12:52:22
2185credit_card45002017-05-23 16:21:37
2186debit_card68002017-05-25 14:17:14
2187credit_card8002017-05-27 15:19:46
2188credit_card45002017-05-27 21:10:03
2189credit_card34002017-05-28 11:01:54
2190credit_card17002017-05-28 11:15:27
2191cash8002017-05-28 11:18:45
2192credit_card17002017-05-28 11:58:16
2193credit_card17002017-05-29 10:48:12
2194credit_card17002017-05-29 14:49:02
2195cash8002017-05-29 15:27:38
2196credit_card4002017-05-29 19:55:40
2197credit_card4002017-05-29 23:34:43
2198credit_card4002017-05-31 06:32:28
2199debit_card30002017-05-31 13:11:55
2200credit_card15002017-05-31 19:03:55
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;