Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,901–1,925 of 5,412

payment, page 77 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1901	digital_wallet	1700	2017-01-31 10:42:45
1902	cash	800	2017-01-31 11:31:28
1903	debit_card	1500	2017-01-31 21:51:39
1904	credit_card	400	2017-02-01 10:21:26
1905	debit_card	3000	2017-02-02 13:45:47
1906	credit_card	3000	2017-02-02 23:42:39
1907	credit_card	800	2017-02-03 15:11:47
1908	credit_card	400	2017-02-04 07:48:29
1909	credit_card	1500	2017-02-04 10:38:41
1910	credit_card	4500	2017-02-04 13:15:25
1911	credit_card	3400	2017-02-05 10:50:37
1912	cash	5100	2017-02-05 11:06:22
1913	digital_wallet	800	2017-02-05 11:27:29
1914	credit_card	4500	2017-02-05 11:33:21
1915	debit_card	3000	2017-02-05 23:16:30
1916	digital_wallet	1700	2017-02-06 08:54:31
1917	cash	800	2017-02-06 09:29:30
1918	credit_card	6000	2017-02-06 16:16:36
1919	credit_card	800	2017-02-07 10:40:32
1920	debit_card	4500	2017-02-10 10:19:30
1921	debit_card	3400	2017-02-11 11:37:47
1922	debit_card	3400	2017-02-11 13:32:03
1923	cash	800	2017-02-11 14:17:24
1924	credit_card	6000	2017-02-11 14:48:33
1925	credit_card	3000	2017-02-11 19:01:04

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;