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 51–75 of 5,412

payment, page 3 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
51credit_card675002015-03-20 16:14:05
52debit_card85002015-03-21 10:13:28
53cash8002015-03-21 10:59:54
54debit_card17002015-03-21 11:42:35
55credit_card34002015-03-22 10:21:34
56credit_card15002015-03-22 10:46:13
57credit_card60002015-03-24 08:42:24
58credit_card30002015-03-24 10:39:23
59credit_card450002015-03-24 18:57:56
60debit_card4002015-03-25 09:29:00
61debit_card15002015-03-25 10:51:07
62debit_card4002015-03-25 11:13:40
63credit_card30002015-03-25 12:18:32
64credit_card4002015-03-26 02:11:31
65cash51002015-03-27 10:30:11
66credit_card4002015-03-27 11:57:40
67cash34002015-03-27 12:03:02
68credit_card8002015-03-27 12:16:41
69credit_card34002015-03-27 12:40:39
70credit_card8002015-03-27 13:32:10
71debit_card4002015-03-28 16:27:14
72debit_card4002015-03-28 23:57:56
73credit_card4002015-03-29 08:13:05
74debit_card34002015-03-29 11:40:33
75credit_card8002015-03-29 12:11:14
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;