diff options
| author | Jesse Luehrs <doy@tozt.net> | 2019-08-27 03:46:40 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2019-08-27 03:46:40 -0400 |
| commit | fab9d941cbcaa3181b7ccb9107d84aa72ee655d8 (patch) | |
| tree | 49be737b627cba713e9f828de1dc8e37dbaa65c4 /data/tax_returns.sql | |
| parent | aedbaabbe441118e496e442d18ce6ed1495483ba (diff) | |
| download | metabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.tar.gz metabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.zip | |
also track income reported on tax returns
Diffstat (limited to 'data/tax_returns.sql')
| -rw-r--r-- | data/tax_returns.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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 +); |