Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,051–1,075 of 5,412

payment, page 43 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1051	credit_card	1500	2016-03-10 16:29:40
1052	debit_card	1500	2016-03-12 13:10:56
1053	cash	6800	2016-03-12 16:38:44
1054	cash	800	2016-03-12 17:08:53
1055	credit_card	87000	2016-03-12 17:39:58
1056	debit_card	7500	2016-03-12 19:48:51
1057	credit_card	400	2016-03-14 08:13:06
1058	credit_card	3000	2016-03-14 17:45:52
1059	credit_card	3000	2016-03-15 10:20:10
1060	credit_card	800	2016-03-16 11:49:34
1061	credit_card	800	2016-03-16 12:07:25
1062	credit_card	800	2016-03-16 13:08:29
1063	credit_card	1700	2016-03-16 13:18:13
1064	debit_card	6000	2016-03-17 13:50:13
1065	debit_card	1700	2016-03-18 10:59:22
1066	credit_card	3000	2016-03-19 12:35:53
1067	credit_card	3000	2016-03-19 14:30:21
1068	cash	800	2016-03-19 15:31:19
1069	digital_wallet	800	2016-03-19 15:35:10
1070	debit_card	6000	2016-03-20 07:50:20
1071	cash	5100	2016-03-20 09:09:34
1072	credit_card	800	2016-03-20 09:38:51
1073	cash	800	2016-03-20 09:57:25
1074	debit_card	800	2016-03-20 11:42:03
1075	debit_card	3000	2016-03-20 13:25:23

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;