Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,001–1,025 of 5,412

payment, page 41 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1001	digital_wallet	1500	2016-02-15 12:09:31
1002	cash	5100	2016-02-16 09:06:59
1003	credit_card	800	2016-02-16 09:55:13
1004	digital_wallet	8500	2016-02-16 16:14:53
1005	credit_card	1500	2016-02-16 17:41:16
1006	debit_card	1500	2016-02-16 18:31:46
1007	debit_card	5100	2016-02-17 15:29:59
1008	cash	6800	2016-02-18 11:15:14
1009	cash	800	2016-02-18 11:53:57
1010	credit_card	800	2016-02-18 13:42:53
1011	cash	6800	2016-02-18 15:16:56
1012	credit_card	4500	2016-02-19 10:08:10
1013	credit_card	3000	2016-02-19 13:40:39
1014	digital_wallet	1700	2016-02-19 16:37:28
1015	credit_card	1700	2016-02-20 11:22:23
1016	debit_card	400	2016-02-20 18:50:14
1017	debit_card	400	2016-02-22 11:23:40
1018	credit_card	400	2016-02-23 10:23:38
1019	cash	6800	2016-02-23 10:32:41
1020	credit_card	400	2016-02-24 18:43:42
1021	credit_card	1700	2016-02-25 13:04:46
1022	credit_card	800	2016-02-25 13:54:54
1023	credit_card	800	2016-02-26 11:07:28
1024	debit_card	400	2016-02-26 23:39:33
1025	debit_card	8500	2016-02-27 12:59:19

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;