Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,251–1,275 of 5,412

payment, page 51 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1251	credit_card	400	2016-05-25 06:50:37
1252	credit_card	3000	2016-05-25 07:00:47
1253	credit_card	800	2016-05-25 10:45:36
1254	credit_card	3000	2016-05-25 13:25:40
1255	credit_card	1700	2016-05-26 11:23:40
1256	cash	800	2016-05-26 11:39:58
1257	cash	3400	2016-05-26 13:41:26
1258	debit_card	1500	2016-05-26 18:05:31
1259	credit_card	3400	2016-05-28 09:56:48
1260	cash	800	2016-05-28 10:54:19
1261	cash	3400	2016-05-28 15:01:07
1262	credit_card	800	2016-05-28 15:34:43
1263	credit_card	3000	2016-05-29 10:25:33
1264	credit_card	800	2016-05-29 12:26:46
1265	credit_card	3400	2016-05-29 12:42:49
1266	debit_card	800	2016-05-29 15:03:54
1267	debit_card	5100	2016-05-29 15:33:00
1268	credit_card	3000	2016-05-31 15:54:02
1269	credit_card	400	2016-05-31 16:10:00
1270	credit_card	3000	2016-05-31 18:29:10
1271	cash	3400	2016-06-01 09:46:52
1272	credit_card	8500	2016-06-01 13:51:16
1273	debit_card	1700	2016-06-02 09:14:42
1274	credit_card	800	2016-06-02 09:42:15
1275	cash	1700	2016-06-02 10:34:44

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;