Revision 4959
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 578 | 578 |
|
| 579 | 579 |
|
| 580 | 580 |
-- |
| 581 |
-- Name: COLUMN method.length_m; Type: COMMENT; Schema: public; Owner: - |
|
| 582 |
-- |
|
| 583 |
|
|
| 584 |
|
|
| 585 |
|
|
| 586 |
|
|
| 587 |
-- |
|
| 588 |
-- Name: COLUMN method.width_m; Type: COMMENT; Schema: public; Owner: - |
|
| 589 |
-- |
|
| 590 |
|
|
| 591 |
|
|
| 592 |
|
|
| 593 |
|
|
| 594 |
-- |
|
| 595 |
-- Name: COLUMN method.radius_m; Type: COMMENT; Schema: public; Owner: - |
|
| 596 |
-- |
|
| 597 |
|
|
| 598 |
|
|
| 599 |
|
|
| 600 |
|
|
| 601 |
-- |
|
| 602 |
-- Name: COLUMN method.area_m2; Type: COMMENT; Schema: public; Owner: - |
|
| 603 |
-- |
|
| 604 |
|
|
| 605 |
|
|
| 606 |
|
|
| 607 |
|
|
| 608 |
-- |
|
| 609 | 581 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: - |
| 610 | 582 |
-- |
| 611 | 583 |
|
| ... | ... | |
| 2131 | 2103 |
|
| 2132 | 2104 |
|
| 2133 | 2105 |
-- |
| 2134 |
-- Name: COLUMN soilobs.organic_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2135 |
-- |
|
| 2136 |
|
|
| 2137 |
|
|
| 2138 |
|
|
| 2139 |
|
|
| 2140 |
-- |
|
| 2141 |
-- Name: COLUMN soilobs.sand_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2142 |
-- |
|
| 2143 |
|
|
| 2144 |
|
|
| 2145 |
|
|
| 2146 |
|
|
| 2147 |
-- |
|
| 2148 |
-- Name: COLUMN soilobs.silt_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2149 |
-- |
|
| 2150 |
|
|
| 2151 |
|
|
| 2152 |
|
|
| 2153 |
|
|
| 2154 |
-- |
|
| 2155 |
-- Name: COLUMN soilobs.clay_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2156 |
-- |
|
| 2157 |
|
|
| 2158 |
|
|
| 2159 |
|
|
| 2160 |
|
|
| 2161 |
-- |
|
| 2162 |
-- Name: COLUMN soilobs.coarse_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2163 |
-- |
|
| 2164 |
|
|
| 2165 |
|
|
| 2166 |
|
|
| 2167 |
|
|
| 2168 |
-- |
|
| 2169 |
-- Name: COLUMN soilobs.acidity_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2170 |
-- |
|
| 2171 |
|
|
| 2172 |
|
|
| 2173 |
|
|
| 2174 |
|
|
| 2175 |
-- |
|
| 2176 |
-- Name: COLUMN soilobs.basesaturation_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2177 |
-- |
|
| 2178 |
|
|
| 2179 |
|
|
| 2180 |
|
|
| 2181 |
|
|
| 2182 |
-- |
|
| 2183 |
-- Name: COLUMN soilobs.carbon_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2184 |
-- |
|
| 2185 |
|
|
| 2186 |
|
|
| 2187 |
|
|
| 2188 |
|
|
| 2189 |
-- |
|
| 2190 |
-- Name: COLUMN soilobs.phosphorus_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2191 |
-- |
|
| 2192 |
|
|
| 2193 |
|
|
| 2194 |
|
|
| 2195 |
|
|
| 2196 |
-- |
|
| 2197 |
-- Name: COLUMN soilobs.potassium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2198 |
-- |
|
| 2199 |
|
|
| 2200 |
|
|
| 2201 |
|
|
| 2202 |
|
|
| 2203 |
-- |
|
| 2204 |
-- Name: COLUMN soilobs.magnesium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2205 |
-- |
|
| 2206 |
|
|
| 2207 |
|
|
| 2208 |
|
|
| 2209 |
|
|
| 2210 |
-- |
|
| 2211 |
-- Name: COLUMN soilobs.nitrogen_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2212 |
-- |
|
| 2213 |
|
|
| 2214 |
|
|
| 2215 |
|
|
| 2216 |
|
|
| 2217 |
-- |
|
| 2218 |
-- Name: COLUMN soilobs.calcium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2219 |
-- |
|
| 2220 |
|
|
| 2221 |
|
|
| 2222 |
|
|
| 2223 |
|
|
| 2224 |
-- |
|
| 2225 |
-- Name: COLUMN soilobs.sodium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2226 |
-- |
|
| 2227 |
|
|
| 2228 |
|
|
| 2229 |
|
|
| 2230 |
|
|
| 2231 |
-- |
|
| 2232 | 2106 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2233 | 2107 |
-- |
| 2234 | 2108 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 863 | 863 |
|
| 864 | 864 |
|
| 865 | 865 |
-- |
| 866 |
-- Name: COLUMN method.length_m; Type: COMMENT; Schema: public; Owner: - |
|
| 867 |
-- |
|
| 868 |
|
|
| 869 |
COMMENT ON COLUMN method.length_m IS 'Units: m'; |
|
| 870 |
|
|
| 871 |
|
|
| 872 |
-- |
|
| 873 |
-- Name: COLUMN method.width_m; Type: COMMENT; Schema: public; Owner: - |
|
| 874 |
-- |
|
| 875 |
|
|
| 876 |
COMMENT ON COLUMN method.width_m IS 'Units: m'; |
|
| 877 |
|
|
| 878 |
|
|
| 879 |
-- |
|
| 880 |
-- Name: COLUMN method.radius_m; Type: COMMENT; Schema: public; Owner: - |
|
| 881 |
-- |
|
| 882 |
|
|
| 883 |
COMMENT ON COLUMN method.radius_m IS 'Units: m'; |
|
| 884 |
|
|
| 885 |
|
|
| 886 |
-- |
|
| 887 |
-- Name: COLUMN method.area_m2; Type: COMMENT; Schema: public; Owner: - |
|
| 888 |
-- |
|
| 889 |
|
|
| 890 |
COMMENT ON COLUMN method.area_m2 IS 'Units: m^2'; |
|
| 891 |
|
|
| 892 |
|
|
| 893 |
-- |
|
| 894 | 866 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: - |
| 895 | 867 |
-- |
| 896 | 868 |
|
| 897 |
COMMENT ON COLUMN method.samplearea_m2 IS 'The total surface area used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space. |
|
| 869 |
COMMENT ON COLUMN method.samplearea_m2 IS 'The total surface area used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space.';
|
|
| 898 | 870 |
|
| 899 |
Units: m^2'; |
|
| 900 | 871 |
|
| 901 |
|
|
| 902 | 872 |
-- |
| 903 | 873 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: - |
| 904 | 874 |
-- |
| ... | ... | |
| 2644 | 2614 |
|
| 2645 | 2615 |
|
| 2646 | 2616 |
-- |
| 2647 |
-- Name: COLUMN soilobs.organic_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2648 |
-- |
|
| 2649 |
|
|
| 2650 |
COMMENT ON COLUMN soilobs.organic_fraction IS 'fraction'; |
|
| 2651 |
|
|
| 2652 |
|
|
| 2653 |
-- |
|
| 2654 |
-- Name: COLUMN soilobs.sand_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2655 |
-- |
|
| 2656 |
|
|
| 2657 |
COMMENT ON COLUMN soilobs.sand_fraction IS 'fraction'; |
|
| 2658 |
|
|
| 2659 |
|
|
| 2660 |
-- |
|
| 2661 |
-- Name: COLUMN soilobs.silt_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2662 |
-- |
|
| 2663 |
|
|
| 2664 |
COMMENT ON COLUMN soilobs.silt_fraction IS 'fraction'; |
|
| 2665 |
|
|
| 2666 |
|
|
| 2667 |
-- |
|
| 2668 |
-- Name: COLUMN soilobs.clay_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2669 |
-- |
|
| 2670 |
|
|
| 2671 |
COMMENT ON COLUMN soilobs.clay_fraction IS 'fraction'; |
|
| 2672 |
|
|
| 2673 |
|
|
| 2674 |
-- |
|
| 2675 |
-- Name: COLUMN soilobs.coarse_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2676 |
-- |
|
| 2677 |
|
|
| 2678 |
COMMENT ON COLUMN soilobs.coarse_fraction IS 'fraction'; |
|
| 2679 |
|
|
| 2680 |
|
|
| 2681 |
-- |
|
| 2682 |
-- Name: COLUMN soilobs.acidity_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2683 |
-- |
|
| 2684 |
|
|
| 2685 |
COMMENT ON COLUMN soilobs.acidity_fraction IS 'fraction'; |
|
| 2686 |
|
|
| 2687 |
|
|
| 2688 |
-- |
|
| 2689 |
-- Name: COLUMN soilobs.basesaturation_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2690 |
-- |
|
| 2691 |
|
|
| 2692 |
COMMENT ON COLUMN soilobs.basesaturation_fraction IS 'fraction'; |
|
| 2693 |
|
|
| 2694 |
|
|
| 2695 |
-- |
|
| 2696 |
-- Name: COLUMN soilobs.carbon_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2697 |
-- |
|
| 2698 |
|
|
| 2699 |
COMMENT ON COLUMN soilobs.carbon_fraction IS 'fraction'; |
|
| 2700 |
|
|
| 2701 |
|
|
| 2702 |
-- |
|
| 2703 |
-- Name: COLUMN soilobs.phosphorus_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2704 |
-- |
|
| 2705 |
|
|
| 2706 |
COMMENT ON COLUMN soilobs.phosphorus_fraction IS 'fraction'; |
|
| 2707 |
|
|
| 2708 |
|
|
| 2709 |
-- |
|
| 2710 |
-- Name: COLUMN soilobs.potassium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2711 |
-- |
|
| 2712 |
|
|
| 2713 |
COMMENT ON COLUMN soilobs.potassium_fraction IS 'fraction'; |
|
| 2714 |
|
|
| 2715 |
|
|
| 2716 |
-- |
|
| 2717 |
-- Name: COLUMN soilobs.magnesium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2718 |
-- |
|
| 2719 |
|
|
| 2720 |
COMMENT ON COLUMN soilobs.magnesium_fraction IS 'fraction'; |
|
| 2721 |
|
|
| 2722 |
|
|
| 2723 |
-- |
|
| 2724 |
-- Name: COLUMN soilobs.nitrogen_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2725 |
-- |
|
| 2726 |
|
|
| 2727 |
COMMENT ON COLUMN soilobs.nitrogen_fraction IS 'fraction'; |
|
| 2728 |
|
|
| 2729 |
|
|
| 2730 |
-- |
|
| 2731 |
-- Name: COLUMN soilobs.calcium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2732 |
-- |
|
| 2733 |
|
|
| 2734 |
COMMENT ON COLUMN soilobs.calcium_fraction IS 'fraction'; |
|
| 2735 |
|
|
| 2736 |
|
|
| 2737 |
-- |
|
| 2738 |
-- Name: COLUMN soilobs.sodium_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 2739 |
-- |
|
| 2740 |
|
|
| 2741 |
COMMENT ON COLUMN soilobs.sodium_fraction IS 'fraction'; |
|
| 2742 |
|
|
| 2743 |
|
|
| 2744 |
-- |
|
| 2745 | 2617 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2746 | 2618 |
-- |
| 2747 | 2619 |
|
Also available in: Unified diff
schemas/vegbien.sql: comments: Removed units from comments on fields which already have a units suffix, to avoid having to keep the units in sync between the suffix and the comment. Note that the units were abbreviated equally in the suffixes and comments, so this did not result in a loss of information other than the ^ for a quantity squared (but it's obvious enough that m2 is m^2).