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,776–1,800 of 5,412

payment, page 72 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1776cash17002016-12-12 16:19:09
1777credit_card68002016-12-13 16:04:14
1778cash34002016-12-14 10:28:39
1779cash8002016-12-14 10:49:55
1780credit_card45002016-12-14 15:16:36
1781digital_wallet34002016-12-15 08:43:10
1782cash17002016-12-15 15:26:10
1783digital_wallet30002016-12-15 20:46:31
1784debit_card4002016-12-15 22:25:49
1785credit_card4002016-12-16 13:40:42
1786cash17002016-12-16 14:24:35
1787debit_card51002016-12-18 11:41:01
1788credit_card795002016-12-18 12:48:17
1789debit_card17002016-12-19 12:58:31
1790credit_card4002016-12-21 02:33:51
1791credit_card30002016-12-21 13:22:22
1792credit_card34002016-12-23 09:15:23
1793credit_card60002016-12-23 14:05:04
1794credit_card45002016-12-23 20:05:13
1795debit_card30002016-12-23 21:45:26
1796credit_card4002016-12-24 07:55:42
1797credit_card735002016-12-24 10:38:09
1798credit_card15002016-12-24 11:02:42
1799credit_card75002016-12-25 07:22:35
1800credit_card4002016-12-25 08:49:28
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;