Revision 6859
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2664 | 2664 |
|
| 2665 | 2665 |
|
| 2666 | 2666 |
-- |
| 2667 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2668 |
-- |
|
| 2669 |
|
|
| 2670 |
CREATE TABLE sourcename ( |
|
| 2671 |
sourcelist_id int(11) NOT NULL, |
|
| 2672 |
name varchar(255) NOT NULL, |
|
| 2673 |
matched_source_id int(11) |
|
| 2674 |
); |
|
| 2675 |
|
|
| 2676 |
|
|
| 2677 |
-- |
|
| 2678 |
-- Name: provider_view; Type: VIEW; Schema: public; Owner: - |
|
| 2679 |
-- |
|
| 2680 |
|
|
| 2681 |
|
|
| 2682 |
|
|
| 2683 |
|
|
| 2684 |
-- |
|
| 2667 | 2685 |
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2668 | 2686 |
-- |
| 2669 | 2687 |
|
| ... | ... | |
| 2861 | 2879 |
|
| 2862 | 2880 |
|
| 2863 | 2881 |
-- |
| 2864 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2865 |
-- |
|
| 2866 |
|
|
| 2867 |
CREATE TABLE sourcename ( |
|
| 2868 |
sourcelist_id int(11) NOT NULL, |
|
| 2869 |
name varchar(255) NOT NULL, |
|
| 2870 |
matched_source_id int(11) |
|
| 2871 |
); |
|
| 2872 |
|
|
| 2873 |
|
|
| 2874 |
-- |
|
| 2875 | 2882 |
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2876 | 2883 |
-- |
| 2877 | 2884 |
|
| ... | ... | |
| 7030 | 7037 |
|
| 7031 | 7038 |
|
| 7032 | 7039 |
-- |
| 7033 |
-- Name: revision; Type: ACL; Schema: public; Owner: -
|
|
| 7040 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
|
|
| 7034 | 7041 |
-- |
| 7035 | 7042 |
|
| 7036 | 7043 |
|
| ... | ... | |
| 7039 | 7046 |
|
| 7040 | 7047 |
|
| 7041 | 7048 |
|
| 7049 |
|
|
| 7042 | 7050 |
-- |
| 7043 |
-- Name: soilsample; Type: ACL; Schema: public; Owner: -
|
|
| 7051 |
-- Name: provider_view; Type: ACL; Schema: public; Owner: -
|
|
| 7044 | 7052 |
-- |
| 7045 | 7053 |
|
| 7046 | 7054 |
|
| ... | ... | |
| 7049 | 7057 |
|
| 7050 | 7058 |
|
| 7051 | 7059 |
|
| 7060 |
|
|
| 7052 | 7061 |
-- |
| 7053 |
-- Name: soiltaxon; Type: ACL; Schema: public; Owner: -
|
|
| 7062 |
-- Name: revision; Type: ACL; Schema: public; Owner: -
|
|
| 7054 | 7063 |
-- |
| 7055 | 7064 |
|
| 7056 | 7065 |
|
| ... | ... | |
| 7060 | 7069 |
|
| 7061 | 7070 |
|
| 7062 | 7071 |
-- |
| 7063 |
-- Name: sourcecontributor; Type: ACL; Schema: public; Owner: -
|
|
| 7072 |
-- Name: soilsample; Type: ACL; Schema: public; Owner: -
|
|
| 7064 | 7073 |
-- |
| 7065 | 7074 |
|
| 7066 | 7075 |
|
| ... | ... | |
| 7070 | 7079 |
|
| 7071 | 7080 |
|
| 7072 | 7081 |
-- |
| 7073 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
|
|
| 7082 |
-- Name: soiltaxon; Type: ACL; Schema: public; Owner: -
|
|
| 7074 | 7083 |
-- |
| 7075 | 7084 |
|
| 7076 | 7085 |
|
| ... | ... | |
| 7079 | 7088 |
|
| 7080 | 7089 |
|
| 7081 | 7090 |
|
| 7091 |
-- |
|
| 7092 |
-- Name: sourcecontributor; Type: ACL; Schema: public; Owner: - |
|
| 7093 |
-- |
|
| 7082 | 7094 |
|
| 7095 |
|
|
| 7096 |
|
|
| 7097 |
|
|
| 7098 |
|
|
| 7099 |
|
|
| 7100 |
|
|
| 7083 | 7101 |
-- |
| 7084 | 7102 |
-- Name: specimen; Type: ACL; Schema: public; Owner: - |
| 7085 | 7103 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Added provider_view, which combines source and sourcename