Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,701–1,725 of 5,412

payment, page 69 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1701	credit_card	400	2016-11-11 00:18:07
1702	credit_card	1500	2016-11-11 11:26:04
1703	cash	3400	2016-11-11 14:15:07
1704	digital_wallet	3000	2016-11-11 15:18:48
1705	credit_card	3400	2016-11-12 09:40:45
1706	debit_card	1500	2016-11-13 10:46:25
1707	credit_card	4500	2016-11-14 10:24:06
1708	credit_card	800	2016-11-14 11:02:32
1709	digital_wallet	3400	2016-11-15 15:38:25
1710	debit_card	800	2016-11-15 16:05:19
1711	credit_card	4500	2016-11-17 09:04:45
1712	cash	800	2016-11-17 11:22:46
1713	debit_card	4500	2016-11-18 15:22:20
1714	credit_card	6800	2016-11-20 09:40:22
1715	credit_card	3400	2016-11-20 11:15:00
1716	cash	800	2016-11-20 12:04:29
1717	digital_wallet	3400	2016-11-20 12:36:28
1718	cash	1700	2016-11-20 13:35:37
1719	debit_card	3400	2016-11-21 14:02:20
1720	debit_card	1700	2016-11-21 14:26:13
1721	debit_card	400	2016-11-21 18:10:26
1722	debit_card	6800	2016-11-22 14:09:32
1723	cash	800	2016-11-22 14:36:32
1724	credit_card	400	2016-11-23 06:26:56
1725	credit_card	1700	2016-11-23 09:52:53

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;