From fab9d941cbcaa3181b7ccb9107d84aa72ee655d8 Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Tue, 27 Aug 2019 03:46:40 -0400 Subject: also track income reported on tax returns --- data/tax_returns.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 data/tax_returns.sql (limited to 'data/tax_returns.sql') diff --git a/data/tax_returns.sql b/data/tax_returns.sql new file mode 100644 index 0000000..6a7ee19 --- /dev/null +++ b/data/tax_returns.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS taxes; +DROP TABLE IF EXISTS tax_returns; + +CREATE TABLE tax_returns ( + year date PRIMARY KEY, + total_income bigint, + total_tax bigint +); -- cgit v1.2.3-54-g00ecf