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,226–2,250 of 5,412

payment, page 90 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2226cash34002017-06-07 09:14:46
2227credit_card30002017-06-07 18:14:58
2228debit_card34002017-06-08 11:27:21
2229debit_card8002017-06-08 12:14:12
2230debit_card85002017-06-08 12:54:30
2231digital_wallet8002017-06-08 13:07:59
2232cash17002017-06-09 12:35:29
2233credit_card15002017-06-09 20:40:39
2234credit_card85002017-06-10 09:35:31
2235debit_card30002017-06-10 14:15:49
2236cash68002017-06-11 08:53:43
2237cash8002017-06-11 09:25:01
2238debit_card8002017-06-11 09:28:34
2239cash34002017-06-11 11:25:39
2240debit_card8002017-06-11 12:04:10
2241credit_card34002017-06-11 12:49:49
2242cash34002017-06-11 13:03:51
2243cash85002017-06-11 13:21:57
2244credit_card8002017-06-11 13:41:42
2245credit_card8002017-06-11 13:55:18
2246cash8002017-06-11 14:36:37
2247credit_card17002017-06-11 15:08:43
2248debit_card17002017-06-12 12:18:25
2249credit_card30002017-06-12 19:29:39
2250debit_card45002017-06-13 21:18:50
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;