Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,226–1,250 of 5,412

payment, page 50 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1226	credit_card	1500	2016-05-14 21:26:52
1227	credit_card	400	2016-05-14 23:24:03
1228	credit_card	4500	2016-05-15 13:05:06
1229	credit_card	4500	2016-05-15 22:54:40
1230	digital_wallet	3000	2016-05-16 09:56:50
1231	debit_card	3400	2016-05-16 11:28:36
1232	credit_card	400	2016-05-16 14:23:17
1233	credit_card	3000	2016-05-17 13:21:51
1234	credit_card	4500	2016-05-17 14:57:32
1235	credit_card	400	2016-05-17 15:48:02
1236	debit_card	400	2016-05-17 18:18:28
1237	credit_card	6000	2016-05-17 22:37:20
1238	debit_card	3400	2016-05-18 11:07:34
1239	digital_wallet	800	2016-05-18 11:40:41
1240	credit_card	3000	2016-05-18 13:56:40
1241	credit_card	800	2016-05-18 15:00:05
1242	credit_card	400	2016-05-19 22:07:35
1243	cash	800	2016-05-20 10:51:31
1244	credit_card	1500	2016-05-21 11:59:41
1245	debit_card	3000	2016-05-22 11:58:37
1246	debit_card	400	2016-05-22 23:46:37
1247	debit_card	800	2016-05-23 09:23:16
1248	cash	800	2016-05-23 09:34:21
1249	debit_card	3000	2016-05-23 11:31:01
1250	debit_card	1500	2016-05-24 21:17:15

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;