Table

payment

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

Replaces in 2020: Payment Methods

Rows 926–950 of 5,412

payment, page 38 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
926	debit_card	400	2015-12-31 06:03:56
927	credit_card	1700	2015-12-31 10:09:50
928	debit_card	3400	2015-12-31 12:10:53
929	credit_card	800	2015-12-31 12:58:27
930	credit_card	7500	2015-12-31 14:57:33
931	credit_card	3000	2015-12-31 22:24:19
932	debit_card	400	2016-01-01 13:39:29
933	credit_card	7500	2016-01-01 22:53:21
934	debit_card	1500	2016-01-02 08:47:23
935	credit_card	1700	2016-01-03 09:34:06
936	credit_card	800	2016-01-03 12:46:50
937	debit_card	6000	2016-01-05 09:31:03
938	debit_card	4500	2016-01-05 09:53:42
939	credit_card	3400	2016-01-05 10:40:51
940	debit_card	800	2016-01-05 11:24:15
941	cash	800	2016-01-05 11:25:50
942	debit_card	3000	2016-01-06 09:52:23
943	credit_card	400	2016-01-07 07:20:06
944	credit_card	1500	2016-01-07 09:09:56
945	debit_card	69000	2016-01-07 09:54:49
946	credit_card	400	2016-01-07 17:23:26
947	credit_card	400	2016-01-08 03:16:42
948	digital_wallet	1700	2016-01-10 12:08:38
949	credit_card	3000	2016-01-10 16:27:50
950	debit_card	800	2016-01-12 12:02:18

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;