Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 2,001–2,025 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 2001 | credit_card | 1700 | 2017-03-17 14:14:36 |
| 2002 | cash | 800 | 2017-03-17 14:56:43 |
| 2003 | credit_card | 1700 | 2017-03-18 11:28:45 |
| 2004 | credit_card | 3000 | 2017-03-18 19:42:03 |
| 2005 | credit_card | 4500 | 2017-03-18 20:50:32 |
| 2006 | debit_card | 66000 | 2017-03-19 12:26:00 |
| 2007 | digital_wallet | 3000 | 2017-03-21 10:19:29 |
| 2008 | cash | 3400 | 2017-03-21 10:27:27 |
| 2009 | credit_card | 400 | 2017-03-22 10:20:17 |
| 2010 | credit_card | 3000 | 2017-03-22 11:57:09 |
| 2011 | credit_card | 400 | 2017-03-22 18:48:30 |
| 2012 | debit_card | 3000 | 2017-03-23 07:41:14 |
| 2013 | debit_card | 1500 | 2017-03-23 13:32:39 |
| 2014 | cash | 1700 | 2017-03-23 14:08:54 |
| 2015 | credit_card | 1500 | 2017-03-24 20:00:27 |
| 2016 | debit_card | 1700 | 2017-03-25 09:50:54 |
| 2017 | cash | 800 | 2017-03-25 11:16:21 |
| 2018 | cash | 800 | 2017-03-25 13:11:47 |
| 2019 | credit_card | 800 | 2017-03-25 15:16:46 |
| 2020 | credit_card | 800 | 2017-03-25 15:41:27 |
| 2021 | digital_wallet | 1500 | 2017-03-25 20:07:30 |
| 2022 | credit_card | 400 | 2017-03-26 08:36:03 |
| 2023 | credit_card | 400 | 2017-03-26 12:17:01 |
| 2024 | credit_card | 1500 | 2017-03-26 21:21:31 |
| 2025 | credit_card | 3000 | 2017-03-28 09:26:11 |
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;