Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,426–1,450 of 5,412

payment, page 58 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1426	debit_card	3400	2016-07-22 11:01:57
1427	cash	3400	2016-07-22 13:03:01
1428	debit_card	400	2016-07-22 19:05:18
1429	digital_wallet	3000	2016-07-22 21:32:00
1430	digital_wallet	3000	2016-07-22 21:38:58
1431	credit_card	3000	2016-07-23 09:13:35
1432	debit_card	1500	2016-07-23 09:19:57
1433	debit_card	3400	2016-07-23 14:10:14
1434	credit_card	7500	2016-07-24 17:58:28
1435	credit_card	3000	2016-07-24 21:16:01
1436	debit_card	800	2016-07-25 11:04:55
1437	credit_card	3000	2016-07-26 11:47:24
1438	credit_card	1500	2016-07-26 12:27:17
1439	cash	800	2016-07-26 14:50:28
1440	credit_card	1500	2016-07-26 15:15:44
1441	debit_card	1700	2016-07-26 15:25:32
1442	cash	1700	2016-07-27 09:24:41
1443	credit_card	1700	2016-07-27 10:38:06
1444	credit_card	1500	2016-07-28 09:06:48
1445	debit_card	5100	2016-07-28 11:17:23
1446	credit_card	3000	2016-07-28 20:39:47
1447	credit_card	3400	2016-07-30 15:51:50
1448	digital_wallet	4500	2016-07-30 17:50:29
1449	credit_card	800	2016-07-31 09:51:49
1450	credit_card	6800	2016-07-31 10:51:59

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;