Revision 6435
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 800 | 800 |
|
| 801 | 801 |
|
| 802 | 802 |
-- |
| 803 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 804 |
-- |
|
| 805 |
|
|
| 806 |
CREATE TABLE cultivated_family_locations ( |
|
| 807 |
family varchar(255) NOT NULL, |
|
| 808 |
country varchar(255) NOT NULL |
|
| 809 |
); |
|
| 810 |
|
|
| 811 |
|
|
| 812 |
-- |
|
| 803 | 813 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 804 | 814 |
-- |
| 805 | 815 |
|
| ... | ... | |
| 1869 | 1879 |
|
| 1870 | 1880 |
|
| 1871 | 1881 |
-- |
| 1872 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1873 |
-- |
|
| 1874 |
|
|
| 1875 |
CREATE TABLE cultivated_family_locations ( |
|
| 1876 |
family varchar(255) NOT NULL, |
|
| 1877 |
country varchar(255) NOT NULL |
|
| 1878 |
); |
|
| 1879 |
|
|
| 1880 |
|
|
| 1881 |
-- |
|
| 1882 | 1882 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1883 | 1883 |
-- |
| 1884 | 1884 |
|
| ... | ... | |
| 6467 | 6467 |
|
| 6468 | 6468 |
|
| 6469 | 6469 |
-- |
| 6470 |
-- Name: cultivated_family_locations; Type: ACL; Schema: public; Owner: - |
|
| 6471 |
-- |
|
| 6472 |
|
|
| 6473 |
|
|
| 6474 |
|
|
| 6475 |
|
|
| 6476 |
|
|
| 6477 |
|
|
| 6478 |
|
|
| 6479 |
-- |
|
| 6470 | 6480 |
-- Name: family_higher_plant_group; Type: ACL; Schema: public; Owner: - |
| 6471 | 6481 |
-- |
| 6472 | 6482 |
|
| ... | ... | |
| 6717 | 6727 |
|
| 6718 | 6728 |
|
| 6719 | 6729 |
-- |
| 6720 |
-- Name: cultivated_family_locations; Type: ACL; Schema: public; Owner: - |
|
| 6721 |
-- |
|
| 6722 |
|
|
| 6723 |
|
|
| 6724 |
|
|
| 6725 |
|
|
| 6726 |
|
|
| 6727 |
|
|
| 6728 |
|
|
| 6729 |
-- |
|
| 6730 | 6730 |
-- Name: definedvalue; Type: ACL; Schema: public; Owner: - |
| 6731 | 6731 |
-- |
| 6732 | 6732 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: cultivated: Also set if family/country combination found in cultivated_family_locations