Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,801–1,825 of 5,412

payment, page 73 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1801	credit_card	800	2016-12-25 12:45:03
1802	cash	800	2016-12-25 13:39:55
1803	cash	800	2016-12-25 13:51:07
1804	cash	5100	2016-12-26 13:58:09
1805	debit_card	1700	2016-12-27 10:15:48
1806	credit_card	3400	2016-12-27 10:36:14
1807	debit_card	800	2016-12-27 10:51:25
1808	digital_wallet	800	2016-12-27 10:59:46
1809	credit_card	400	2016-12-27 11:52:26
1810	cash	1700	2016-12-27 12:00:45
1811	digital_wallet	3400	2016-12-27 12:05:00
1812	debit_card	3000	2016-12-27 23:19:38
1813	cash	1700	2016-12-28 08:51:11
1814	cash	800	2016-12-28 09:31:15
1815	debit_card	3000	2016-12-28 10:42:09
1816	debit_card	800	2016-12-28 11:13:47
1817	cash	800	2016-12-28 14:43:53
1818	credit_card	1500	2016-12-28 17:16:40
1819	debit_card	400	2016-12-29 03:39:01
1820	cash	3400	2016-12-29 11:03:12
1821	credit_card	800	2016-12-29 11:52:25
1822	credit_card	7500	2016-12-29 18:43:10
1823	credit_card	3000	2016-12-29 18:52:45
1824	credit_card	1700	2016-12-30 14:38:01
1825	credit_card	3000	2016-12-30 22:37:15

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;