Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,451–1,475 of 5,412

payment, page 59 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1451	cash	3400	2016-07-31 11:04:10
1452	digital_wallet	800	2016-07-31 11:17:57
1453	debit_card	800	2016-07-31 11:22:16
1454	cash	800	2016-07-31 11:51:22
1455	credit_card	800	2016-07-31 13:19:49
1456	credit_card	400	2016-07-31 14:01:57
1457	credit_card	800	2016-07-31 17:09:22
1458	debit_card	400	2016-08-01 02:00:07
1459	debit_card	800	2016-08-02 10:05:39
1460	credit_card	3000	2016-08-02 12:23:15
1461	credit_card	1700	2016-08-02 13:06:41
1462	credit_card	4500	2016-08-02 15:04:23
1463	credit_card	3000	2016-08-02 15:07:12
1464	credit_card	800	2016-08-02 15:33:40
1465	credit_card	400	2016-08-02 22:34:38
1466	credit_card	400	2016-08-03 03:33:53
1467	credit_card	400	2016-08-03 21:49:55
1468	credit_card	4500	2016-08-04 08:22:41
1469	credit_card	3000	2016-08-04 18:27:02
1470	debit_card	3400	2016-08-05 12:06:42
1471	credit_card	3000	2016-08-05 19:38:43
1472	credit_card	400	2016-08-06 06:17:52
1473	credit_card	400	2016-08-06 06:35:18
1474	digital_wallet	6800	2016-08-06 09:29:24
1475	credit_card	800	2016-08-06 10:09:53

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;