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 1,751–1,775 of 5,412

payment, page 71 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1751debit_card45002016-11-30 19:26:47
1752debit_card45002016-12-01 08:56:58
1753credit_card8002016-12-01 10:38:43
1754debit_card840002016-12-02 12:06:38
1755credit_card4002016-12-02 23:49:30
1756credit_card17002016-12-03 11:19:14
1757debit_card75002016-12-03 13:15:14
1758debit_card15002016-12-03 23:59:39
1759cash17002016-12-04 13:47:25
1760debit_card8002016-12-04 14:11:02
1761credit_card60002016-12-04 22:36:13
1762credit_card4002016-12-05 06:36:30
1763debit_card15002016-12-05 16:17:23
1764credit_card17002016-12-07 09:53:48
1765cash8002016-12-07 11:01:28
1766debit_card17002016-12-08 16:32:15
1767debit_card8002016-12-08 17:09:46
1768credit_card60002016-12-08 22:44:25
1769credit_card15002016-12-09 09:16:16
1770debit_card60002016-12-09 15:16:12
1771credit_card45002016-12-09 17:18:49
1772debit_card4002016-12-10 18:59:28
1773credit_card34002016-12-11 13:23:55
1774credit_card17002016-12-11 13:45:12
1775credit_card8002016-12-11 14:00:46
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;