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

annotate flys-backend/doc/schema/postgresql-minfo.sql @ 4478:6153c50f78cf

WaterLineArtifact: Added callcontext-parameter to interfaces getWaterLine. Update all implementations. The change was done to be able to compute the extreme values during getWaterLine to access data needed in CrossSectionProfile Diagrams.

author	Felix Wolfsteller <felix.wolfsteller@intevation.de>
date	Tue, 13 Nov 2012 14:46:44 +0100
parents	f63b39799d2d
children	504cd5801785

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,
3953 fc32a4955087 Towards fix for issue863 (gaps in bedheight data). Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 3793 diff changeset	87 data_gap NUMERIC,
fc32a4955087 Towards fix for issue863 (gaps in bedheight data). Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 3793 diff changeset	88 sounding_width NUMERIC,
fc32a4955087 Towards fix for issue863 (gaps in bedheight data). Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 3793 diff changeset	89 width NUMERIC,
2823 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
4193 f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	355 CREATE SEQUENCE MEASUREMENT_STATION_ID_SEQ;
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	356 CREATE TABLE measurement_station (
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	357 id int NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	358 name VARCHAR(256) NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	359 river_id int NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	360 station NUMERIC NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	361 range_id int NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	362 measurement_type VARCHAR(64) NOT NULL,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	363 riverside VARCHAR(16),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	364 reference_gauge_id int,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	365 observation_timerange_id int,
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	366 operator VARCHAR(64),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	367 comment VARCHAR(512),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	368 PRIMARY KEY (id),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	369 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	370 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	371 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	372 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id),
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	373 UNIQUE (river_id, station)
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	374 );
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	375
f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3953 diff changeset	376
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	377 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	378
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 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	380 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	381 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	382 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	383 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	384 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	385 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	386 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	387 );
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	388
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	389
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	390 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	391
8f232119011e FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2858 diff changeset	392 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	393 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	394 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	395 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	396 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	397 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	398 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	399 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	400 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	401 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	402 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	403 );
2823 13b3fcaa1b34 Add MINFO schema for PostgreSQL Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	404 COMMIT;

Mercurial > dive4elements > river

annotate flys-backend/doc/schema/postgresql-minfo.sql @ 4478:6153c50f78cf