Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2823:13b3fcaa1b34
Add MINFO schema for PostgreSQL
flys-backend/trunk@4240 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 16:15:23 +0000 |
| parents | 0c2567626754 |
| children | 85b2b5e7377f |
comparison
equal
deleted
inserted
replaced
| 2822:212c33c9a5e2 | 2823:13b3fcaa1b34 |
|---|---|
| 108 | 108 |
| 109 CREATE TABLE depths ( | 109 CREATE TABLE depths ( |
| 110 id NUMBER(38,0) NOT NULL, | 110 id NUMBER(38,0) NOT NULL, |
| 111 lower NUMBER(38,2) NOT NULL, | 111 lower NUMBER(38,2) NOT NULL, |
| 112 upper NUMBER(38,2) NOT NULL, | 112 upper NUMBER(38,2) NOT NULL, |
| 113 unit_id NUMBER(38,2) NOT NULL, | 113 unit_id NUMBER(38,0) NOT NULL, |
| 114 PRIMARY KEY(id), | 114 PRIMARY KEY(id), |
| 115 CONSTRAINT fk_depths_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) | 115 CONSTRAINT fk_depths_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
| 116 ); | 116 ); |
| 117 | 117 |
| 118 | 118 |