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

annotate flys-backend/doc/schema/oracle.sql @ 2382:c5791de0c495

Added meachnism to backend to fetch all annotation related data in one go. flys-backend/trunk@3722 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Thu, 19 Jan 2012 13:36:06 +0000
parents	fe89d6cf55fb
children	9c2424073be0

rev	line source
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	1 -- ANNOTATION_TYPES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	2 CREATE SEQUENCE ANNOTATION_TYPES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	3
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	4 CREATE TABLE annotation_types (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	5 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	6 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	7 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	8 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	9
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	10
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	11 -- ANNOTATIONS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	12 CREATE SEQUENCE ANNOTATIONS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	13
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	14 CREATE TABLE annotations (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	15 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	16 attribute_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	17 edge_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	18 position_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	19 range_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	20 type_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	21 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	22 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	23
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	24
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	25 -- ATTRIBUTES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	26 CREATE SEQUENCE ATTRIBUTES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	27
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	28 CREATE TABLE attributes (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	29 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	30 value VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	31 primary key (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	32 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	33
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	34
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	35 -- CROSS_SECTION_LINES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	36 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	37
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	38 CREATE TABLE cross_section_lines (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	39 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	40 km NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	41 cross_section_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	42 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	43 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	44
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	45
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	46 -- CROSS_SECTION_POINTS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	47 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	48
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	49 CREATE TABLE cross_section_points (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	50 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	51 col_pos NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	52 x NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	53 y NUMBER(38,2),
2353 67e0371f6f40 Adjusted NUMBER format for units, positions and cross_section_points tables. Bjoern Schilberg <bjoern@intevation.de> parents: 2352 diff changeset	54 cross_section_line_id NUMBER(38,0),
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	55 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	56 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	57
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	58
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	59 -- CROSS_SECTIONS
1255 0e63222d80bc Added inital oracle schema. Bjoern Schilberg <bjoern@intevation.de> parents: diff changeset	60 create sequence CROSS_SECTIONS_ID_SEQ;
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	61
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	62 create table cross_sections (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	63 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	64 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	65 river_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	66 time_interval_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	67 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	68 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	69
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	70
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	71 -- DISCHARGE_TABLE_VALUES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	72 CREATE SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	73
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	74 CREATE TABLE discharge_table_values (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	75 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	76 q NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	77 w NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	78 table_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	79 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	80 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	81
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	82
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	83 -- DISCHARGE_TABLES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	84 CREATE SEQUENCE DISCHARGE_TABLES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	85
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	86 CREATE TABLE discharge_tables (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	87 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	88 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	89 kind NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	90 gauge_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	91 time_interval_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	92 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	93 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	94
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	95
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	96 -- EDGES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	97 CREATE SEQUENCE EDGES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	98
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	99 CREATE TABLE edges (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	100 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	101 bottom NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	102 top NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	103 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	104 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	105
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	106
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	107 -- GAUGES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	108 CREATE SEQUENCE GAUGES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	109
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	110 CREATE TABLE gauges (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	111 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	112 aeo NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	113 datum NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	114 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	115 station NUMBER(38,2),
2371 fe89d6cf55fb Added support for official gauge numbers. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2367 diff changeset	116 official_number NUMBER(38,0),
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	117 range_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	118 river_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	119 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	120 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	121
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	122
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	123 -- HYK_ENTRIES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	124 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	125
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	126 CREATE TABLE hyk_entries (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	127 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	128 km NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	129 measure TIMESTAMP,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	130 hyk_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	131 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	132 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	133
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	134
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	135 -- HYK_FLOW_ZONE_TYPES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	136 CREATE SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	137
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	138 CREATE TABLE hyk_flow_zone_types (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	139 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	140 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	141 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	142 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	143 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	144
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	145
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	146 -- HYK_FLOW_ZONES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	147 CREATE SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	148
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	149 CREATE TABLE hyk_flow_zones (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	150 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	151 a NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	152 b NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	153 formation_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	154 type_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	155 primary key (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	156 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	157
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	158
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	159 -- HYK_FORMATIONS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	160 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	161
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	162 CREATE TABLE hyk_formations (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	163 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	164 bottom NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	165 distance_hf NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	166 distance_vl NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	167 distance_vr NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	168 formation_num NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	169 top NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	170 hyk_entry_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	171 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	172 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	173
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	174
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	175 -- HYKS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	176 CREATE SEQUENCE HYKS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	177
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	178 CREATE TABLE hyks (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	179 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	180 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	181 river_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	182 primary key (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	183 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	184
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	185
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	186 -- MAIN_VALUE_TYPES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	187 CREATE SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	188
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	189 CREATE TABLE main_value_types (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	190 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	191 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	192 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	193 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	194
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	195
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	196 -- MAIN_VALUES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	197 CREATE SEQUENCE MAIN_VALUES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	198
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	199 CREATE TABLE main_values (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	200 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	201 value NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	202 gauge_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	203 named_value_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	204 time_interval_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	205 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	206 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	207
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	208
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	209 -- NAMED_MAIN_VALUES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	210 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	211
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	212 CREATE TABLE named_main_values (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	213 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	214 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	215 type_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	216 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	217 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	218
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	219
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	220 -- POSITIONS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	221 CREATE SEQUENCE POSITIONS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	222
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	223 CREATE TABLE positions (
2353 67e0371f6f40 Adjusted NUMBER format for units, positions and cross_section_points tables. Bjoern Schilberg <bjoern@intevation.de> parents: 2352 diff changeset	224 id NUMBER(38,0) NOT NULL,
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	225 value VARCHAR2(255 char),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	226 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	227 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	228
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	229
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	230 --- RANGES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	231 CREATE SEQUENCE RANGES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	232
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	233 CREATE TABLE ranges (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	234 id NUMBER(38,0) NOT NULL,
2367 418a0918863b Fixed flys/issue415: Increased precision of a and b in ranges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2355 diff changeset	235 a NUMBER(38,10),
418a0918863b Fixed flys/issue415: Increased precision of a and b in ranges. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2355 diff changeset	236 b NUMBER(38,10),
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	237 river_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	238 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	239 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	240
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	241
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	242 -- RIVERS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	243 CREATE SEQUENCE RIVERS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	244
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	245 CREATE TABLE rivers (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	246 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	247 km_up NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	248 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	249 wst_unit_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	250 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	251 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	252
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	253
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	254 -- TIME_INTERVALS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	255 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	256
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	257 CREATE TABLE time_intervals (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	258 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	259 start_time TIMESTAMP,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	260 stop_time TIMESTAMP,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	261 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	262 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	263
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	264
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	265 --- UNITS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	266 CREATE SEQUENCE UNITS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	267
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	268 CREATE TABLE units (
2353 67e0371f6f40 Adjusted NUMBER format for units, positions and cross_section_points tables. Bjoern Schilberg <bjoern@intevation.de> parents: 2352 diff changeset	269 id NUMBER(38,0) NOT NULL,
2351 f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	270 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	271 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	272 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	273
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	274
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	275 -- WST_COLUMN_Q_RANGES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	276 CREATE SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	277
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	278 CREATE TABLE wst_column_q_ranges (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	279 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	280 wst_column_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	281 wst_q_range_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	282 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	283 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	284
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	285
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	286 -- WST_COLUMN_VALUES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	287 CREATE SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	288
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	289 CREATE TABLE wst_column_values (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	290 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	291 position NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	292 w NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	293 wst_column_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	294 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	295 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	296
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	297
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	298 -- WST_COLUMNS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	299 CREATE SEQUENCE WST_COLUMNS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	300
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	301 CREATE TABLE wst_columns (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	302 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	303 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	304 name VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	305 position NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	306 time_interval_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	307 wst_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	308 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	309 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	310
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	311
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	312 -- WST_Q_RANGES
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	313 CREATE SEQUENCE WST_Q_RANGES_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	314
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	315 CREATE TABLE wst_q_ranges (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	316 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	317 q NUMBER(38,2),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	318 range_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	319 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	320 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	321
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	322
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	323 -- WSTS
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	324 CREATE SEQUENCE WSTS_ID_SEQ;
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	325
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	326 CREATE TABLE wsts (
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	327 id NUMBER(38,0) NOT NULL,
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	328 description VARCHAR2(255),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	329 kind NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	330 river_id NUMBER(38,0),
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	331 PRIMARY KEY (id)
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	332 );
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	333
f993b735db71 Adjust oracle schema [I382] Bjoern Schilberg <bjoern@intevation.de> parents: 1255 diff changeset	334
2352 8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	335 -- ADD CONSTRAINTs
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	336 ALTER TABLE annotations ADD CONSTRAINT cAnnotationsRanges FOREIGN KEY (range_id) REFERENCES ranges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	337 ALTER TABLE annotations ADD CONSTRAINT cAnnotationsEdges FOREIGN KEY (edge_id) REFERENCES edges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	338 ALTER TABLE annotations ADD CONSTRAINT cAnnotationsPositions FOREIGN KEY (position_id) REFERENCES positions;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	339 ALTER TABLE annotations ADD CONSTRAINT cAnnotationsAttributes FOREIGN KEY (attribute_id) REFERENCES attributes;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	340 ALTER TABLE annotations ADD CONSTRAINT cAnnotationsTypes FOREIGN KEY (type_id) REFERENCES annotation_types;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	341 ALTER TABLE cross_section_lines ADD CONSTRAINT cQPSLinesCrossSections FOREIGN KEY (cross_section_id) REFERENCES cross_sections;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	342 ALTER TABLE cross_section_points ADD CONSTRAINT cQPSPointsCrossSectionLines FOREIGN KEY (cross_section_line_id) REFERENCES cross_section_lines;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	343 ALTER TABLE cross_sections ADD CONSTRAINT cCrossSectionsRivers FOREIGN KEY (river_id) REFERENCES rivers;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	344 ALTER TABLE cross_sections ADD CONSTRAINT cCrossSectionsTimeIntervals FOREIGN KEY (time_interval_id) REFERENCES time_intervals;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	345 ALTER TABLE discharge_table_values ADD CONSTRAINT cTableValuesDischargeTables foreign key (table_id) REFERENCES discharge_tables;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	346 ALTER TABLE discharge_tables ADD CONSTRAINT cDischargeTablesTime_intervals FOREIGN KEY (time_interval_id) REFERENCES time_intervals;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	347 ALTER TABLE discharge_tables ADD CONSTRAINT cDischargeTablesGauges FOREIGN KEY (gauge_id) REFERENCES gauges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	348 ALTER TABLE gauges ADD CONSTRAINT cGaugesRivers FOREIGN KEY (river_id) REFERENCES rivers;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	349 ALTER TABLE gauges ADD CONSTRAINT cGaugesRanges FOREIGN KEY (range_id) REFERENCES ranges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	350 ALTER TABLE hyk_entries ADD CONSTRAINT cHykEntriesHyks FOREIGN KEY (hyk_id) REFERENCES hyks;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	351 ALTER TABLE hyk_flow_zones ADD CONSTRAINT cHykFlowZonesHykFormations FOREIGN KEY (formation_id) REFERENCES hyk_formations;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	352 ALTER TABLE hyk_flow_zones ADD CONSTRAINT cHykFlowZonesHykFlowZoneTypes FOREIGN KEY (type_id) REFERENCES hyk_flow_zone_types;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	353 ALTER TABLE hyks ADD CONSTRAINT cHyksRivers FOREIGN KEY (river_id) REFERENCES rivers;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	354 ALTER TABLE hyk_formations ADD CONSTRAINT cHykFormationsHykEntries FOREIGN KEY (hyk_entry_id) REFERENCES hyk_entries;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	355 ALTER TABLE main_values ADD CONSTRAINT cMainValuesTimeIntervals FOREIGN KEY (time_interval_id) REFERENCES time_intervals;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	356 ALTER TABLE main_values ADD CONSTRAINT cMainValuesGauges FOREIGN KEY (gauge_id) REFERENCES gauges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	357 ALTER TABLE main_values ADD CONSTRAINT cMainValuesNamedMainValues FOREIGN KEY (named_value_id) REFERENCES named_main_values;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	358 ALTER TABLE named_main_values ADD CONSTRAINT cNamedMainValuesMainValueTypes FOREIGN KEY (type_id) REFERENCES main_value_types;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	359 ALTER TABLE ranges ADD CONSTRAINT cRangesRivers FOREIGN KEY (river_id) REFERENCES rivers;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	360 ALTER TABLE rivers ADD CONSTRAINT cRiversUnits FOREIGN KEY (wst_unit_id) REFERENCES units;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	361 ALTER TABLE wst_column_q_ranges ADD CONSTRAINT cWstColumnQRangesWstColums FOREIGN KEY (wst_column_id) REFERENCES wst_columns;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	362 ALTER TABLE wst_column_q_ranges ADD CONSTRAINT cWstColumnQRangesWstQRanges FOREIGN KEY (wst_q_range_id) REFERENCES wst_q_ranges;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	363 ALTER TABLE wst_column_values ADD CONSTRAINT cWstColumnValuesWstColumns FOREIGN KEY (wst_column_id) REFERENCES wst_columns;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	364 ALTER TABLE wst_columns ADD CONSTRAINT cWstColumnsTime_intervals FOREIGN KEY (time_interval_id) REFERENCES time_intervals;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	365 ALTER TABLE wst_columns ADD CONSTRAINT cWstColumnsWsts FOREIGN KEY (wst_id) REFERENCES wsts;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	366 ALTER TABLE wst_q_ranges ADD CONSTRAINT cWstQRangesRanges FOREIGN KEY (range_id) REFERENCES RANGES;
8126ccb58f28 Fixed errors. Bjoern Schilberg <bjoern@intevation.de> parents: 2351 diff changeset	367 ALTER TABLE wsts ADD CONSTRAINT cWstsRivers FOREIGN KEY (river_id) REFERENCES rivers;
2355 cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	368
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	369 -- VIEWS
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	370
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	371 CREATE VIEW wst_value_table AS
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	372 SELECT wcv.position AS position,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	373 w,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	374 (SELECT q
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	375 FROM wst_column_q_ranges wcqr
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	376 JOIN wst_q_ranges wqr
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	377 ON wcqr.wst_q_range_id = wqr.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	378 JOIN ranges r
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	379 ON r.id = wqr.range_id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	380 WHERE wcqr.wst_column_id = wc.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	381 AND wcv.position BETWEEN r.a AND r.b) AS q,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	382 wc.position AS column_pos,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	383 w.id AS wst_id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	384 FROM wst_column_values wcv
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	385 JOIN wst_columns wc
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	386 ON wcv.wst_column_id = wc.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	387 JOIN wsts w
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	388 ON wc.wst_id = w.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	389 ORDER BY wcv.position ASC,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	390 wc.position DESC;
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	391
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	392 -- view to select the w values of a WST
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	393 CREATE VIEW wst_w_values AS
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	394 SELECT wcv.position AS km,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	395 wcv.w AS w,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	396 wc.position AS column_pos,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	397 w.id AS wst_id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	398 FROM wst_column_values wcv
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	399 JOIN wst_columns wc ON wcv.wst_column_id = wc.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	400 JOIN wsts w ON wc.wst_id = w.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	401 ORDER BY wcv.position, wc.position;
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	402
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	403 -- view to select the q values of a WST
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	404 CREATE VIEW wst_q_values AS
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	405 SELECT wc.position AS column_pos,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	406 wqr.q AS q,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	407 r.a AS a,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	408 r.b AS b,
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	409 wc.wst_id AS wst_id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	410 FROM wst_column_q_ranges wcqr
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	411 JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	412 JOIN ranges r ON wqr.range_id = r.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	413 JOIN wst_columns wc ON wcqr.wst_column_id = wc.id
cf8dcfaeb756 Added missing views (wst_value_table,wst_w_values,wst_q_values). Bjoern Schilberg <bjoern@intevation.de> parents: 2354 diff changeset	414 ORDER BY wc.position, wcqr.wst_column_id, r.a;

Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle.sql @ 2382:c5791de0c495