Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Rows 2,551–2,575 of 5,412

payment, page 103 of 217
payment_idINTEGER	methodTEXT	amount_centsINTEGER	paid_atTEXT
2551	credit_card	800	2017-09-13 10:34:17
2552	credit_card	3400	2017-09-13 16:52:09
2553	credit_card	400	2017-09-14 02:05:51
2554	debit_card	3400	2017-09-15 10:03:48
2555	debit_card	6000	2017-09-15 11:15:42
2556	debit_card	400	2017-09-15 17:31:14
2557	credit_card	63000	2017-09-15 17:48:24
2558	credit_card	400	2017-09-16 06:12:09
2559	debit_card	1500	2017-09-16 07:08:55
2560	cash	800	2017-09-16 10:18:17
2561	debit_card	800	2017-09-16 10:28:37
2562	credit_card	800	2017-09-16 10:28:56
2563	credit_card	400	2017-09-16 13:37:23
2564	debit_card	400	2017-09-16 13:38:15
2565	debit_card	3400	2017-09-17 09:34:09
2566	cash	800	2017-09-17 10:24:42
2567	credit_card	8500	2017-09-17 11:51:12
2568	credit_card	4500	2017-09-17 13:10:32
2569	digital_wallet	1500	2017-09-19 08:03:34
2570	credit_card	1500	2017-09-20 07:31:09
2571	credit_card	3400	2017-09-20 09:41:42
2572	digital_wallet	4500	2017-09-20 15:18:03
2573	credit_card	400	2017-09-22 04:28:54
2574	credit_card	3000	2017-09-22 07:44:49
2575	cash	3400	2017-09-22 10:43:09

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;