Table

payment

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

Replaces in 2020: Payment Methods

Rows 101–125 of 5,412

payment, page 5 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
101	debit_card	800	2015-04-05 10:12:23
102	debit_card	400	2015-04-05 10:48:19
103	debit_card	8500	2015-04-05 10:53:09
104	digital_wallet	3000	2015-04-05 11:03:22
105	cash	1700	2015-04-05 12:15:40
106	credit_card	1500	2015-04-05 18:53:11
107	credit_card	400	2015-04-06 10:25:01
108	debit_card	3400	2015-04-06 10:46:28
109	credit_card	3400	2015-04-06 11:03:46
110	digital_wallet	800	2015-04-06 11:17:40
111	debit_card	800	2015-04-06 11:35:12
112	credit_card	3000	2015-04-06 15:14:07
113	credit_card	400	2015-04-07 03:16:22
114	credit_card	400	2015-04-08 11:43:51
115	credit_card	6000	2015-04-09 08:59:46
116	cash	800	2015-04-09 10:39:44
117	credit_card	800	2015-04-09 10:40:01
118	credit_card	1500	2015-04-10 08:01:37
119	debit_card	1500	2015-04-10 08:58:36
120	cash	3400	2015-04-10 10:23:47
121	credit_card	800	2015-04-10 10:40:26
122	credit_card	800	2015-04-10 10:44:21
123	debit_card	1700	2015-04-10 13:45:54
124	debit_card	6800	2015-04-11 16:04:51
125	credit_card	400	2015-04-12 11:38:08

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;