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,651–1,675 of 5,412

payment, page 67 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1651credit_card4002016-10-14 15:55:30
1652digital_wallet34002016-10-15 12:01:30
1653credit_card34002016-10-16 08:55:20
1654credit_card30002016-10-16 09:57:43
1655debit_card30002016-10-16 23:50:35
1656debit_card4002016-10-18 07:45:14
1657cash8002016-10-18 13:49:31
1658credit_card4002016-10-18 23:21:28
1659debit_card17002016-10-19 12:14:43
1660credit_card4002016-10-19 15:59:50
1661debit_card4002016-10-20 03:34:02
1662credit_card4002016-10-21 05:34:06
1663debit_card30002016-10-21 22:07:36
1664debit_card85002016-10-22 09:40:04
1665debit_card34002016-10-22 16:10:51
1666credit_card60002016-10-22 22:33:16
1667credit_card4002016-10-25 01:12:48
1668cash34002016-10-25 11:41:34
1669credit_card4002016-10-25 12:19:09
1670credit_card4002016-10-25 20:48:48
1671credit_card30002016-10-25 22:38:03
1672credit_card45002016-10-26 07:47:29
1673credit_card4002016-10-28 07:32:11
1674debit_card15002016-10-28 07:53:38
1675digital_wallet17002016-10-28 14:59:53
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;