Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 171:4a83e14f40f9
Added entity and id annotations.
flys-backend/trunk@1463 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 14 Mar 2011 14:52:58 +0000 |
| parents | 88c14d5d45be |
| children | 8e2f2ddc507f |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Mon Mar 14 11:31:00 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Mon Mar 14 14:52:58 2011 +0000 @@ -134,9 +134,9 @@ ); -- WST files -CREATE SEQUENCE WST_ID_SEQ; +CREATE SEQUENCE WSTS_ID_SEQ; -CREATE TABLE wst ( +CREATE TABLE wsts ( id int PRIMARY KEY NOT NULL, river_id int NOT NULL REFERENCES rivers(id), description VARCHAR(256) NOT NULL, @@ -145,9 +145,9 @@ ); -- columns of WST files -CREATE SEQUENCE WST_COLUMN_ID_SEQ; +CREATE SEQUENCE WST_COLUMNS_ID_SEQ; -CREATE TABLE wst_column ( +CREATE TABLE wst_columns ( id int PRIMARY KEY NOT NULL, wst_id int NOT NULL REFERENCES wst(id), name VARCHAR(256) NOT NULL, @@ -163,7 +163,7 @@ CREATE TABLE wst_column_values ( id int PRIMARY KEY NOT NULL, - wst_column_id int NOT NULL REFERENCES wst_column(id), + wst_column_id int NOT NULL REFERENCES wst_columns(id), position NUMERIC NOT NULL, w NUMERIC NOT NULL,