Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,276–1,300 of 5,412

payment, page 52 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1276	debit_card	6000	2016-06-02 15:48:22
1277	debit_card	4500	2016-06-02 22:02:58
1278	debit_card	1500	2016-06-03 08:09:00
1279	credit_card	3000	2016-06-03 16:50:20
1280	debit_card	400	2016-06-03 21:02:55
1281	credit_card	6000	2016-06-03 23:41:52
1282	credit_card	800	2016-06-04 10:33:16
1283	debit_card	3400	2016-06-04 12:06:47
1284	credit_card	800	2016-06-04 12:57:27
1285	debit_card	3000	2016-06-04 13:48:16
1286	debit_card	1500	2016-06-05 11:07:22
1287	credit_card	1500	2016-06-05 21:22:44
1288	debit_card	3400	2016-06-06 11:08:28
1289	credit_card	3400	2016-06-06 12:22:54
1290	debit_card	800	2016-06-06 13:14:03
1291	debit_card	3400	2016-06-08 11:48:54
1292	debit_card	400	2016-06-09 07:26:03
1293	credit_card	7500	2016-06-09 07:52:49
1294	credit_card	3400	2016-06-09 09:48:00
1295	digital_wallet	800	2016-06-09 10:13:57
1296	credit_card	800	2016-06-09 10:27:10
1297	cash	1700	2016-06-09 10:48:45
1298	cash	5100	2016-06-09 11:18:08
1299	digital_wallet	800	2016-06-09 12:00:14
1300	cash	3400	2016-06-10 10:45:37

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;