Table

payment

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

Replaces in 2020: Payment Methods

Rows 2,301–2,325 of 5,412

payment, page 93 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
2301	debit_card	800	2017-06-28 14:44:29
2302	credit_card	57000	2017-06-28 15:13:55
2303	credit_card	3000	2017-06-28 15:15:12
2304	debit_card	3000	2017-06-29 09:27:47
2305	credit_card	6000	2017-06-29 13:21:45
2306	digital_wallet	3000	2017-06-30 14:35:38
2307	credit_card	6000	2017-06-30 14:46:23
2308	cash	6800	2017-07-01 09:17:42
2309	credit_card	3400	2017-07-01 12:30:53
2310	cash	800	2017-07-01 13:05:44
2311	cash	6800	2017-07-01 15:03:27
2312	credit_card	800	2017-07-01 15:43:10
2313	credit_card	1500	2017-07-02 13:07:55
2314	credit_card	3000	2017-07-03 09:50:04
2315	debit_card	400	2017-07-03 13:51:20
2316	debit_card	1700	2017-07-04 11:28:35
2317	credit_card	1700	2017-07-04 13:54:54
2318	digital_wallet	3000	2017-07-04 19:07:50
2319	credit_card	1500	2017-07-04 19:40:44
2320	credit_card	400	2017-07-05 05:16:03
2321	credit_card	3000	2017-07-05 09:54:51
2322	credit_card	1700	2017-07-05 10:51:30
2323	cash	800	2017-07-05 10:55:02
2324	credit_card	1700	2017-07-05 13:33:24
2325	credit_card	800	2017-07-05 14:06:04

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;