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 401–425 of 5,412

payment, page 17 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
401debit_card51002015-07-12 13:43:55
402debit_card85002015-07-12 14:17:41
403cash8002015-07-12 14:27:31
404debit_card8002015-07-12 14:48:10
405cash8002015-07-12 14:53:39
406debit_card17002015-07-13 09:10:58
407credit_card15002015-07-13 09:28:51
408cash17002015-07-13 10:46:29
409cash17002015-07-14 16:27:44
410credit_card45002015-07-14 20:45:48
411cash17002015-07-15 13:23:35
412credit_card8002015-07-15 14:02:12
413credit_card75002015-07-16 15:07:42
414cash8002015-07-17 11:29:46
415credit_card60002015-07-18 08:36:45
416credit_card17002015-07-18 10:17:31
417cash8002015-07-18 10:40:00
418digital_wallet15002015-07-18 10:44:18
419cash8002015-07-18 10:47:06
420credit_card34002015-07-18 12:41:50
421cash34002015-07-19 10:48:54
422credit_card34002015-07-19 13:50:01
423debit_card30002015-07-20 07:38:49
424credit_card15002015-07-20 09:50:49
425credit_card30002015-07-20 11:42:54
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;