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 2,076–2,100 of 5,412

payment, page 84 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2076digital_wallet30002017-04-17 12:59:43
2077credit_card4002017-04-17 14:00:35
2078digital_wallet60002017-04-18 07:08:35
2079credit_card8002017-04-18 12:55:58
2080credit_card4002017-04-18 14:14:12
2081credit_card450002017-04-18 19:47:25
2082digital_wallet8002017-04-19 14:47:16
2083cash17002017-04-19 16:12:02
2084credit_card15002017-04-20 10:03:41
2085digital_wallet60002017-04-20 19:01:16
2086digital_wallet75002017-04-21 09:56:57
2087credit_card30002017-04-21 12:28:44
2088credit_card45002017-04-21 19:43:21
2089cash8002017-04-22 09:55:47
2090debit_card30002017-04-22 11:49:06
2091digital_wallet30002017-04-22 14:02:40
2092debit_card30002017-04-22 17:43:59
2093debit_card4002017-04-22 18:57:36
2094cash85002017-04-23 11:03:21
2095credit_card34002017-04-23 13:49:19
2096debit_card8002017-04-23 14:04:41
2097debit_card8002017-04-23 14:12:07
2098credit_card4002017-04-23 16:38:10
2099credit_card15002017-04-23 19:34:52
2100credit_card4002017-04-24 06:03:41
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;