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 |