Mercurial > lada > lada-server

comparison db_schema/stammdaten_schema.sql @ 867:66069d69d6ee

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Whitespace cleanup.
author Tom Gottfried <tom@intevation.de>
date Fri, 05 Feb 2016 17:03:31 +0100
parents d47e6b8f3897
children 6cefa1468832
comparison
equal deleted inserted replaced
866:d47e6b8f3897 867:66069d69d6ee
328 328
329 ALTER SEQUENCE deskriptoren_id_seq OWNED BY deskriptoren.id; 329 ALTER SEQUENCE deskriptoren_id_seq OWNED BY deskriptoren.id;
330 330
331 331
332 -- 332 --
333 -- Name: favorite; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 333 -- Name: favorite; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
334 -- 334 --
335 335
336 CREATE TABLE favorite ( 336 CREATE TABLE favorite (
337 id integer NOT NULL, 337 id integer NOT NULL,
338 user_id integer NOT NULL, 338 user_id integer NOT NULL,
358 358
359 ALTER SEQUENCE favorite_id_seq OWNED BY favorite.id; 359 ALTER SEQUENCE favorite_id_seq OWNED BY favorite.id;
360 360
361 361
362 -- 362 --
363 -- Name: filter; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 363 -- Name: filter; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
364 -- 364 --
365 365
366 CREATE TABLE filter ( 366 CREATE TABLE filter (
367 id integer NOT NULL, 367 id integer NOT NULL,
368 query_id integer NOT NULL, 368 query_id integer NOT NULL,
391 391
392 ALTER SEQUENCE filter_id_seq OWNED BY filter.id; 392 ALTER SEQUENCE filter_id_seq OWNED BY filter.id;
393 393
394 394
395 -- 395 --
396 -- Name: filter_value; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 396 -- Name: filter_value; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
397 -- 397 --
398 398
399 CREATE TABLE filter_value ( 399 CREATE TABLE filter_value (
400 id integer NOT NULL, 400 id integer NOT NULL,
401 query_id integer NOT NULL, 401 query_id integer NOT NULL,
423 423
424 ALTER SEQUENCE filter_value_id_seq OWNED BY filter_value.id; 424 ALTER SEQUENCE filter_value_id_seq OWNED BY filter_value.id;
425 425
426 426
427 -- 427 --
428 -- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 428 -- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
429 -- 429 --
430 430
431 CREATE TABLE koordinaten_art ( 431 CREATE TABLE koordinaten_art (
432 id integer NOT NULL, 432 id integer NOT NULL,
433 koordinatenart character varying(50), 433 koordinatenart character varying(50),
453 453
454 ALTER SEQUENCE koordinaten_art_id_seq OWNED BY koordinaten_art.id; 454 ALTER SEQUENCE koordinaten_art_id_seq OWNED BY koordinaten_art.id;
455 455
456 456
457 -- 457 --
458 -- Name: lada_user; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 458 -- Name: lada_user; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
459 -- 459 --
460 460
461 CREATE TABLE lada_user ( 461 CREATE TABLE lada_user (
462 id integer NOT NULL, 462 id integer NOT NULL,
463 name character varying(80) NOT NULL 463 name character varying(80) NOT NULL
482 482
483 ALTER SEQUENCE lada_user_id_seq OWNED BY lada_user.id; 483 ALTER SEQUENCE lada_user_id_seq OWNED BY lada_user.id;
484 484
485 485
486 -- 486 --
487 -- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 487 -- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
488 -- 488 --
489 489
490 CREATE TABLE mess_einheit ( 490 CREATE TABLE mess_einheit (
491 id integer NOT NULL, 491 id integer NOT NULL,
492 beschreibung character varying(50), 492 beschreibung character varying(50),
875 875
876 ALTER SEQUENCE probenehmer_id_seq OWNED BY probenehmer.id; 876 ALTER SEQUENCE probenehmer_id_seq OWNED BY probenehmer.id;
877 877
878 878
879 -- 879 --
880 -- Name: query; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 880 -- Name: query; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
881 -- 881 --
882 882
883 CREATE TABLE query ( 883 CREATE TABLE query (
884 id integer NOT NULL, 884 id integer NOT NULL,
885 name character varying(80) NOT NULL, 885 name character varying(80) NOT NULL,
907 907
908 ALTER SEQUENCE query_id_seq OWNED BY query.id; 908 ALTER SEQUENCE query_id_seq OWNED BY query.id;
909 909
910 910
911 -- 911 --
912 -- Name: result; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 912 -- Name: result; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
913 -- 913 --
914 914
915 CREATE TABLE result ( 915 CREATE TABLE result (
916 id integer NOT NULL, 916 id integer NOT NULL,
917 query_id integer NOT NULL, 917 query_id integer NOT NULL,
1589 ALTER TABLE ONLY deskriptor_umwelt 1589 ALTER TABLE ONLY deskriptor_umwelt
1590 ADD CONSTRAINT deskriptor_umwelt_pkey PRIMARY KEY (id); 1590 ADD CONSTRAINT deskriptor_umwelt_pkey PRIMARY KEY (id);
1591 1591
1592 1592
1593 -- 1593 --
1594 -- Name: favorite_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1594 -- Name: favorite_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1595 -- 1595 --
1596 1596
1597 ALTER TABLE ONLY favorite 1597 ALTER TABLE ONLY favorite
1598 ADD CONSTRAINT favorite_pkey PRIMARY KEY (id); 1598 ADD CONSTRAINT favorite_pkey PRIMARY KEY (id);
1599 1599
1600 1600
1601 -- 1601 --
1602 -- Name: filter_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1602 -- Name: filter_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1603 -- 1603 --
1604 1604
1605 ALTER TABLE ONLY filter 1605 ALTER TABLE ONLY filter
1606 ADD CONSTRAINT filter_pkey PRIMARY KEY (id); 1606 ADD CONSTRAINT filter_pkey PRIMARY KEY (id);
1607 1607
1608 1608
1609 -- 1609 --
1610 -- Name: filter_value_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1610 -- Name: filter_value_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1611 -- 1611 --
1612 1612
1613 ALTER TABLE ONLY filter_value 1613 ALTER TABLE ONLY filter_value
1614 ADD CONSTRAINT filter_value_pkey PRIMARY KEY (id); 1614 ADD CONSTRAINT filter_value_pkey PRIMARY KEY (id);
1615 1615
1616 1616
1617 -- 1617 --
1618 -- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1618 -- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1619 -- 1619 --
1620 1620
1621 ALTER TABLE ONLY koordinaten_art 1621 ALTER TABLE ONLY koordinaten_art
1622 ADD CONSTRAINT koordinaten_art_pkey PRIMARY KEY (id); 1622 ADD CONSTRAINT koordinaten_art_pkey PRIMARY KEY (id);
1623 1623
1624 1624
1625 -- 1625 --
1626 -- Name: lada_user_name_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1626 -- Name: lada_user_name_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1627 -- 1627 --
1628 1628
1629 ALTER TABLE ONLY lada_user 1629 ALTER TABLE ONLY lada_user
1630 ADD CONSTRAINT lada_user_name_key UNIQUE (name); 1630 ADD CONSTRAINT lada_user_name_key UNIQUE (name);
1631 1631
1632 1632
1633 -- 1633 --
1634 -- Name: lada_user_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1634 -- Name: lada_user_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1635 -- 1635 --
1636 1636
1637 ALTER TABLE ONLY lada_user 1637 ALTER TABLE ONLY lada_user
1638 ADD CONSTRAINT lada_user_pkey PRIMARY KEY (id); 1638 ADD CONSTRAINT lada_user_pkey PRIMARY KEY (id);
1639 1639
1640 1640
1641 -- 1641 --
1642 -- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1642 -- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1643 -- 1643 --
1644 1644
1645 ALTER TABLE ONLY mess_einheit 1645 ALTER TABLE ONLY mess_einheit
1646 ADD CONSTRAINT mess_einheit_pkey PRIMARY KEY (id); 1646 ADD CONSTRAINT mess_einheit_pkey PRIMARY KEY (id);
1647 1647
1781 ALTER TABLE ONLY probenehmer 1781 ALTER TABLE ONLY probenehmer
1782 ADD CONSTRAINT probenehmer_pkey PRIMARY KEY (id); 1782 ADD CONSTRAINT probenehmer_pkey PRIMARY KEY (id);
1783 1783
1784 1784
1785 -- 1785 --
1786 -- Name: query_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1786 -- Name: query_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1787 -- 1787 --
1788 1788
1789 ALTER TABLE ONLY query 1789 ALTER TABLE ONLY query
1790 ADD CONSTRAINT query_pkey PRIMARY KEY (id); 1790 ADD CONSTRAINT query_pkey PRIMARY KEY (id);
1791 1791
1792 1792
1793 -- 1793 --
1794 -- Name: result_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1794 -- Name: result_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1795 -- 1795 --
1796 1796
1797 ALTER TABLE ONLY result 1797 ALTER TABLE ONLY result
1798 ADD CONSTRAINT result_pkey PRIMARY KEY (id); 1798 ADD CONSTRAINT result_pkey PRIMARY KEY (id);
1799 1799
1800 1800
1801 -- 1801 --
1802 -- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 1802 -- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
1803 -- 1803 --
1804 1804
1805 ALTER TABLE ONLY staat 1805 ALTER TABLE ONLY staat
1806 ADD CONSTRAINT staat_pkey PRIMARY KEY (id); 1806 ADD CONSTRAINT staat_pkey PRIMARY KEY (id);
1807 1807
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)