dive4elements/river: flys-backend/doc/schema/postgresql-minfo.sql annotate

annotate flys-backend/doc/schema/postgresql-minfo.sql @ 3793:8f232119011e

FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. flys-backend/trunk@5433 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Tue, 11 Sep 2012 13:55:08 +0000
parents	c3b2673eafbf
children	fc32a4955087

rev	line source
2823 13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 BEGIN;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 CREATE SEQUENCE LOCATION_SYSTEM_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	4
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	5 CREATE TABLE location_system (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	7 name VARCHAR(32) NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8 description VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 PRIMARY KEY(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13 CREATE SEQUENCE ELEVATION_MODEL_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	14
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15 CREATE TABLE elevation_model (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17 name VARCHAR(32) NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 unit_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 CONSTRAINT fk_unit FOREIGN KEY (unit_id) REFERENCES units(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 CREATE SEQUENCE BED_HEIGHT_TYPE_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 CREATE TABLE bed_height_type (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27 name VARCHAR(16) NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 description VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 PRIMARY KEY(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	31
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	33
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	34 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	35
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36 CREATE TABLE bed_height_single (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	37 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 river_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 year int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40 sounding_width int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 type_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 location_system_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 cur_elevation_model_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 old_elevation_model_id int,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 range_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 evaluation_by VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	47 description VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	48 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	49 CONSTRAINT fk_bed_single_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	50 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	54 CONSTRAINT fk_range FOREIGN KEY (range_id) REFERENCES ranges(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 CREATE SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	60 CREATE TABLE bed_height_epoch (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 river_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 time_interval_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 -- sounding_with int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 -- type_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 cur_elevation_model_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	67 old_elevation_model_id int,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68 range_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	69 evaluation_by VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	70 description VARCHAR(255),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 CONSTRAINT fk_time_interval FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 CONSTRAINT fk_epoch_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 CONSTRAINT fk_epoch_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 CONSTRAINT fk_epoch_range FOREIGN KEY (range_id) REFERENCES ranges(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 CREATE SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 CREATE TABLE bed_height_single_values (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 bed_height_single_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 station NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85 height NUMERIC,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86 uncertainty NUMERIC,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87 data_gap NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88 sounding_width NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 width NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 CREATE SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 CREATE TABLE bed_height_epoch_values (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 bed_height_epoch_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 station NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 height NUMERIC,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 CONSTRAINT fk_bed_epoch_values_parent FOREIGN KEY (bed_height_epoch_id) REFERENCES bed_height_epoch(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 CREATE SEQUENCE DEPTHS_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 CREATE TABLE depths (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 lower NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 upper NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 unit_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	115 CONSTRAINT fk_depths_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	119 CREATE SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	120
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 CREATE TABLE sediment_density (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	122 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 river_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	124 depth_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	125 unit_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126 description VARCHAR(256),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	128 CONSTRAINT fk_sd_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 CONSTRAINT fk_sd_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 CONSTRAINT fk_sd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	134 CREATE SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	136 CREATE TABLE sediment_density_values (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	138 sediment_density_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	139 station NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	140 density NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	141 description VARCHAR(256),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	142 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	143 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	144 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	145
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	146
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	147 CREATE SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	148
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	149 CREATE TABLE morphologic_width (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	150 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	151 river_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	152 unit_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	153 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	154 CONSTRAINT fk_mw_river_id FOREIGN KEY(river_id) REFERENCES rivers(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	155 CONSTRAINT fk_mw_unit_id FOREIGN KEY(unit_id) REFERENCES units(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	156 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	157
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 CREATE SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	161 CREATE TABLE morphologic_width_values (
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	162 id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	163 morphologic_width_id int NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	164 station NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	165 width NUMERIC NOT NULL,
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	166 description VARCHAR(256),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	167 PRIMARY KEY(id),
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	168 CONSTRAINT fk_mwv_morphologic_width_id FOREIGN KEY (morphologic_width_id) REFERENCES morphologic_width(id)
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	169 );
13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	170
2858 c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	171
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	172 CREATE SEQUENCE DISCHARGE_ZONE_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	173
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	174 CREATE TABLE discharge_zone (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	175 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	176 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	177 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	178 value NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	179 lower_discharge VARCHAR(16) NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	180 upper_discharge VARCHAR(16),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	181 PRIMARY KEY(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	182 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	183 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	184
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	185
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	186 CREATE SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	187
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	188 CREATE TABLE flow_velocity_model (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	189 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	190 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	191 discharge_zone_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	192 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	193 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	194 CONSTRAINT fk_fvm_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	195 CONSTRAINT fk_fvm_discharge_zone_id FOREIGN KEY (discharge_zone_id) REFERENCES discharge_zone (id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	196 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	197
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	198
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	199 CREATE SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	200
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	201 CREATE TABLE flow_velocity_model_values (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	202 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	203 flow_velocity_model_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	204 station NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	205 q NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	206 total_channel NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	207 main_channel NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	208 shear_stress NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	209 PRIMARY KEY(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	210 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	211 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	212
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	213
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	214
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	215 CREATE SEQUENCE FV_MEASURE_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	216
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	217 CREATE TABLE flow_velocity_measurements (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	218 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	219 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	220 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	221 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	222 CONSTRAINT fk_fvm_rivers_id FOREIGN KEY (river_id) REFERENCES rivers(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	223 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	224
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	225 CREATE SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	226
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	227 CREATE TABLE flow_velocity_measure_values (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	228 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	229 measurements_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	230 station NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	231 datetime TIMESTAMP,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	232 w NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	233 q NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	234 v NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	235 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	236 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	237 CONSTRAINT fk_fvmv_measurements_id FOREIGN KEY (measurements_id) REFERENCES flow_velocity_measurements (id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	238 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	239
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	240
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	241 CREATE SEQUENCE GRAIN_FRACTION_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	242
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	243 CREATE TABLE grain_fraction (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	244 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	245 name VARCHAR(64) NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	246 lower NUMERIC,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	247 upper NUMERIC,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	248 unit_id int,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	249 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	250 CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	251 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	252
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	253
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	255
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	256 CREATE TABLE sediment_yield (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	257 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	258 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	259 grain_fraction_id int,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	260 unit_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	261 time_interval_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	262 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	263 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	264 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	265 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	266 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	267 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	268 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	269
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	270
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	271 CREATE SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	272
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	273 CREATE TABLE sediment_yield_values (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	274 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	275 sediment_yield_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	276 station NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	277 value NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	278 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	279 CONSTRAINT fk_syv_sediment_yield_id FOREIGN KEY (sediment_yield_id) REFERENCES sediment_yield(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	280 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	281
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	282
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	283 CREATE SEQUENCE WATERLEVEL_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	284
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	285 CREATE TABLE waterlevel (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	286 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	287 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	288 unit_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	289 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	290 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	291 CONSTRAINT fk_w_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	292 CONSTRAINT fk_w_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	293 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	294
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	295
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	296 CREATE SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	297
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	298 CREATE TABLE waterlevel_q_range (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	299 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	300 waterlevel_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	301 q NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	302 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	303 CONSTRAINT fk_wqr_waterlevel_id FOREIGN KEY (waterlevel_id) REFERENCES waterlevel(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	304 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	305
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	306
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	307 CREATE SEQUENCE WATERLEVEL_VALUES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	308
3793 8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	309 CREATE TABLE waterlevel_values (
2858 c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	310 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	311 waterlevel_q_range_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	312 station NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	313 w NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	314 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	315 CONSTRAINT fk_wv_waterlevel_q_range_id FOREIGN KEY (waterlevel_q_range_id) REFERENCES waterlevel_q_range(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	316 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	317
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	318
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	319 CREATE SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	320
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	321 CREATE TABLE waterlevel_difference (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	322 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	323 river_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	324 unit_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	325 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	326 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	327 CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	328 CONSTRAINT fk_wd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	329 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	330
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	331
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	332 CREATE SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	333
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	334 CREATE TABLE waterlevel_difference_column (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	335 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	336 difference_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	337 description VARCHAR(256),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	338 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	339 CONSTRAINT fk_wdc_difference_id FOREIGN KEY (difference_id) REFERENCES waterlevel_difference (id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	340 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	341
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	342
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	343 CREATE SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ;
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	344
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	345 CREATE TABLE waterlevel_difference_values (
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	346 id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	347 column_id int NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	348 station NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	349 value NUMERIC NOT NULL,
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	350 PRIMARY KEY (id),
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	351 CONSTRAINT fk_wdv_column_id FOREIGN KEY (column_id) REFERENCES waterlevel_difference_column (id)
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	352 );
c3b2673eafbf Adjusted PostgreSQL port of MINFO schema to match Oracle one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2823 diff changeset	353
3793 8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	354
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	355 CREATE SEQUENCE SQ_RELATION_ID_SEQ;
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	356
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	357 CREATE TABLE sq_relation (
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	358 id int NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	359 river_id int NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	360 time_interval_id int NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	361 description VARCHAR(256),
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	362 PRIMARY KEY (id),
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	363 CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	364 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	365 );
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	366
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	367
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	368 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	369
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	370 CREATE TABLE sq_relation_value (
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	371 id int NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	372 sq_relation_id int NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	373 parameter VARCHAR(16) NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	374 fraction VARCHAR(32) NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	375 function VARCHAR(32) NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	376 km NUMERIC NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	377 a NUMERIC NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	378 b NUMERIC NOT NULL,
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	379 PRIMARY KEY (id),
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	380 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id)
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	381 );
2823 13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	382 COMMIT;

Mercurial > dive4elements > river

annotate flys-backend/doc/schema/postgresql-minfo.sql @ 3793:8f232119011e