Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 5783:153456f84602
add missing constraints to Oracle Schema (issue426) and some cosmetics
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Apr 2013 13:00:13 +0200 |
| parents | 88cbe798cbab |
| children |
comparison
equal
deleted
inserted
replaced
| 5782:5ad389bc20f0 | 5783:153456f84602 |
|---|---|
| 67 -- plus its position. | 67 -- plus its position. |
| 68 CREATE SEQUENCE ANNOTATIONS_ID_SEQ; | 68 CREATE SEQUENCE ANNOTATIONS_ID_SEQ; |
| 69 | 69 |
| 70 CREATE TABLE annotations ( | 70 CREATE TABLE annotations ( |
| 71 id int PRIMARY KEY NOT NULL, | 71 id int PRIMARY KEY NOT NULL, |
| 72 range_id int NOT NULL REFERENCES ranges(id) ON DELETE CASCADE, | 72 range_id int NOT NULL REFERENCES ranges(id) ON DELETE CASCADE, |
| 73 attribute_id int NOT NULL REFERENCES attributes(id), | 73 attribute_id int NOT NULL REFERENCES attributes(id), |
| 74 position_id int REFERENCES positions(id), | 74 position_id int REFERENCES positions(id), |
| 75 edge_id int REFERENCES edges(id), | 75 edge_id int REFERENCES edges(id), |
| 76 type_id int REFERENCES annotation_types(id) | 76 type_id int REFERENCES annotation_types(id) |
| 77 ); | 77 ); |
| 78 | 78 |