Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,301–1,325 of 5,412

payment, page 53 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1301	debit_card	1700	2016-06-10 12:08:54
1302	cash	5100	2016-06-10 16:04:19
1303	debit_card	1500	2016-06-11 19:11:10
1304	debit_card	3000	2016-06-11 22:42:27
1305	cash	3400	2016-06-12 09:54:30
1306	credit_card	4500	2016-06-12 11:03:01
1307	credit_card	1700	2016-06-12 11:33:36
1308	credit_card	1500	2016-06-12 15:07:52
1309	credit_card	400	2016-06-12 19:00:27
1310	credit_card	3400	2016-06-14 08:43:39
1311	credit_card	3000	2016-06-14 20:13:35
1312	credit_card	400	2016-06-14 23:26:40
1313	credit_card	3000	2016-06-15 10:48:55
1314	debit_card	5100	2016-06-16 16:05:19
1315	credit_card	800	2016-06-16 16:48:08
1316	cash	6800	2016-06-17 10:05:29
1317	cash	800	2016-06-17 10:40:21
1318	credit_card	1500	2016-06-17 17:52:57
1319	cash	5100	2016-06-18 11:27:39
1320	credit_card	1500	2016-06-18 21:00:22
1321	cash	3400	2016-06-19 14:15:50
1322	credit_card	5100	2016-06-20 10:07:44
1323	debit_card	800	2016-06-20 10:54:05
1324	credit_card	1500	2016-06-21 11:41:33
1325	credit_card	1500	2016-06-22 10:32:21

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;