Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 1,526–1,550 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 1526 | debit_card | 4500 | 2016-08-21 16:49:20 |
| 1527 | credit_card | 400 | 2016-08-22 12:22:12 |
| 1528 | digital_wallet | 7500 | 2016-08-22 19:47:17 |
| 1529 | credit_card | 3000 | 2016-08-23 20:49:30 |
| 1530 | credit_card | 400 | 2016-08-24 03:29:10 |
| 1531 | credit_card | 3400 | 2016-08-24 09:08:51 |
| 1532 | debit_card | 55500 | 2016-08-25 11:18:11 |
| 1533 | debit_card | 4500 | 2016-08-25 15:48:13 |
| 1534 | debit_card | 3000 | 2016-08-26 08:40:24 |
| 1535 | credit_card | 6800 | 2016-08-26 09:03:46 |
| 1536 | credit_card | 3400 | 2016-08-26 09:18:24 |
| 1537 | cash | 800 | 2016-08-26 09:21:12 |
| 1538 | digital_wallet | 4500 | 2016-08-26 11:13:56 |
| 1539 | credit_card | 3400 | 2016-08-26 11:32:47 |
| 1540 | cash | 800 | 2016-08-26 12:12:22 |
| 1541 | debit_card | 800 | 2016-08-26 14:55:36 |
| 1542 | debit_card | 800 | 2016-08-26 14:56:03 |
| 1543 | digital_wallet | 1700 | 2016-08-27 09:45:32 |
| 1544 | debit_card | 3000 | 2016-08-27 20:29:26 |
| 1545 | debit_card | 3000 | 2016-08-28 08:26:37 |
| 1546 | debit_card | 1700 | 2016-08-28 10:51:37 |
| 1547 | credit_card | 3400 | 2016-08-29 11:15:52 |
| 1548 | credit_card | 800 | 2016-08-29 11:50:30 |
| 1549 | credit_card | 7500 | 2016-08-29 12:30:07 |
| 1550 | credit_card | 1500 | 2016-08-29 21:53:49 |
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;