Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,676–1,700 of 5,412

payment, page 68 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1676	credit_card	800	2016-10-29 09:56:46
1677	debit_card	3400	2016-10-30 15:00:24
1678	credit_card	400	2016-10-30 23:42:31
1679	debit_card	400	2016-11-01 01:00:55
1680	digital_wallet	3000	2016-11-01 09:11:43
1681	debit_card	400	2016-11-01 18:53:30
1682	credit_card	400	2016-11-01 21:30:11
1683	credit_card	6000	2016-11-01 22:24:57
1684	credit_card	3400	2016-11-02 08:39:46
1685	debit_card	400	2016-11-02 15:10:49
1686	debit_card	58500	2016-11-03 11:29:42
1687	credit_card	400	2016-11-03 17:57:19
1688	digital_wallet	3000	2016-11-04 09:13:42
1689	debit_card	3000	2016-11-04 23:13:38
1690	debit_card	3400	2016-11-05 10:29:25
1691	credit_card	1500	2016-11-05 11:54:20
1692	credit_card	3000	2016-11-06 12:28:33
1693	credit_card	5100	2016-11-07 08:52:36
1694	debit_card	3000	2016-11-07 12:56:39
1695	debit_card	400	2016-11-08 06:41:42
1696	debit_card	6800	2016-11-08 11:09:53
1697	credit_card	3000	2016-11-08 18:14:48
1698	credit_card	400	2016-11-09 08:44:34
1699	credit_card	1500	2016-11-10 12:34:42
1700	credit_card	400	2016-11-10 19:32:30

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;