diff options
| author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-11 22:47:16 +0200 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-11 22:47:39 +0200 |
| commit | b46012f212a4302b4d1325d8fdf9634e7083e76a (patch) | |
| tree | 095d00491c385c33674f5a0a11128a543a48c485 /sql/ddl/pgsql.sql | |
| parent | e79d3d7163657f7a540530dddb319f984885e864 (diff) | |
| download | gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.tar.gz gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.tar.bz2 gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.zip | |
First draft of recurrent costs and categories
Diffstat (limited to 'sql/ddl/pgsql.sql')
| -rw-r--r-- | sql/ddl/pgsql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/ddl/pgsql.sql b/sql/ddl/pgsql.sql index 09c7133..18dc388 100644 --- a/sql/ddl/pgsql.sql +++ b/sql/ddl/pgsql.sql @@ -19,14 +19,14 @@ CREATE INDEX user_id ON categories (user_id); -CREATE TABLE const_expenses ( +CREATE TABLE recur_expenses ( id SERIAL PRIMARY KEY, description TEXT, expense NUMERIC(10, 2) NOT NULL, duration INTERVAL NOT NULL, start DATE NOT NULL, "end" DATE NOT NULL, - prev_id INTEGER REFERENCES const_expenses, + prev_id INTEGER REFERENCES recur_expenses, category_id INTEGER NOT NULL REFERENCES categories, user_id INTEGER NOT NULL REFERENCES users ); |