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

payment, page 6 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
126debit_card51002015-04-12 15:38:17
127cash8002015-04-12 16:11:49
128debit_card17002015-04-13 09:17:23
129debit_card34002015-04-13 10:34:13
130debit_card15002015-04-13 16:03:55
131debit_card17002015-04-14 10:54:33
132debit_card4002015-04-15 06:18:34
133debit_card8002015-04-15 13:08:35
134credit_card17002015-04-15 13:22:37
135credit_card15002015-04-17 09:28:55
136cash8002015-04-17 12:41:21
137cash8002015-04-17 17:13:43
138credit_card60002015-04-18 10:31:47
139digital_wallet34002015-04-18 10:47:01
140credit_card15002015-04-18 11:18:31
141credit_card34002015-04-18 11:33:21
142credit_card30002015-04-18 14:16:58
143credit_card30002015-04-18 21:50:10
144credit_card30002015-04-19 14:48:50
145credit_card30002015-04-19 15:39:09
146debit_card45002015-04-19 18:32:02
147credit_card15002015-04-19 22:10:17
148credit_card30002015-04-20 08:32:33
149credit_card30002015-04-20 09:49:25
150credit_card4002015-04-20 10:33:36
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;