Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,976–2,000 of 5,412

payment, page 80 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1976	digital_wallet	1500	2017-03-05 18:31:56
1977	debit_card	800	2017-03-06 09:55:06
1978	debit_card	6800	2017-03-06 11:03:51
1979	credit_card	3000	2017-03-06 15:04:44
1980	credit_card	400	2017-03-06 15:15:32
1981	credit_card	3400	2017-03-07 09:53:45
1982	digital_wallet	3400	2017-03-07 12:41:19
1983	cash	3400	2017-03-08 08:58:08
1984	cash	800	2017-03-08 10:15:52
1985	credit_card	3400	2017-03-08 13:30:15
1986	debit_card	1500	2017-03-09 13:42:08
1987	debit_card	400	2017-03-10 01:20:16
1988	digital_wallet	3000	2017-03-10 07:36:14
1989	credit_card	4500	2017-03-10 10:47:22
1990	debit_card	800	2017-03-10 12:50:37
1991	credit_card	800	2017-03-10 12:54:12
1992	credit_card	4500	2017-03-12 19:46:51
1993	credit_card	1500	2017-03-12 23:04:46
1994	credit_card	800	2017-03-13 09:55:04
1995	debit_card	400	2017-03-15 04:00:45
1996	cash	8500	2017-03-15 10:39:01
1997	debit_card	800	2017-03-15 14:56:03
1998	credit_card	3000	2017-03-16 12:07:44
1999	debit_card	4500	2017-03-16 12:33:19
2000	credit_card	1500	2017-03-17 10:57:03

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;