Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,401–1,425 of 5,412

payment, page 57 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1401	digital_wallet	3000	2016-07-16 10:35:58
1402	cash	8500	2016-07-16 13:41:03
1403	credit_card	800	2016-07-16 14:23:12
1404	debit_card	800	2016-07-16 14:51:27
1405	debit_card	400	2016-07-16 23:11:16
1406	credit_card	3000	2016-07-17 07:48:42
1407	credit_card	800	2016-07-17 10:07:58
1408	cash	8500	2016-07-17 13:32:41
1409	digital_wallet	4500	2016-07-17 22:00:06
1410	credit_card	400	2016-07-18 00:41:12
1411	credit_card	800	2016-07-18 15:29:10
1412	cash	800	2016-07-18 15:30:20
1413	credit_card	400	2016-07-19 00:11:07
1414	debit_card	1500	2016-07-19 12:45:58
1415	debit_card	3400	2016-07-19 13:53:03
1416	cash	800	2016-07-19 14:16:46
1417	credit_card	1500	2016-07-19 18:05:28
1418	credit_card	7500	2016-07-19 18:18:37
1419	credit_card	400	2016-07-20 03:20:54
1420	debit_card	3400	2016-07-20 09:53:55
1421	debit_card	3400	2016-07-20 16:13:10
1422	credit_card	3000	2016-07-20 19:08:56
1423	credit_card	400	2016-07-20 19:49:35
1424	credit_card	1500	2016-07-20 22:13:59
1425	credit_card	3400	2016-07-21 15:26:37

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;