Revision 1224
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2187 | 2187 |
soilobs_id integer NOT NULL, |
| 2188 | 2188 |
locationevent_id integer NOT NULL, |
| 2189 | 2189 |
soilhorizon text NOT NULL, |
| 2190 |
soildescription text, |
|
| 2190 | 2191 |
soildepthtop double precision, |
| 2191 | 2192 |
soildepthbottom double precision, |
| 2192 | 2193 |
soilcolor text, |
| 2194 |
soiltexture text, |
|
| 2193 | 2195 |
soilorganic double precision, |
| 2194 |
soiltexture text, |
|
| 2195 | 2196 |
soilsand double precision, |
| 2196 | 2197 |
soilsilt double precision, |
| 2197 | 2198 |
soilclay double precision, |
| 2198 | 2199 |
soilcoarse double precision, |
| 2199 | 2200 |
soilph double precision, |
| 2200 |
exchangecapacity double precision,
|
|
| 2201 |
acidity double precision,
|
|
| 2201 | 2202 |
basesaturation double precision, |
| 2202 |
soildescription text |
|
| 2203 |
cationexchangecapacity double precision, |
|
| 2204 |
conductivity double precision, |
|
| 2205 |
carbon double precision, |
|
| 2206 |
phosphorus double precision, |
|
| 2207 |
potassium double precision, |
|
| 2208 |
magnesium double precision, |
|
| 2209 |
nitrogen double precision, |
|
| 2210 |
calcium double precision, |
|
| 2211 |
sodium double precision |
|
| 2203 | 2212 |
); |
| 2204 | 2213 |
|
| 2205 | 2214 |
|
| 2206 | 2215 |
-- |
| 2216 |
-- Name: COLUMN soilobs.soilorganic; Type: COMMENT; Schema: public; Owner: - |
|
| 2217 |
-- |
|
| 2218 |
|
|
| 2219 |
COMMENT ON COLUMN soilobs.soilorganic IS 'fraction'; |
|
| 2220 |
|
|
| 2221 |
|
|
| 2222 |
-- |
|
| 2223 |
-- Name: COLUMN soilobs.soilsand; Type: COMMENT; Schema: public; Owner: - |
|
| 2224 |
-- |
|
| 2225 |
|
|
| 2226 |
COMMENT ON COLUMN soilobs.soilsand IS 'fraction'; |
|
| 2227 |
|
|
| 2228 |
|
|
| 2229 |
-- |
|
| 2230 |
-- Name: COLUMN soilobs.soilsilt; Type: COMMENT; Schema: public; Owner: - |
|
| 2231 |
-- |
|
| 2232 |
|
|
| 2233 |
COMMENT ON COLUMN soilobs.soilsilt IS 'fraction'; |
|
| 2234 |
|
|
| 2235 |
|
|
| 2236 |
-- |
|
| 2237 |
-- Name: COLUMN soilobs.soilclay; Type: COMMENT; Schema: public; Owner: - |
|
| 2238 |
-- |
|
| 2239 |
|
|
| 2240 |
COMMENT ON COLUMN soilobs.soilclay IS 'fraction'; |
|
| 2241 |
|
|
| 2242 |
|
|
| 2243 |
-- |
|
| 2244 |
-- Name: COLUMN soilobs.soilcoarse; Type: COMMENT; Schema: public; Owner: - |
|
| 2245 |
-- |
|
| 2246 |
|
|
| 2247 |
COMMENT ON COLUMN soilobs.soilcoarse IS 'fraction'; |
|
| 2248 |
|
|
| 2249 |
|
|
| 2250 |
-- |
|
| 2251 |
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: - |
|
| 2252 |
-- |
|
| 2253 |
|
|
| 2254 |
COMMENT ON COLUMN soilobs.acidity IS 'fraction'; |
|
| 2255 |
|
|
| 2256 |
|
|
| 2257 |
-- |
|
| 2258 |
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: - |
|
| 2259 |
-- |
|
| 2260 |
|
|
| 2261 |
COMMENT ON COLUMN soilobs.basesaturation IS 'fraction'; |
|
| 2262 |
|
|
| 2263 |
|
|
| 2264 |
-- |
|
| 2265 |
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: - |
|
| 2266 |
-- |
|
| 2267 |
|
|
| 2268 |
COMMENT ON COLUMN soilobs.carbon IS 'fraction'; |
|
| 2269 |
|
|
| 2270 |
|
|
| 2271 |
-- |
|
| 2272 |
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: - |
|
| 2273 |
-- |
|
| 2274 |
|
|
| 2275 |
COMMENT ON COLUMN soilobs.phosphorus IS 'fraction'; |
|
| 2276 |
|
|
| 2277 |
|
|
| 2278 |
-- |
|
| 2279 |
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: - |
|
| 2280 |
-- |
|
| 2281 |
|
|
| 2282 |
COMMENT ON COLUMN soilobs.potassium IS 'fraction'; |
|
| 2283 |
|
|
| 2284 |
|
|
| 2285 |
-- |
|
| 2286 |
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: - |
|
| 2287 |
-- |
|
| 2288 |
|
|
| 2289 |
COMMENT ON COLUMN soilobs.magnesium IS 'fraction'; |
|
| 2290 |
|
|
| 2291 |
|
|
| 2292 |
-- |
|
| 2293 |
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: - |
|
| 2294 |
-- |
|
| 2295 |
|
|
| 2296 |
COMMENT ON COLUMN soilobs.nitrogen IS 'fraction'; |
|
| 2297 |
|
|
| 2298 |
|
|
| 2299 |
-- |
|
| 2300 |
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: - |
|
| 2301 |
-- |
|
| 2302 |
|
|
| 2303 |
COMMENT ON COLUMN soilobs.calcium IS 'fraction'; |
|
| 2304 |
|
|
| 2305 |
|
|
| 2306 |
-- |
|
| 2307 |
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: - |
|
| 2308 |
-- |
|
| 2309 |
|
|
| 2310 |
COMMENT ON COLUMN soilobs.sodium IS 'fraction'; |
|
| 2311 |
|
|
| 2312 |
|
|
| 2313 |
-- |
|
| 2207 | 2314 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2208 | 2315 |
-- |
| 2209 | 2316 |
|
Also available in: Unified diff
vegbien.sql: soilobs: Converted user-defined fields to first-class. Labeled appropriate fields as "fraction".