Table

payment

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

Replaces in 2020: Payment Methods

Rows 1,501–1,525 of 5,412

payment, page 61 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
1501	digital_wallet	7500	2016-08-15 10:16:58
1502	cash	800	2016-08-15 14:12:58
1503	cash	800	2016-08-15 14:13:33
1504	debit_card	8500	2016-08-16 11:46:26
1505	credit_card	800	2016-08-16 12:04:58
1506	digital_wallet	800	2016-08-16 12:06:42
1507	credit_card	800	2016-08-16 12:15:44
1508	debit_card	1500	2016-08-16 16:05:53
1509	credit_card	3000	2016-08-16 20:04:20
1510	debit_card	3000	2016-08-17 10:06:45
1511	credit_card	6000	2016-08-17 17:24:39
1512	credit_card	3000	2016-08-17 20:25:30
1513	credit_card	1700	2016-08-18 10:41:16
1514	debit_card	3000	2016-08-18 12:42:36
1515	debit_card	400	2016-08-19 05:07:22
1516	debit_card	800	2016-08-19 14:47:41
1517	cash	3400	2016-08-20 11:05:01
1518	credit_card	3000	2016-08-20 17:21:57
1519	credit_card	8500	2016-08-21 10:04:44
1520	credit_card	800	2016-08-21 10:49:00
1521	credit_card	7500	2016-08-21 11:11:20
1522	debit_card	800	2016-08-21 14:00:47
1523	cash	800	2016-08-21 14:44:31
1524	debit_card	400	2016-08-21 15:13:20
1525	debit_card	1500	2016-08-21 16:49:08

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;