Table

payment

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

Replaces in 2020: Payment Methods

Rows 76–100 of 5,412

payment, page 4 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
76	credit_card	3000	2015-03-29 14:48:55
77	debit_card	1500	2015-03-29 15:15:54
78	cash	3400	2015-03-30 11:21:11
79	debit_card	3000	2015-03-30 18:45:11
80	cash	800	2015-03-31 14:25:28
81	digital_wallet	800	2015-03-31 14:30:49
82	credit_card	400	2015-03-31 19:53:08
83	cash	1700	2015-04-01 09:32:43
84	credit_card	1500	2015-04-01 10:21:30
85	digital_wallet	6800	2015-04-01 13:56:46
86	credit_card	800	2015-04-01 14:30:52
87	credit_card	3000	2015-04-01 18:55:46
88	credit_card	1500	2015-04-01 21:10:14
89	debit_card	1700	2015-04-02 15:10:15
90	debit_card	3000	2015-04-02 15:25:42
91	credit_card	3000	2015-04-03 14:59:24
92	debit_card	400	2015-04-03 21:48:25
93	credit_card	3400	2015-04-04 09:33:13
94	credit_card	800	2015-04-04 10:34:18
95	credit_card	400	2015-04-04 11:15:39
96	cash	5100	2015-04-04 14:04:25
97	credit_card	400	2015-04-04 20:39:20
98	debit_card	1500	2015-04-05 07:59:55
99	credit_card	3400	2015-04-05 09:06:10
100	debit_card	6800	2015-04-05 09:28:28

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;