Table

payment

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

Replaces in 2020: Payment Methods

Rows 976–1,000 of 5,412

payment, page 40 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
976	debit_card	1500	2016-01-30 13:37:50
977	debit_card	3000	2016-02-01 17:16:07
978	credit_card	3000	2016-02-01 23:12:30
979	cash	1700	2016-02-02 09:35:35
980	digital_wallet	3400	2016-02-03 10:43:23
981	credit_card	400	2016-02-04 00:24:06
982	cash	800	2016-02-04 12:41:47
983	credit_card	400	2016-02-06 07:59:49
984	credit_card	1500	2016-02-06 23:41:16
985	cash	3400	2016-02-07 10:57:48
986	credit_card	800	2016-02-07 11:34:46
987	credit_card	1700	2016-02-07 13:13:15
988	cash	800	2016-02-07 13:42:58
989	credit_card	400	2016-02-07 21:55:14
990	digital_wallet	5100	2016-02-09 11:54:11
991	cash	800	2016-02-09 12:43:07
992	debit_card	800	2016-02-09 12:50:26
993	debit_card	3400	2016-02-09 13:06:47
994	credit_card	1500	2016-02-09 14:08:56
995	credit_card	4500	2016-02-10 19:19:34
996	credit_card	4500	2016-02-12 12:16:24
997	credit_card	400	2016-02-14 12:31:13
998	debit_card	6800	2016-02-14 15:58:58
999	cash	800	2016-02-14 16:31:58
1000	digital_wallet	800	2016-02-14 16:38:16

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;