Revision 690
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 917 | 917 |
confidentialityreason character varying(200), |
| 918 | 918 |
publiclatitude double precision, |
| 919 | 919 |
publiclongitude double precision, |
| 920 |
accessioncode character varying(255), |
|
| 921 |
sublocationxposition double precision, |
|
| 922 |
sublocationyposition double precision, |
|
| 923 |
namedplace_id int(11), |
|
| 920 | 924 |
authore character varying(20), |
| 921 | 925 |
authorn character varying(20), |
| 922 | 926 |
authorzone character varying(20), |
| ... | ... | |
| 954 | 958 |
revisions int(1), |
| 955 | 959 |
dateentered timestamp NULL , |
| 956 | 960 |
emb_location int(11), |
| 957 |
locationrationalenarrative text, |
|
| 958 |
accessioncode character varying(255), |
|
| 959 |
sublocationxposition double precision, |
|
| 960 |
sublocationyposition double precision, |
|
| 961 |
namedplace_id int(11) |
|
| 961 |
locationrationalenarrative text |
|
| 962 | 962 |
); |
| 963 | 963 |
|
| 964 | 964 |
|
| ... | ... | |
| 986 | 986 |
location_id int(11), |
| 987 | 987 |
project_id int(11), |
| 988 | 988 |
authoreventcode character varying(30), |
| 989 |
accessioncode character varying(255), |
|
| 990 |
sourceaccessioncode character varying(100), |
|
| 989 | 991 |
dateaccuracy character varying(30), |
| 990 | 992 |
covermethod_id int(11), |
| 991 | 993 |
coverdispersion character varying(30), |
| ... | ... | |
| 1077 | 1079 |
toptaxon3name character varying(255), |
| 1078 | 1080 |
toptaxon4name character varying(255), |
| 1079 | 1081 |
toptaxon5name character varying(255), |
| 1080 |
numberoftaxa int(11), |
|
| 1081 |
accessioncode character varying(255), |
|
| 1082 |
sourceaccessioncode character varying(100) |
|
| 1082 |
numberoftaxa int(11) |
|
| 1083 | 1083 |
); |
| 1084 | 1084 |
|
| 1085 | 1085 |
|
| ... | ... | |
| 2333 | 2333 |
reference_id int(11), |
| 2334 | 2334 |
taxoninferencearea double precision, |
| 2335 | 2335 |
emb_taxonoccurrence int(11), |
| 2336 |
int_origplantconcept_id int(11), |
|
| 2337 |
int_origplantscifull character varying(255), |
|
| 2338 |
int_origplantscinamenoauth character varying(255), |
|
| 2339 |
int_origplantcommon character varying(255), |
|
| 2340 |
int_origplantcode character varying(255), |
|
| 2341 |
int_currplantconcept_id int(11), |
|
| 2342 |
int_currplantscifull character varying(255), |
|
| 2343 |
int_currplantscinamenoauth character varying(255), |
|
| 2344 |
int_currplantcommon character varying(255), |
|
| 2345 |
int_currplantcode character varying(255), |
|
| 2346 | 2336 |
accessioncode character varying(255) |
| 2347 | 2337 |
); |
| 2348 | 2338 |
|
| ... | ... | |
| 5405 | 5395 |
|
| 5406 | 5396 |
|
| 5407 | 5397 |
-- |
| 5408 |
-- Name: taxonoccurrence_int_currplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5409 |
-- |
|
| 5410 |
|
|
| 5411 |
CREATE INDEX taxonoccurrence_int_currplantconcept_id_x ON taxonoccurrence (int_currplantconcept_id); |
|
| 5412 |
|
|
| 5413 |
|
|
| 5414 |
-- |
|
| 5415 |
-- Name: taxonoccurrence_int_origplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5416 |
-- |
|
| 5417 |
|
|
| 5418 |
CREATE INDEX taxonoccurrence_int_origplantconcept_id_x ON taxonoccurrence (int_origplantconcept_id); |
|
| 5419 |
|
|
| 5420 |
|
|
| 5421 |
-- |
|
| 5422 | 5398 |
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5423 | 5399 |
-- |
| 5424 | 5400 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1061 | 1061 |
confidentialityreason character varying(200), |
| 1062 | 1062 |
publiclatitude double precision, |
| 1063 | 1063 |
publiclongitude double precision, |
| 1064 |
accessioncode character varying(255), |
|
| 1065 |
sublocationxposition double precision, |
|
| 1066 |
sublocationyposition double precision, |
|
| 1067 |
namedplace_id integer, |
|
| 1064 | 1068 |
authore character varying(20), |
| 1065 | 1069 |
authorn character varying(20), |
| 1066 | 1070 |
authorzone character varying(20), |
| ... | ... | |
| 1098 | 1102 |
revisions boolean, |
| 1099 | 1103 |
dateentered timestamp with time zone DEFAULT now(), |
| 1100 | 1104 |
emb_location integer, |
| 1101 |
locationrationalenarrative text, |
|
| 1102 |
accessioncode character varying(255), |
|
| 1103 |
sublocationxposition double precision, |
|
| 1104 |
sublocationyposition double precision, |
|
| 1105 |
namedplace_id integer |
|
| 1105 |
locationrationalenarrative text |
|
| 1106 | 1106 |
); |
| 1107 | 1107 |
|
| 1108 | 1108 |
|
| ... | ... | |
| 1135 | 1135 |
location_id integer, |
| 1136 | 1136 |
project_id integer, |
| 1137 | 1137 |
authoreventcode character varying(30), |
| 1138 |
accessioncode character varying(255), |
|
| 1139 |
sourceaccessioncode character varying(100), |
|
| 1138 | 1140 |
dateaccuracy character varying(30), |
| 1139 | 1141 |
covermethod_id integer, |
| 1140 | 1142 |
coverdispersion character varying(30), |
| ... | ... | |
| 1226 | 1228 |
toptaxon3name character varying(255), |
| 1227 | 1229 |
toptaxon4name character varying(255), |
| 1228 | 1230 |
toptaxon5name character varying(255), |
| 1229 |
numberoftaxa integer, |
|
| 1230 |
accessioncode character varying(255), |
|
| 1231 |
sourceaccessioncode character varying(100) |
|
| 1231 |
numberoftaxa integer |
|
| 1232 | 1232 |
); |
| 1233 | 1233 |
|
| 1234 | 1234 |
|
| ... | ... | |
| 2677 | 2677 |
reference_id integer, |
| 2678 | 2678 |
taxoninferencearea double precision, |
| 2679 | 2679 |
emb_taxonoccurrence integer, |
| 2680 |
int_origplantconcept_id integer, |
|
| 2681 |
int_origplantscifull character varying(255), |
|
| 2682 |
int_origplantscinamenoauth character varying(255), |
|
| 2683 |
int_origplantcommon character varying(255), |
|
| 2684 |
int_origplantcode character varying(255), |
|
| 2685 |
int_currplantconcept_id integer, |
|
| 2686 |
int_currplantscifull character varying(255), |
|
| 2687 |
int_currplantscinamenoauth character varying(255), |
|
| 2688 |
int_currplantcommon character varying(255), |
|
| 2689 |
int_currplantcode character varying(255), |
|
| 2690 | 2680 |
accessioncode character varying(255) |
| 2691 | 2681 |
); |
| 2692 | 2682 |
|
| ... | ... | |
| 5834 | 5824 |
|
| 5835 | 5825 |
|
| 5836 | 5826 |
-- |
| 5837 |
-- Name: taxonoccurrence_int_currplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5838 |
-- |
|
| 5839 |
|
|
| 5840 |
CREATE INDEX taxonoccurrence_int_currplantconcept_id_x ON taxonoccurrence USING btree (int_currplantconcept_id); |
|
| 5841 |
|
|
| 5842 |
|
|
| 5843 |
-- |
|
| 5844 |
-- Name: taxonoccurrence_int_origplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5845 |
-- |
|
| 5846 |
|
|
| 5847 |
CREATE INDEX taxonoccurrence_int_origplantconcept_id_x ON taxonoccurrence USING btree (int_origplantconcept_id); |
|
| 5848 |
|
|
| 5849 |
|
|
| 5850 |
-- |
|
| 5851 | 5827 |
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5852 | 5828 |
-- |
| 5853 | 5829 |
|
Also available in: Unified diff
vegbien.sql: Reordered fields in tables truncated in the ERD so that all removed fields are at the end of the table