Table

payment

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

Replaces in 2020: Payment Methods

Rows 26–50 of 5,412

payment, page 2 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
26	cash	800	2015-03-07 11:18:13
27	credit_card	3400	2015-03-08 09:47:16
28	debit_card	800	2015-03-08 14:42:49
29	credit_card	800	2015-03-08 14:45:10
30	cash	800	2015-03-09 17:03:51
31	credit_card	6000	2015-03-10 11:31:40
32	credit_card	1500	2015-03-10 11:32:12
33	credit_card	3000	2015-03-10 15:48:34
34	cash	3400	2015-03-12 11:42:32
35	credit_card	1700	2015-03-13 10:19:45
36	debit_card	400	2015-03-13 12:49:37
37	debit_card	400	2015-03-14 01:36:31
38	debit_card	1700	2015-03-14 11:27:48
39	debit_card	3400	2015-03-14 13:02:15
40	credit_card	800	2015-03-14 13:52:33
41	credit_card	800	2015-03-15 13:51:07
42	digital_wallet	1500	2015-03-15 14:23:41
43	debit_card	400	2015-03-16 01:35:49
44	credit_card	1500	2015-03-17 22:55:18
45	credit_card	400	2015-03-17 23:36:46
46	debit_card	400	2015-03-18 04:57:13
47	digital_wallet	3000	2015-03-19 09:18:55
48	credit_card	400	2015-03-19 10:45:24
49	debit_card	3000	2015-03-19 15:52:17
50	credit_card	400	2015-03-20 05:32:22

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;