Table

payment

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

Replaces in 2020: Payment Methods

Rows 951–975 of 5,412

payment, page 39 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
951	credit_card	3000	2016-01-15 12:16:01
952	digital_wallet	800	2016-01-15 15:17:38
953	credit_card	1700	2016-01-16 12:53:42
954	digital_wallet	4500	2016-01-16 18:16:39
955	credit_card	400	2016-01-17 10:17:45
956	credit_card	3400	2016-01-18 08:42:44
957	digital_wallet	800	2016-01-18 10:11:49
958	debit_card	1500	2016-01-18 11:12:57
959	digital_wallet	7500	2016-01-18 11:50:54
960	credit_card	1500	2016-01-21 14:11:39
961	credit_card	3000	2016-01-21 15:13:30
962	cash	800	2016-01-22 10:47:26
963	debit_card	5100	2016-01-23 08:45:41
964	debit_card	3400	2016-01-23 09:20:04
965	debit_card	800	2016-01-23 09:32:43
966	debit_card	3400	2016-01-23 10:53:35
967	cash	800	2016-01-23 11:30:58
968	cash	5100	2016-01-23 11:41:22
969	cash	800	2016-01-23 12:22:56
970	debit_card	400	2016-01-23 17:47:32
971	cash	1700	2016-01-24 10:12:57
972	cash	3400	2016-01-26 10:29:00
973	digital_wallet	3000	2016-01-29 18:14:20
974	credit_card	400	2016-01-30 00:33:43
975	credit_card	5100	2016-01-30 12:23:14

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;