Revision 1224
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1860 | 1860 |
soilobs_id int(11) NOT NULL, |
| 1861 | 1861 |
locationevent_id int(11) NOT NULL, |
| 1862 | 1862 |
soilhorizon text NOT NULL, |
| 1863 |
soildescription text, |
|
| 1863 | 1864 |
soildepthtop double precision, |
| 1864 | 1865 |
soildepthbottom double precision, |
| 1865 | 1866 |
soilcolor text, |
| 1867 |
soiltexture text, |
|
| 1866 | 1868 |
soilorganic double precision, |
| 1867 |
soiltexture text, |
|
| 1868 | 1869 |
soilsand double precision, |
| 1869 | 1870 |
soilsilt double precision, |
| 1870 | 1871 |
soilclay double precision, |
| 1871 | 1872 |
soilcoarse double precision, |
| 1872 | 1873 |
soilph double precision, |
| 1873 |
exchangecapacity double precision,
|
|
| 1874 |
acidity double precision,
|
|
| 1874 | 1875 |
basesaturation double precision, |
| 1875 |
soildescription text |
|
| 1876 |
cationexchangecapacity double precision, |
|
| 1877 |
conductivity double precision, |
|
| 1878 |
carbon double precision, |
|
| 1879 |
phosphorus double precision, |
|
| 1880 |
potassium double precision, |
|
| 1881 |
magnesium double precision, |
|
| 1882 |
nitrogen double precision, |
|
| 1883 |
calcium double precision, |
|
| 1884 |
sodium double precision |
|
| 1876 | 1885 |
); |
| 1877 | 1886 |
|
| 1878 | 1887 |
|
| 1879 | 1888 |
-- |
| 1889 |
-- Name: COLUMN soilobs.soilorganic; Type: COMMENT; Schema: public; Owner: - |
|
| 1890 |
-- |
|
| 1891 |
|
|
| 1892 |
|
|
| 1893 |
|
|
| 1894 |
|
|
| 1895 |
-- |
|
| 1896 |
-- Name: COLUMN soilobs.soilsand; Type: COMMENT; Schema: public; Owner: - |
|
| 1897 |
-- |
|
| 1898 |
|
|
| 1899 |
|
|
| 1900 |
|
|
| 1901 |
|
|
| 1902 |
-- |
|
| 1903 |
-- Name: COLUMN soilobs.soilsilt; Type: COMMENT; Schema: public; Owner: - |
|
| 1904 |
-- |
|
| 1905 |
|
|
| 1906 |
|
|
| 1907 |
|
|
| 1908 |
|
|
| 1909 |
-- |
|
| 1910 |
-- Name: COLUMN soilobs.soilclay; Type: COMMENT; Schema: public; Owner: - |
|
| 1911 |
-- |
|
| 1912 |
|
|
| 1913 |
|
|
| 1914 |
|
|
| 1915 |
|
|
| 1916 |
-- |
|
| 1917 |
-- Name: COLUMN soilobs.soilcoarse; Type: COMMENT; Schema: public; Owner: - |
|
| 1918 |
-- |
|
| 1919 |
|
|
| 1920 |
|
|
| 1921 |
|
|
| 1922 |
|
|
| 1923 |
-- |
|
| 1924 |
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: - |
|
| 1925 |
-- |
|
| 1926 |
|
|
| 1927 |
|
|
| 1928 |
|
|
| 1929 |
|
|
| 1930 |
-- |
|
| 1931 |
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: - |
|
| 1932 |
-- |
|
| 1933 |
|
|
| 1934 |
|
|
| 1935 |
|
|
| 1936 |
|
|
| 1937 |
-- |
|
| 1938 |
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: - |
|
| 1939 |
-- |
|
| 1940 |
|
|
| 1941 |
|
|
| 1942 |
|
|
| 1943 |
|
|
| 1944 |
-- |
|
| 1945 |
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: - |
|
| 1946 |
-- |
|
| 1947 |
|
|
| 1948 |
|
|
| 1949 |
|
|
| 1950 |
|
|
| 1951 |
-- |
|
| 1952 |
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: - |
|
| 1953 |
-- |
|
| 1954 |
|
|
| 1955 |
|
|
| 1956 |
|
|
| 1957 |
|
|
| 1958 |
-- |
|
| 1959 |
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: - |
|
| 1960 |
-- |
|
| 1961 |
|
|
| 1962 |
|
|
| 1963 |
|
|
| 1964 |
|
|
| 1965 |
-- |
|
| 1966 |
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: - |
|
| 1967 |
-- |
|
| 1968 |
|
|
| 1969 |
|
|
| 1970 |
|
|
| 1971 |
|
|
| 1972 |
-- |
|
| 1973 |
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: - |
|
| 1974 |
-- |
|
| 1975 |
|
|
| 1976 |
|
|
| 1977 |
|
|
| 1978 |
|
|
| 1979 |
-- |
|
| 1980 |
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: - |
|
| 1981 |
-- |
|
| 1982 |
|
|
| 1983 |
|
|
| 1984 |
|
|
| 1985 |
|
|
| 1986 |
-- |
|
| 1880 | 1987 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1881 | 1988 |
-- |
| 1882 | 1989 |
|
Also available in: Unified diff
vegbien.sql: soilobs: Converted user-defined fields to first-class. Labeled appropriate fields as "fraction".