Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,726–1,750 of 5,412

payment, page 70 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1726	cash	800	2016-11-23 10:18:29
1727	cash	800	2016-11-23 10:30:51
1728	credit_card	1500	2016-11-23 12:12:38
1729	digital_wallet	5100	2016-11-24 10:10:35
1730	cash	1700	2016-11-24 11:20:36
1731	debit_card	800	2016-11-24 11:35:25
1732	cash	3400	2016-11-25 10:11:28
1733	debit_card	800	2016-11-25 10:26:59
1734	credit_card	6000	2016-11-25 12:46:26
1735	cash	3400	2016-11-25 14:26:25
1736	credit_card	400	2016-11-25 15:17:37
1737	debit_card	3000	2016-11-25 15:52:08
1738	digital_wallet	800	2016-11-26 11:20:22
1739	credit_card	400	2016-11-26 22:21:19
1740	credit_card	6800	2016-11-27 09:02:50
1741	credit_card	800	2016-11-27 09:51:59
1742	debit_card	800	2016-11-27 11:55:52
1743	debit_card	800	2016-11-27 11:57:37
1744	credit_card	1500	2016-11-28 07:02:56
1745	debit_card	400	2016-11-28 20:25:36
1746	credit_card	1700	2016-11-29 10:02:59
1747	digital_wallet	6000	2016-11-29 15:28:01
1748	credit_card	400	2016-11-29 23:14:16
1749	credit_card	400	2016-11-30 09:48:13
1750	cash	3400	2016-11-30 15:57:13

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;