Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 1,326–1,350 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 1326 | debit_card | 800 | 2016-06-23 09:42:35 |
| 1327 | debit_card | 5100 | 2016-06-23 13:12:51 |
| 1328 | cash | 800 | 2016-06-23 13:58:07 |
| 1329 | credit_card | 6000 | 2016-06-23 18:17:39 |
| 1330 | credit_card | 800 | 2016-06-24 09:25:18 |
| 1331 | debit_card | 1500 | 2016-06-24 09:54:01 |
| 1332 | credit_card | 1700 | 2016-06-24 09:56:25 |
| 1333 | debit_card | 800 | 2016-06-24 11:41:49 |
| 1334 | credit_card | 800 | 2016-06-24 11:51:46 |
| 1335 | credit_card | 800 | 2016-06-24 13:28:53 |
| 1336 | debit_card | 3400 | 2016-06-24 13:30:25 |
| 1337 | credit_card | 1700 | 2016-06-25 13:15:09 |
| 1338 | credit_card | 1700 | 2016-06-25 13:59:06 |
| 1339 | debit_card | 6000 | 2016-06-25 17:37:38 |
| 1340 | credit_card | 8500 | 2016-06-26 11:47:22 |
| 1341 | cash | 800 | 2016-06-26 12:14:04 |
| 1342 | cash | 800 | 2016-06-26 12:15:51 |
| 1343 | debit_card | 400 | 2016-06-28 10:31:11 |
| 1344 | debit_card | 400 | 2016-06-28 10:47:25 |
| 1345 | credit_card | 4500 | 2016-06-28 14:50:13 |
| 1346 | credit_card | 1700 | 2016-06-29 12:44:04 |
| 1347 | debit_card | 400 | 2016-06-29 18:43:00 |
| 1348 | credit_card | 1500 | 2016-06-29 23:43:10 |
| 1349 | debit_card | 400 | 2016-06-30 04:35:53 |
| 1350 | debit_card | 6000 | 2016-06-30 13:29:36 |
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;