Table
payment
One row per payment; the method is a single column.
Replaces in 2020: Payment Methods
Rows 1,951–1,975 of 5,412
| payment_idINTEGER | methodTEXT | amount_centsINTEGER | paid_atTEXT |
|---|---|---|---|
| 1951 | credit_card | 1500 | 2017-02-22 18:50:47 |
| 1952 | credit_card | 400 | 2017-02-23 12:18:26 |
| 1953 | debit_card | 800 | 2017-02-24 13:34:00 |
| 1954 | credit_card | 1500 | 2017-02-24 15:50:35 |
| 1955 | credit_card | 3000 | 2017-02-24 17:10:45 |
| 1956 | credit_card | 400 | 2017-02-24 18:40:35 |
| 1957 | credit_card | 400 | 2017-02-24 19:53:51 |
| 1958 | debit_card | 1500 | 2017-02-25 10:43:03 |
| 1959 | credit_card | 6000 | 2017-02-26 08:09:02 |
| 1960 | credit_card | 800 | 2017-02-26 13:20:40 |
| 1961 | cash | 3400 | 2017-02-27 09:51:22 |
| 1962 | debit_card | 3400 | 2017-02-28 09:12:27 |
| 1963 | debit_card | 6800 | 2017-03-01 10:27:06 |
| 1964 | cash | 800 | 2017-03-01 10:51:15 |
| 1965 | credit_card | 7500 | 2017-03-01 12:55:10 |
| 1966 | credit_card | 400 | 2017-03-01 13:39:25 |
| 1967 | credit_card | 3000 | 2017-03-02 14:03:25 |
| 1968 | credit_card | 6800 | 2017-03-03 10:05:54 |
| 1969 | credit_card | 4500 | 2017-03-03 10:15:23 |
| 1970 | credit_card | 1500 | 2017-03-03 10:22:11 |
| 1971 | credit_card | 800 | 2017-03-03 10:52:08 |
| 1972 | credit_card | 1500 | 2017-03-04 09:17:13 |
| 1973 | debit_card | 800 | 2017-03-05 09:24:17 |
| 1974 | cash | 3400 | 2017-03-05 10:42:53 |
| 1975 | debit_card | 800 | 2017-03-05 11:12:43 |
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;