Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,176–1,200 of 5,412

payment, page 48 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1176	credit_card	400	2016-05-01 18:03:43
1177	credit_card	400	2016-05-02 01:17:26
1178	cash	3400	2016-05-02 08:39:38
1179	digital_wallet	3000	2016-05-02 08:45:21
1180	cash	800	2016-05-02 09:31:42
1181	cash	3400	2016-05-02 09:59:46
1182	digital_wallet	800	2016-05-02 10:11:47
1183	credit_card	4500	2016-05-02 17:23:35
1184	digital_wallet	3000	2016-05-02 21:14:06
1185	credit_card	3000	2016-05-03 07:38:15
1186	debit_card	1700	2016-05-03 13:29:12
1187	credit_card	1500	2016-05-03 16:48:54
1188	credit_card	3400	2016-05-04 10:20:06
1189	cash	1700	2016-05-04 12:47:33
1190	credit_card	800	2016-05-04 13:07:52
1191	credit_card	400	2016-05-04 21:07:00
1192	credit_card	400	2016-05-04 22:13:59
1193	debit_card	400	2016-05-05 02:03:10
1194	debit_card	4500	2016-05-05 08:10:29
1195	credit_card	400	2016-05-06 01:56:10
1196	debit_card	400	2016-05-06 06:29:35
1197	debit_card	1500	2016-05-06 07:36:18
1198	debit_card	1700	2016-05-06 15:37:09
1199	credit_card	400	2016-05-06 17:06:45
1200	credit_card	1700	2016-05-07 13:24:59

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;