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 226–250 of 5,412

payment, page 10 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
226credit_card51002015-05-16 08:57:40
227credit_card45002015-05-16 09:01:36
228credit_card85002015-05-16 09:15:21
229debit_card8002015-05-16 09:58:12
230credit_card4002015-05-16 13:19:42
231credit_card17002015-05-16 14:44:43
232credit_card34002015-05-17 13:30:58
233debit_card15002015-05-17 16:01:35
234credit_card4002015-05-18 00:50:25
235credit_card4002015-05-18 03:59:45
236credit_card34002015-05-18 09:55:47
237cash8002015-05-18 10:35:31
238cash8002015-05-18 10:36:49
239debit_card34002015-05-18 10:51:24
240cash17002015-05-18 13:30:12
241credit_card4002015-05-19 09:16:09
242digital_wallet30002015-05-20 14:00:12
243credit_card34002015-05-20 14:58:41
244credit_card17002015-05-20 15:23:04
245cash8002015-05-20 15:56:28
246credit_card705002015-05-20 18:20:27
247credit_card15002015-05-20 21:50:16
248credit_card4002015-05-20 23:37:14
249digital_wallet30002015-05-21 10:27:50
250credit_card17002015-05-21 13:32:29
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;