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

payment, page 8 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
176credit_card75002015-04-29 19:46:51
177debit_card34002015-04-30 15:51:04
178debit_card30002015-04-30 20:21:54
179debit_card45002015-04-30 22:27:13
180credit_card885002015-05-01 10:14:13
181credit_card8002015-05-01 10:31:45
182cash8002015-05-01 10:32:22
183credit_card34002015-05-01 11:16:39
184credit_card8002015-05-01 11:54:50
185debit_card8002015-05-01 13:46:53
186credit_card17002015-05-01 15:36:41
187cash8002015-05-02 11:38:45
188cash34002015-05-02 14:04:57
189credit_card17002015-05-03 09:44:53
190cash34002015-05-03 09:46:53
191credit_card8002015-05-03 10:10:19
192cash8002015-05-03 10:19:41
193credit_card68002015-05-03 13:51:16
194debit_card4002015-05-03 14:44:11
195cash8002015-05-04 09:44:14
196credit_card45002015-05-04 18:23:22
197credit_card85002015-05-05 10:23:54
198debit_card8002015-05-05 10:40:51
199cash34002015-05-06 11:33:35
200credit_card15002015-05-06 13:52:06
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;