Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,101–1,125 of 5,412

payment, page 45 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1101	cash	1700	2016-03-29 13:36:19
1102	debit_card	400	2016-03-30 01:14:44
1103	credit_card	7500	2016-03-31 22:24:15
1104	credit_card	4500	2016-04-01 11:14:57
1105	credit_card	3400	2016-04-01 11:22:33
1106	credit_card	800	2016-04-01 12:05:19
1107	debit_card	800	2016-04-01 14:24:41
1108	credit_card	800	2016-04-01 14:26:18
1109	credit_card	3400	2016-04-01 16:11:52
1110	digital_wallet	800	2016-04-01 17:04:03
1111	debit_card	800	2016-04-03 13:11:19
1112	credit_card	400	2016-04-03 18:08:12
1113	credit_card	400	2016-04-04 06:44:32
1114	debit_card	400	2016-04-05 03:51:42
1115	credit_card	4500	2016-04-05 11:32:29
1116	credit_card	1700	2016-04-05 11:35:08
1117	debit_card	1500	2016-04-05 11:43:19
1118	debit_card	1700	2016-04-07 15:29:45
1119	cash	6800	2016-04-08 12:15:14
1120	digital_wallet	6000	2016-04-09 15:09:21
1121	debit_card	3400	2016-04-10 11:13:34
1122	credit_card	3400	2016-04-10 12:43:36
1123	debit_card	800	2016-04-10 13:08:11
1124	cash	6800	2016-04-10 14:41:26
1125	cash	800	2016-04-10 15:10:48

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;