Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,851–1,875 of 5,412

payment, page 75 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1851	debit_card	1500	2017-01-11 10:09:03
1852	credit_card	5100	2017-01-12 14:44:05
1853	debit_card	800	2017-01-12 15:07:22
1854	credit_card	4500	2017-01-13 15:26:58
1855	debit_card	3000	2017-01-13 18:19:45
1856	credit_card	1500	2017-01-14 14:10:36
1857	debit_card	800	2017-01-14 16:08:26
1858	credit_card	400	2017-01-14 20:53:26
1859	credit_card	400	2017-01-15 10:29:48
1860	credit_card	400	2017-01-15 11:58:26
1861	credit_card	3000	2017-01-15 17:19:55
1862	cash	3400	2017-01-16 10:39:44
1863	credit_card	800	2017-01-16 11:15:57
1864	credit_card	3000	2017-01-16 14:29:58
1865	cash	3400	2017-01-17 13:47:24
1866	credit_card	1500	2017-01-18 08:27:07
1867	digital_wallet	3000	2017-01-18 10:53:53
1868	debit_card	400	2017-01-18 11:25:21
1869	debit_card	7500	2017-01-19 16:41:52
1870	credit_card	400	2017-01-20 06:00:50
1871	credit_card	5100	2017-01-20 13:52:33
1872	credit_card	800	2017-01-20 14:44:08
1873	credit_card	800	2017-01-21 10:16:12
1874	credit_card	1500	2017-01-22 07:35:10
1875	credit_card	1500	2017-01-22 10:51:17

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;