Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,126–1,150 of 5,412

payment, page 46 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1126	credit_card	1500	2016-04-10 17:44:01
1127	credit_card	3000	2016-04-10 20:54:27
1128	debit_card	1500	2016-04-11 22:33:06
1129	debit_card	400	2016-04-12 03:04:07
1130	credit_card	400	2016-04-12 13:47:19
1131	debit_card	3000	2016-04-12 18:39:33
1132	credit_card	6000	2016-04-13 10:19:47
1133	credit_card	400	2016-04-13 15:57:25
1134	debit_card	3000	2016-04-13 20:37:35
1135	credit_card	6800	2016-04-14 13:34:51
1136	credit_card	800	2016-04-16 10:19:16
1137	credit_card	3400	2016-04-16 12:20:33
1138	cash	800	2016-04-16 13:06:04
1139	digital_wallet	1700	2016-04-16 15:30:08
1140	debit_card	3000	2016-04-16 17:50:28
1141	debit_card	3400	2016-04-17 09:45:31
1142	debit_card	800	2016-04-17 10:25:09
1143	cash	800	2016-04-17 10:34:45
1144	debit_card	1500	2016-04-18 18:32:11
1145	debit_card	1700	2016-04-19 08:35:31
1146	credit_card	6000	2016-04-19 09:07:26
1147	cash	800	2016-04-19 09:15:18
1148	credit_card	5100	2016-04-19 10:13:07
1149	credit_card	6000	2016-04-19 19:48:27
1150	debit_card	1500	2016-04-20 18:23:45

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;