Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,926–1,950 of 5,412

payment, page 78 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1926	credit_card	800	2017-02-12 09:28:40
1927	credit_card	800	2017-02-12 09:32:16
1928	debit_card	1500	2017-02-12 11:17:18
1929	credit_card	800	2017-02-12 12:17:52
1930	credit_card	1700	2017-02-15 16:22:20
1931	credit_card	3000	2017-02-15 16:50:06
1932	debit_card	400	2017-02-15 19:09:46
1933	debit_card	1500	2017-02-16 16:36:03
1934	digital_wallet	1500	2017-02-18 11:14:02
1935	credit_card	800	2017-02-18 11:46:52
1936	debit_card	3000	2017-02-18 19:08:48
1937	debit_card	800	2017-02-19 09:10:27
1938	cash	6800	2017-02-19 12:17:12
1939	cash	800	2017-02-19 12:34:12
1940	credit_card	800	2017-02-19 12:45:59
1941	credit_card	3000	2017-02-20 08:54:13
1942	cash	3400	2017-02-20 09:44:00
1943	debit_card	800	2017-02-20 10:21:14
1944	digital_wallet	800	2017-02-20 11:52:13
1945	credit_card	6000	2017-02-20 13:29:06
1946	credit_card	3000	2017-02-20 13:30:18
1947	digital_wallet	4500	2017-02-21 14:59:32
1948	digital_wallet	1500	2017-02-21 17:12:09
1949	credit_card	1500	2017-02-21 17:46:03
1950	credit_card	1500	2017-02-21 23:04:54

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;