Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 174:249390dd24e7
Added foreign key constraint annotations to model classes.
flys-backend/trunk@1473 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 15 Mar 2011 14:49:56 +0000 |
| parents | 8e2f2ddc507f |
| children | 0f0b98ef9b04 |
comparison
equal
deleted
inserted
replaced
| 173:8e2f2ddc507f | 174:249390dd24e7 |
|---|---|
| 149 | 149 |
| 150 CREATE TABLE wst_columns ( | 150 CREATE TABLE wst_columns ( |
| 151 id int PRIMARY KEY NOT NULL, | 151 id int PRIMARY KEY NOT NULL, |
| 152 wst_id int NOT NULL REFERENCES wsts(id), | 152 wst_id int NOT NULL REFERENCES wsts(id), |
| 153 name VARCHAR(256) NOT NULL, | 153 name VARCHAR(256) NOT NULL, |
| 154 description VARCHAR, | 154 description VARCHAR(256), |
| 155 | 155 |
| 156 time_interval_id int REFERENCES time_intervals(id), | 156 time_interval_id int REFERENCES time_intervals(id), |
| 157 | 157 |
| 158 UNIQUE (wst_id, name) | 158 UNIQUE (wst_id, name) |
| 159 ); | 159 ); |