Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,876–1,900 of 5,412

payment, page 76 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1876	digital_wallet	69000	2017-01-22 17:05:54
1877	debit_card	3400	2017-01-23 12:01:56
1878	credit_card	1500	2017-01-23 22:14:13
1879	debit_card	6000	2017-01-23 22:58:55
1880	digital_wallet	3000	2017-01-24 17:30:18
1881	debit_card	3000	2017-01-24 18:04:39
1882	credit_card	1500	2017-01-24 18:19:13
1883	debit_card	400	2017-01-24 23:47:42
1884	cash	800	2017-01-26 10:53:56
1885	credit_card	800	2017-01-26 11:12:58
1886	credit_card	800	2017-01-26 11:15:49
1887	credit_card	1700	2017-01-26 13:04:44
1888	credit_card	1500	2017-01-27 07:09:21
1889	debit_card	800	2017-01-27 09:34:44
1890	credit_card	400	2017-01-27 09:34:50
1891	credit_card	1700	2017-01-27 09:55:59
1892	debit_card	800	2017-01-27 10:28:55
1893	cash	3400	2017-01-27 10:33:37
1894	credit_card	800	2017-01-27 13:43:41
1895	credit_card	6800	2017-01-27 15:10:08
1896	debit_card	800	2017-01-27 15:37:20
1897	credit_card	400	2017-01-28 21:27:36
1898	debit_card	400	2017-01-29 08:47:58
1899	credit_card	1500	2017-01-29 14:53:14
1900	credit_card	400	2017-01-30 20:01:23

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;