Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Rows 2,276–2,300 of 5,412

payment, page 92 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
2276	digital_wallet	5100	2017-06-21 11:44:29
2277	credit_card	3000	2017-06-22 07:10:29
2278	digital_wallet	6000	2017-06-22 12:34:07
2279	credit_card	800	2017-06-22 14:55:04
2280	credit_card	400	2017-06-22 20:01:44
2281	credit_card	3000	2017-06-23 10:50:08
2282	debit_card	3000	2017-06-23 15:53:26
2283	credit_card	3000	2017-06-23 20:55:28
2284	credit_card	3000	2017-06-23 23:14:14
2285	debit_card	400	2017-06-24 03:35:00
2286	credit_card	800	2017-06-24 11:25:31
2287	debit_card	400	2017-06-25 05:24:50
2288	credit_card	3000	2017-06-25 08:12:07
2289	credit_card	3400	2017-06-25 11:05:10
2290	cash	3400	2017-06-25 13:28:27
2291	cash	800	2017-06-25 14:00:21
2292	debit_card	5100	2017-06-25 14:28:04
2293	debit_card	400	2017-06-25 23:55:50
2294	debit_card	3000	2017-06-26 07:17:16
2295	debit_card	1500	2017-06-26 08:35:38
2296	credit_card	3000	2017-06-26 10:18:23
2297	debit_card	800	2017-06-26 10:59:07
2298	debit_card	400	2017-06-27 08:22:55
2299	credit_card	1500	2017-06-28 08:29:26
2300	debit_card	400	2017-06-28 14:09:52

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;