Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,026–1,050 of 5,412

payment, page 42 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1026	debit_card	4500	2016-02-27 13:52:09
1027	credit_card	6000	2016-02-28 08:19:45
1028	debit_card	3000	2016-03-02 07:16:48
1029	credit_card	6000	2016-03-02 08:32:37
1030	credit_card	3400	2016-03-02 16:28:17
1031	credit_card	3000	2016-03-02 22:56:35
1032	credit_card	400	2016-03-03 08:28:50
1033	credit_card	400	2016-03-03 09:13:06
1034	credit_card	3000	2016-03-03 10:00:33
1035	debit_card	400	2016-03-04 09:12:20
1036	credit_card	4500	2016-03-04 20:32:58
1037	digital_wallet	800	2016-03-05 13:22:17
1038	debit_card	8500	2016-03-06 10:21:14
1039	credit_card	3400	2016-03-06 10:28:13
1040	credit_card	400	2016-03-06 19:13:54
1041	debit_card	400	2016-03-07 06:29:20
1042	credit_card	3000	2016-03-07 09:13:05
1043	debit_card	7500	2016-03-07 12:27:28
1044	debit_card	7500	2016-03-07 13:20:35
1045	digital_wallet	3000	2016-03-08 14:00:09
1046	credit_card	3000	2016-03-08 21:54:16
1047	credit_card	400	2016-03-09 01:00:29
1048	digital_wallet	800	2016-03-09 13:18:18
1049	credit_card	6000	2016-03-10 08:58:01
1050	debit_card	800	2016-03-10 12:51:27

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;