Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,601–1,625 of 5,412

payment, page 65 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1601	credit_card	1500	2016-09-20 22:15:15
1602	credit_card	800	2016-09-21 11:23:49
1603	cash	3400	2016-09-21 12:12:26
1604	credit_card	1500	2016-09-22 08:27:52
1605	debit_card	3000	2016-09-22 09:40:22
1606	digital_wallet	5100	2016-09-22 10:14:00
1607	debit_card	800	2016-09-22 10:57:54
1608	debit_card	6800	2016-09-22 14:54:35
1609	cash	800	2016-09-22 16:00:38
1610	digital_wallet	1500	2016-09-23 15:12:06
1611	credit_card	8500	2016-09-24 13:42:16
1612	credit_card	800	2016-09-24 14:05:34
1613	debit_card	800	2016-09-24 14:16:43
1614	debit_card	3000	2016-09-25 07:19:57
1615	credit_card	4500	2016-09-27 09:19:44
1616	debit_card	1700	2016-09-27 09:44:40
1617	debit_card	800	2016-09-27 10:11:30
1618	credit_card	3000	2016-09-27 20:26:00
1619	debit_card	1500	2016-09-27 22:59:09
1620	credit_card	400	2016-09-28 02:49:30
1621	cash	800	2016-09-28 10:58:23
1622	credit_card	800	2016-09-28 10:58:23
1623	digital_wallet	1500	2016-09-29 10:01:22
1624	credit_card	3000	2016-09-29 13:29:02
1625	credit_card	6000	2016-09-30 07:57:40

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;