Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 2,576–2,600 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 2576 | credit_card | 3000 | 2017-09-22 11:52:12 |
| 2577 | cash | 3400 | 2017-09-22 14:27:30 |
| 2578 | debit_card | 800 | 2017-09-22 15:15:37 |
| 2579 | credit_card | 400 | 2017-09-23 16:33:28 |
| 2580 | debit_card | 1500 | 2017-09-24 09:07:02 |
| 2581 | credit_card | 800 | 2017-09-24 09:57:20 |
| 2582 | cash | 6800 | 2017-09-26 11:29:15 |
| 2583 | credit_card | 400 | 2017-09-26 22:28:39 |
| 2584 | debit_card | 1700 | 2017-09-27 15:27:41 |
| 2585 | debit_card | 3400 | 2017-09-27 15:51:15 |
| 2586 | credit_card | 400 | 2017-09-27 19:47:14 |
| 2587 | credit_card | 1700 | 2017-09-28 12:21:08 |
| 2588 | credit_card | 3000 | 2017-09-28 13:49:14 |
| 2589 | credit_card | 1500 | 2017-09-29 10:48:27 |
| 2590 | debit_card | 3400 | 2017-09-29 11:35:26 |
| 2591 | digital_wallet | 6800 | 2017-09-30 08:26:01 |
| 2592 | digital_wallet | 800 | 2017-09-30 09:11:57 |
| 2593 | credit_card | 4500 | 2017-09-30 11:06:48 |
| 2594 | cash | 1700 | 2017-10-01 09:15:14 |
| 2595 | debit_card | 800 | 2017-10-01 10:49:42 |
| 2596 | credit_card | 87000 | 2017-10-01 13:20:13 |
| 2597 | credit_card | 800 | 2017-10-01 15:17:41 |
| 2598 | cash | 1700 | 2017-10-02 09:07:02 |
| 2599 | credit_card | 800 | 2017-10-02 09:44:04 |
| 2600 | credit_card | 3400 | 2017-10-02 10:08:00 |
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;