Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 2,351–2,375 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 2351 | credit_card | 400 | 2017-07-13 13:12:43 |
| 2352 | credit_card | 400 | 2017-07-14 02:02:06 |
| 2353 | digital_wallet | 800 | 2017-07-14 11:11:36 |
| 2354 | cash | 3400 | 2017-07-14 11:55:15 |
| 2355 | credit_card | 800 | 2017-07-14 12:26:37 |
| 2356 | credit_card | 3000 | 2017-07-15 08:46:24 |
| 2357 | debit_card | 400 | 2017-07-15 09:30:33 |
| 2358 | credit_card | 1700 | 2017-07-15 13:11:16 |
| 2359 | credit_card | 6800 | 2017-07-16 10:31:37 |
| 2360 | cash | 800 | 2017-07-16 11:05:25 |
| 2361 | debit_card | 800 | 2017-07-16 11:07:17 |
| 2362 | cash | 8500 | 2017-07-16 11:33:58 |
| 2363 | credit_card | 6000 | 2017-07-16 13:44:20 |
| 2364 | digital_wallet | 3000 | 2017-07-17 12:32:23 |
| 2365 | credit_card | 400 | 2017-07-17 20:22:22 |
| 2366 | credit_card | 3000 | 2017-07-17 23:25:12 |
| 2367 | debit_card | 7500 | 2017-07-18 09:35:12 |
| 2368 | cash | 1700 | 2017-07-18 11:06:28 |
| 2369 | credit_card | 3000 | 2017-07-18 16:10:23 |
| 2370 | credit_card | 5100 | 2017-07-18 16:12:35 |
| 2371 | cash | 800 | 2017-07-18 16:51:13 |
| 2372 | credit_card | 800 | 2017-07-19 11:33:12 |
| 2373 | credit_card | 4500 | 2017-07-19 15:47:02 |
| 2374 | digital_wallet | 4500 | 2017-07-19 23:41:56 |
| 2375 | credit_card | 7500 | 2017-07-20 10:18:35 |
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;