Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,151–1,175 of 5,412

payment, page 47 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1151	debit_card	400	2016-04-21 21:37:05
1152	credit_card	800	2016-04-22 11:14:14
1153	debit_card	800	2016-04-22 11:15:04
1154	credit_card	3000	2016-04-22 16:04:49
1155	debit_card	800	2016-04-24 10:28:20
1156	debit_card	400	2016-04-24 10:56:42
1157	credit_card	1500	2016-04-24 13:35:34
1158	credit_card	400	2016-04-24 22:11:36
1159	credit_card	400	2016-04-25 07:06:34
1160	credit_card	3400	2016-04-26 08:41:45
1161	credit_card	400	2016-04-26 15:06:14
1162	debit_card	1700	2016-04-26 16:25:54
1163	debit_card	800	2016-04-26 17:05:16
1164	credit_card	4500	2016-04-27 14:19:30
1165	debit_card	4500	2016-04-27 21:00:19
1166	credit_card	6000	2016-04-28 15:46:29
1167	debit_card	7500	2016-04-30 07:09:32
1168	cash	5100	2016-04-30 11:25:46
1169	credit_card	4500	2016-04-30 16:41:46
1170	credit_card	3000	2016-04-30 19:24:52
1171	digital_wallet	6800	2016-05-01 09:31:11
1172	credit_card	3400	2016-05-01 11:22:45
1173	debit_card	1500	2016-05-01 12:14:33
1174	cash	3400	2016-05-01 16:45:09
1175	debit_card	800	2016-05-01 17:22: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;