Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 5,401–5,412 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 5401 | credit_card | 4500 | 2020-02-22 09:22:44 |
| 5402 | debit_card | 400 | 2020-02-22 11:46:56 |
| 5403 | credit_card | 1500 | 2020-02-23 17:00:12 |
| 5404 | debit_card | 400 | 2020-02-24 01:32:13 |
| 5405 | credit_card | 400 | 2020-02-24 09:04:21 |
| 5406 | cash | 800 | 2020-02-24 12:05:36 |
| 5407 | digital_wallet | 800 | 2020-02-24 16:10:59 |
| 5408 | debit_card | 1500 | 2020-02-24 23:08:17 |
| 5409 | digital_wallet | 3000 | 2020-02-26 07:02:15 |
| 5410 | digital_wallet | 4500 | 2020-02-28 07:08:45 |
| 5411 | credit_card | 400 | 2020-02-29 01:37:23 |
| 5412 | credit_card | 400 | 2020-02-29 02:06:12 |
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;