Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,476–1,500 of 5,412

payment, page 60 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1476	debit_card	1700	2016-08-06 14:21:02
1477	digital_wallet	4500	2016-08-06 15:17:58
1478	cash	800	2016-08-07 10:01:43
1479	cash	6800	2016-08-07 11:58:00
1480	credit_card	800	2016-08-07 12:27:26
1481	debit_card	1500	2016-08-07 14:05:03
1482	cash	3400	2016-08-09 14:12:16
1483	credit_card	800	2016-08-09 15:30:00
1484	credit_card	400	2016-08-10 07:52:47
1485	debit_card	400	2016-08-10 15:52:49
1486	cash	5100	2016-08-11 10:27:40
1487	cash	1700	2016-08-11 10:55:10
1488	debit_card	800	2016-08-11 11:22:05
1489	debit_card	3400	2016-08-11 11:33:32
1490	debit_card	8500	2016-08-11 12:56:15
1491	digital_wallet	800	2016-08-11 13:40:10
1492	credit_card	6000	2016-08-12 15:13:07
1493	digital_wallet	1500	2016-08-12 21:38:51
1494	cash	3400	2016-08-13 10:08:32
1495	credit_card	800	2016-08-13 10:36:50
1496	debit_card	4500	2016-08-13 13:47:25
1497	cash	800	2016-08-13 14:49:39
1498	debit_card	8500	2016-08-14 08:26:34
1499	credit_card	6800	2016-08-14 10:39:53
1500	cash	800	2016-08-14 11:17:40

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;