Revision 14461
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 5937 | 5937 |
|
| 5938 | 5938 |
|
| 5939 | 5939 |
-- |
| 5940 |
-- Name: collected_dates; Type: VIEW; Schema: public; Owner: -
|
|
| 5940 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5941 | 5941 |
-- |
| 5942 | 5942 |
|
| 5943 |
CREATE TABLE coordinates ( |
|
| 5944 |
coordinates_id int(11) NOT NULL, |
|
| 5945 |
source_id int(11) NOT NULL, |
|
| 5946 |
latitude_deg double NOT NULL, |
|
| 5947 |
longitude_deg double NOT NULL, |
|
| 5948 |
verbatimlatitude varchar(255), |
|
| 5949 |
verbatimlongitude varchar(255), |
|
| 5950 |
verbatimcoordinates varchar(255), |
|
| 5951 |
footprintgeometry_dwc varchar(255), |
|
| 5952 |
coordsaccuracy_m double |
|
| 5953 |
); |
|
| 5943 | 5954 |
|
| 5944 | 5955 |
|
| 5956 |
-- |
|
| 5957 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 5958 |
-- |
|
| 5945 | 5959 |
|
| 5960 |
|
|
| 5961 |
|
|
| 5962 |
|
|
| 5946 | 5963 |
-- |
| 5947 |
-- Name: COLUMN collected_dates.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5964 |
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5948 | 5965 |
-- |
| 5949 | 5966 |
|
| 5950 | 5967 |
|
| 5951 | 5968 |
|
| 5952 | 5969 |
|
| 5953 | 5970 |
-- |
| 5954 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5971 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5955 | 5972 |
-- |
| 5956 | 5973 |
|
| 5957 |
CREATE TABLE commclass ( |
|
| 5958 |
commclass_id int(11) NOT NULL, |
|
| 5959 |
locationevent_id int(11) NOT NULL, |
|
| 5960 |
inspection int(1), |
|
| 5961 |
tableanalysis int(1), |
|
| 5962 |
multivariateanalysis int(1), |
|
| 5963 |
classpublication_id int(11), |
|
| 5964 |
classnotes varchar(255), |
|
| 5965 |
commname varchar(255), |
|
| 5966 |
commcode varchar(255), |
|
| 5967 |
commframework varchar(255), |
|
| 5968 |
commlevel varchar(255), |
|
| 5969 |
classstartdate date, |
|
| 5970 |
classstopdate date, |
|
| 5971 |
expertsystem varchar(255) |
|
| 5974 |
CREATE TABLE cultivated_family_locations ( |
|
| 5975 |
family varchar(255) NOT NULL, |
|
| 5976 |
country varchar(255) NOT NULL |
|
| 5972 | 5977 |
); |
| 5973 | 5978 |
|
| 5974 | 5979 |
|
| 5975 | 5980 |
-- |
| 5976 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5981 |
-- Name: TABLE cultivated_family_locations; Type: COMMENT; Schema: public; Owner: -
|
|
| 5977 | 5982 |
-- |
| 5978 | 5983 |
|
| 5979 | 5984 |
|
| 5980 | 5985 |
|
| 5981 | 5986 |
|
| 5982 | 5987 |
-- |
| 5983 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5988 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5984 | 5989 |
-- |
| 5985 | 5990 |
|
| 5991 |
CREATE TABLE family_higher_plant_group ( |
|
| 5992 |
family varchar(255) NOT NULL, |
|
| 5993 |
higher_plant_group varchar(255) |
|
| 5994 |
); |
|
| 5986 | 5995 |
|
| 5987 | 5996 |
|
| 5988 |
|
|
| 5989 | 5997 |
-- |
| 5990 |
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5998 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5991 | 5999 |
-- |
| 5992 | 6000 |
|
| 5993 |
CREATE TABLE commconcept ( |
|
| 5994 |
commconcept_id int(11) NOT NULL, |
|
| 5995 |
commname_id int(11) NOT NULL, |
|
| 5996 |
reference_id int(11), |
|
| 5997 |
commdescription varchar(255), |
|
| 5998 |
commname varchar(255) |
|
| 6001 |
CREATE TABLE location ( |
|
| 6002 |
location_id int(11) NOT NULL, |
|
| 6003 |
source_id int(11) NOT NULL, |
|
| 6004 |
sourceaccessioncode varchar(255), |
|
| 6005 |
plot_location_id int(11) NOT NULL, |
|
| 6006 |
parent_id int(11), |
|
| 6007 |
authorlocationcode varchar(255), |
|
| 6008 |
place_id int(11), |
|
| 6009 |
accesslevel varchar(255), |
|
| 6010 |
accessconditions varchar(255), |
|
| 6011 |
sublocationxposition_m double, |
|
| 6012 |
sublocationyposition_m double, |
|
| 6013 |
iscultivated int(1), |
|
| 6014 |
authorzone varchar(255), |
|
| 6015 |
authordatum varchar(255), |
|
| 6016 |
authorlocation varchar(255), |
|
| 6017 |
locationnarrative varchar(255), |
|
| 6018 |
azimuth double, |
|
| 6019 |
shape varchar(255), |
|
| 6020 |
area_m2 double, |
|
| 6021 |
standsize varchar(255), |
|
| 6022 |
placementmethod varchar(255), |
|
| 6023 |
permanence int(1), |
|
| 6024 |
layoutnarrative varchar(255), |
|
| 6025 |
elevation_m double, |
|
| 6026 |
elevationaccuracy_m double, |
|
| 6027 |
elevationrange_m double, |
|
| 6028 |
verbatimelevation varchar(255), |
|
| 6029 |
slopeaspect_deg double, |
|
| 6030 |
minslopeaspect_deg double, |
|
| 6031 |
maxslopeaspect_deg double, |
|
| 6032 |
slopegradient_fraction double, |
|
| 6033 |
minslopegradient_fraction double, |
|
| 6034 |
maxslopegradient_fraction double, |
|
| 6035 |
topoposition varchar(255), |
|
| 6036 |
landform varchar(255), |
|
| 6037 |
surficialdeposits varchar(255), |
|
| 6038 |
rocktype varchar(255), |
|
| 6039 |
submitter_surname varchar(255), |
|
| 6040 |
submitter_givenname varchar(255), |
|
| 6041 |
submitter_email varchar(255), |
|
| 6042 |
notespublic int(1), |
|
| 6043 |
notesmgt int(1), |
|
| 6044 |
revisions int(1), |
|
| 6045 |
dateentered date , |
|
| 6046 |
locationrationalenarrative varchar(255) |
|
| 5999 | 6047 |
); |
| 6000 | 6048 |
|
| 6001 | 6049 |
|
| 6002 | 6050 |
-- |
| 6003 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6051 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
|
|
| 6004 | 6052 |
-- |
| 6005 | 6053 |
|
| 6006 | 6054 |
|
| 6007 | 6055 |
|
| 6008 | 6056 |
|
| 6009 | 6057 |
-- |
| 6010 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6058 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6011 | 6059 |
-- |
| 6012 | 6060 |
|
| 6013 | 6061 |
|
| 6014 | 6062 |
|
| 6015 | 6063 |
|
| 6016 | 6064 |
-- |
| 6017 |
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6065 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6018 | 6066 |
-- |
| 6019 | 6067 |
|
| 6020 |
CREATE TABLE commcorrelation ( |
|
| 6021 |
commcorrelation_id int(11) NOT NULL, |
|
| 6022 |
commstatus_id int(11) NOT NULL, |
|
| 6023 |
commconcept_id int(11) NOT NULL, |
|
| 6024 |
commconvergence varchar(255) NOT NULL, |
|
| 6025 |
correlationstart date NOT NULL, |
|
| 6026 |
correlationstop date |
|
| 6068 |
CREATE TABLE locationevent ( |
|
| 6069 |
locationevent_id int(11) NOT NULL, |
|
| 6070 |
source_id int(11) NOT NULL, |
|
| 6071 |
sourceaccessioncode varchar(255), |
|
| 6072 |
accesslevel varchar(255), |
|
| 6073 |
place_visit_id int(11) NOT NULL, |
|
| 6074 |
parent_id int(11), |
|
| 6075 |
plot_id int(11), |
|
| 6076 |
location_id int(11), |
|
| 6077 |
project_id int(11), |
|
| 6078 |
stratum_id int(11), |
|
| 6079 |
authoreventcode varchar(255), |
|
| 6080 |
previous_id int(11), |
|
| 6081 |
obsstartdate date, |
|
| 6082 |
obsenddate date, |
|
| 6083 |
dateaccuracy varchar(255), |
|
| 6084 |
method_id int(11), |
|
| 6085 |
temperature_c double, |
|
| 6086 |
precipitation_m double, |
|
| 6087 |
autotaxoncover int(1), |
|
| 6088 |
originaldata varchar(255), |
|
| 6089 |
effortlevel varchar(255), |
|
| 6090 |
floristicquality varchar(255), |
|
| 6091 |
bryophytequality varchar(255), |
|
| 6092 |
lichenquality varchar(255), |
|
| 6093 |
locationeventnarrative varchar(255), |
|
| 6094 |
landscapenarrative varchar(255), |
|
| 6095 |
homogeneity varchar(255), |
|
| 6096 |
phenologicaspect varchar(255), |
|
| 6097 |
representativeness varchar(255), |
|
| 6098 |
standmaturity varchar(255), |
|
| 6099 |
successionalstatus varchar(255), |
|
| 6100 |
basalarea double, |
|
| 6101 |
hydrologicregime varchar(255), |
|
| 6102 |
soilmoistureregime varchar(255), |
|
| 6103 |
soildrainage varchar(255), |
|
| 6104 |
watersalinity varchar(255), |
|
| 6105 |
waterdepth_m double, |
|
| 6106 |
shoredistance double, |
|
| 6107 |
soildepth double, |
|
| 6108 |
organicdepth double, |
|
| 6109 |
soiltaxon_id int(11), |
|
| 6110 |
soiltaxonsrc varchar(255), |
|
| 6111 |
percentbedrock double, |
|
| 6112 |
percentrockgravel double, |
|
| 6113 |
percentwood double, |
|
| 6114 |
percentlitter double, |
|
| 6115 |
percentbaresoil double, |
|
| 6116 |
percentwater double, |
|
| 6117 |
percentother double, |
|
| 6118 |
nameother varchar(255), |
|
| 6119 |
treeht double, |
|
| 6120 |
shrubht double, |
|
| 6121 |
fieldht double, |
|
| 6122 |
nonvascularht double, |
|
| 6123 |
submergedht double, |
|
| 6124 |
treecover double, |
|
| 6125 |
shrubcover double, |
|
| 6126 |
fieldcover double, |
|
| 6127 |
nonvascularcover double, |
|
| 6128 |
floatingcover double, |
|
| 6129 |
submergedcover double, |
|
| 6130 |
dominantstratum varchar(255), |
|
| 6131 |
growthform1type varchar(255), |
|
| 6132 |
growthform2type varchar(255), |
|
| 6133 |
growthform3type varchar(255), |
|
| 6134 |
growthform1cover double, |
|
| 6135 |
growthform2cover double, |
|
| 6136 |
growthform3cover double, |
|
| 6137 |
totalcover double, |
|
| 6138 |
notespublic int(1), |
|
| 6139 |
notesmgt int(1), |
|
| 6140 |
revisions int(1), |
|
| 6141 |
dateentered date , |
|
| 6142 |
toptaxon1name varchar(255), |
|
| 6143 |
toptaxon2name varchar(255), |
|
| 6144 |
toptaxon3name varchar(255), |
|
| 6145 |
toptaxon4name varchar(255), |
|
| 6146 |
toptaxon5name varchar(255), |
|
| 6147 |
numberoftaxa int(11) |
|
| 6027 | 6148 |
); |
| 6028 | 6149 |
|
| 6029 | 6150 |
|
| 6030 | 6151 |
-- |
| 6031 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6152 |
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
|
|
| 6032 | 6153 |
-- |
| 6033 | 6154 |
|
| 6034 | 6155 |
|
| 6035 | 6156 |
|
| 6036 | 6157 |
|
| 6037 | 6158 |
-- |
| 6038 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6159 |
-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6039 | 6160 |
-- |
| 6040 | 6161 |
|
| 6041 | 6162 |
|
| 6042 | 6163 |
|
| 6043 | 6164 |
|
| 6044 | 6165 |
-- |
| 6045 |
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6166 |
-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6046 | 6167 |
-- |
| 6047 | 6168 |
|
| 6048 |
CREATE TABLE commdetermination ( |
|
| 6049 |
commdetermination_id int(11) NOT NULL, |
|
| 6050 |
commclass_id int(11) NOT NULL, |
|
| 6051 |
commconcept_id int(11) NOT NULL, |
|
| 6052 |
commcode varchar(255), |
|
| 6053 |
commname varchar(255), |
|
| 6054 |
classfit varchar(255), |
|
| 6055 |
classconfidence varchar(255), |
|
| 6056 |
commauthority_id int(11), |
|
| 6057 |
notes varchar(255), |
|
| 6058 |
type int(1), |
|
| 6059 |
nomenclaturaltype int(1) |
|
| 6060 |
); |
|
| 6061 | 6169 |
|
| 6062 | 6170 |
|
| 6171 |
|
|
| 6063 | 6172 |
-- |
| 6064 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6173 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6065 | 6174 |
-- |
| 6066 | 6175 |
|
| 6176 |
CREATE TABLE method ( |
|
| 6177 |
method_id int(11) NOT NULL, |
|
| 6178 |
source_id int(11) NOT NULL, |
|
| 6179 |
name varchar(255), |
|
| 6180 |
description varchar(255), |
|
| 6181 |
diameterheight_m double, |
|
| 6182 |
mindiameter_m double, |
|
| 6183 |
maxdiameter_m double, |
|
| 6184 |
minheight_m double, |
|
| 6185 |
maxheight_m double, |
|
| 6186 |
observationtype varchar(255), |
|
| 6187 |
observationmeasure varchar(255), |
|
| 6188 |
covermethod_id int(11), |
|
| 6189 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 6190 |
coverbasis varchar(255), |
|
| 6191 |
stemsamplemethod varchar(255), |
|
| 6192 |
shape varchar(255), |
|
| 6193 |
length_m double, |
|
| 6194 |
width_m double, |
|
| 6195 |
radius_m double, |
|
| 6196 |
area_m2 double, |
|
| 6197 |
samplearea_m2 double, |
|
| 6198 |
subplotspacing_m double, |
|
| 6199 |
subplotmethod_id int(11), |
|
| 6200 |
pointsperline int(11) |
|
| 6201 |
); |
|
| 6067 | 6202 |
|
| 6068 | 6203 |
|
| 6069 |
|
|
| 6070 | 6204 |
-- |
| 6071 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6205 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
|
|
| 6072 | 6206 |
-- |
| 6073 | 6207 |
|
| 6074 | 6208 |
|
| 6075 | 6209 |
|
| 6076 | 6210 |
|
| 6077 | 6211 |
-- |
| 6078 |
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6212 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6079 | 6213 |
-- |
| 6080 | 6214 |
|
| 6081 |
CREATE TABLE commlineage ( |
|
| 6082 |
commlineage_id int(11) NOT NULL, |
|
| 6083 |
parentcommstatus_id int(11) NOT NULL, |
|
| 6084 |
childcommstatus_id int(11) NOT NULL |
|
| 6085 |
); |
|
| 6086 | 6215 |
|
| 6087 | 6216 |
|
| 6217 |
|
|
| 6088 | 6218 |
-- |
| 6089 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6219 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
|
|
| 6090 | 6220 |
-- |
| 6091 | 6221 |
|
| 6092 | 6222 |
|
| 6093 | 6223 |
|
| 6094 | 6224 |
|
| 6095 | 6225 |
-- |
| 6096 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6226 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
|
|
| 6097 | 6227 |
-- |
| 6098 | 6228 |
|
| 6099 | 6229 |
|
| 6100 | 6230 |
|
| 6101 | 6231 |
|
| 6102 | 6232 |
-- |
| 6103 |
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6233 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6104 | 6234 |
-- |
| 6105 | 6235 |
|
| 6106 |
CREATE TABLE commname ( |
|
| 6107 |
commname_id int(11) NOT NULL, |
|
| 6108 |
commname varchar(255) NOT NULL, |
|
| 6109 |
source_id int(11), |
|
| 6110 |
dateentered date |
|
| 6111 |
); |
|
| 6112 | 6236 |
|
| 6113 | 6237 |
|
| 6238 |
|
|
| 6114 | 6239 |
-- |
| 6115 |
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6240 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6116 | 6241 |
-- |
| 6117 | 6242 |
|
| 6118 | 6243 |
|
| 6119 | 6244 |
|
| 6120 | 6245 |
|
| 6121 | 6246 |
-- |
| 6122 |
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6247 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6123 | 6248 |
-- |
| 6124 | 6249 |
|
| 6125 | 6250 |
|
| 6126 | 6251 |
|
| 6127 | 6252 |
|
| 6128 | 6253 |
-- |
| 6129 |
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6254 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6130 | 6255 |
-- |
| 6131 | 6256 |
|
| 6132 |
CREATE TABLE commstatus ( |
|
| 6133 |
commstatus_id int(11) NOT NULL, |
|
| 6134 |
commconcept_id int(11) NOT NULL, |
|
| 6135 |
source_id int(11), |
|
| 6136 |
commconceptstatus varchar(255) NOT NULL, |
|
| 6137 |
commparent_id int(11), |
|
| 6138 |
commlevel varchar(255), |
|
| 6139 |
commpartycomments varchar(255), |
|
| 6140 |
party_id int(11) NOT NULL, |
|
| 6141 |
startdate date NOT NULL, |
|
| 6142 |
stopdate date |
|
| 6143 |
); |
|
| 6144 | 6257 |
|
| 6145 | 6258 |
|
| 6259 |
|
|
| 6146 | 6260 |
-- |
| 6147 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6261 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6148 | 6262 |
-- |
| 6149 | 6263 |
|
| 6150 | 6264 |
|
| 6151 | 6265 |
|
| 6152 | 6266 |
|
| 6153 | 6267 |
-- |
| 6154 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6268 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
|
|
| 6155 | 6269 |
-- |
| 6156 | 6270 |
|
| 6157 | 6271 |
|
| 6158 | 6272 |
|
| 6159 | 6273 |
|
| 6160 | 6274 |
-- |
| 6161 |
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6275 |
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
|
|
| 6162 | 6276 |
-- |
| 6163 | 6277 |
|
| 6164 |
CREATE TABLE commusage ( |
|
| 6165 |
commusage_id int(11) NOT NULL, |
|
| 6166 |
commname_id int(11) NOT NULL, |
|
| 6167 |
commname varchar(255), |
|
| 6168 |
commconcept_id int(11), |
|
| 6169 |
commnamestatus varchar(255), |
|
| 6170 |
classsystem varchar(255), |
|
| 6171 |
party_id int(11), |
|
| 6172 |
commstatus_id int(11), |
|
| 6173 |
usagestart date, |
|
| 6174 |
usagestop date |
|
| 6175 |
); |
|
| 6176 | 6278 |
|
| 6177 | 6279 |
|
| 6280 |
|
|
| 6178 | 6281 |
-- |
| 6179 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6282 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 6180 | 6283 |
-- |
| 6181 | 6284 |
|
| 6182 | 6285 |
|
| 6183 | 6286 |
|
| 6184 | 6287 |
|
| 6185 | 6288 |
-- |
| 6186 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6289 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 6187 | 6290 |
-- |
| 6188 | 6291 |
|
| 6189 | 6292 |
|
| 6190 | 6293 |
|
| 6191 | 6294 |
|
| 6192 | 6295 |
-- |
| 6193 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6296 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 6194 | 6297 |
-- |
| 6195 | 6298 |
|
| 6196 |
CREATE TABLE coordinates ( |
|
| 6197 |
coordinates_id int(11) NOT NULL, |
|
| 6198 |
source_id int(11) NOT NULL, |
|
| 6199 |
latitude_deg double NOT NULL, |
|
| 6200 |
longitude_deg double NOT NULL, |
|
| 6201 |
verbatimlatitude varchar(255), |
|
| 6202 |
verbatimlongitude varchar(255), |
|
| 6203 |
verbatimcoordinates varchar(255), |
|
| 6204 |
footprintgeometry_dwc varchar(255), |
|
| 6205 |
coordsaccuracy_m double |
|
| 6206 |
); |
|
| 6207 | 6299 |
|
| 6208 | 6300 |
|
| 6301 |
|
|
| 6209 | 6302 |
-- |
| 6210 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 6303 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 6211 | 6304 |
-- |
| 6212 | 6305 |
|
| 6213 | 6306 |
|
| 6214 | 6307 |
|
| 6215 | 6308 |
|
| 6216 | 6309 |
-- |
| 6217 |
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6310 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 6218 | 6311 |
-- |
| 6219 | 6312 |
|
| 6220 | 6313 |
|
| 6221 | 6314 |
|
| 6222 | 6315 |
|
| 6223 | 6316 |
-- |
| 6224 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6317 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6225 | 6318 |
-- |
| 6226 | 6319 |
|
| 6227 | 6320 |
|
| 6228 | 6321 |
|
| 6229 | 6322 |
|
| 6230 | 6323 |
-- |
| 6231 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6324 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6232 | 6325 |
-- |
| 6233 | 6326 |
|
| 6234 | 6327 |
|
| 6235 | 6328 |
|
| 6236 | 6329 |
|
| 6237 | 6330 |
-- |
| 6238 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6331 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
| 6239 | 6332 |
-- |
| 6240 | 6333 |
|
| 6241 |
CREATE TABLE coverindex ( |
|
| 6242 |
coverindex_id int(11) NOT NULL, |
|
| 6243 |
covermethod_id int(11) NOT NULL, |
|
| 6244 |
covercode varchar(255) NOT NULL, |
|
| 6245 |
upperlimit double, |
|
| 6246 |
lowerlimit double, |
|
| 6247 |
coverpercent double NOT NULL, |
|
| 6248 |
indexdescription varchar(255) |
|
| 6249 |
); |
|
| 6250 | 6334 |
|
| 6251 | 6335 |
|
| 6252 |
-- |
|
| 6253 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 6254 |
-- |
|
| 6255 | 6336 |
|
| 6256 |
|
|
| 6257 |
|
|
| 6258 |
|
|
| 6259 | 6337 |
-- |
| 6260 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6338 |
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6261 | 6339 |
-- |
| 6262 | 6340 |
|
| 6341 |
CREATE TABLE party ( |
|
| 6342 |
party_id int(11) NOT NULL, |
|
| 6343 |
source_id int(11) NOT NULL, |
|
| 6344 |
sourceaccessioncode varchar(255), |
|
| 6345 |
fullname varchar(255), |
|
| 6346 |
salutation varchar(255), |
|
| 6347 |
givenname varchar(255), |
|
| 6348 |
middlename varchar(255), |
|
| 6349 |
surname varchar(255), |
|
| 6350 |
suffix varchar(255), |
|
| 6351 |
department varchar(255), |
|
| 6352 |
organizationname varchar(255), |
|
| 6353 |
currentname_id int(11), |
|
| 6354 |
contactinstructions varchar(255), |
|
| 6355 |
email varchar(255), |
|
| 6356 |
partytype varchar(255), |
|
| 6357 |
partypublic int(1) DEFAULT true |
|
| 6358 |
); |
|
| 6263 | 6359 |
|
| 6264 | 6360 |
|
| 6265 |
|
|
| 6266 | 6361 |
-- |
| 6267 |
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6362 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6268 | 6363 |
-- |
| 6269 | 6364 |
|
| 6270 |
CREATE TABLE covermethod ( |
|
| 6271 |
covermethod_id int(11) NOT NULL, |
|
| 6272 |
source_id int(11), |
|
| 6273 |
covertype varchar(255) NOT NULL, |
|
| 6274 |
coverestimationmethod varchar(255) |
|
| 6365 |
CREATE TABLE plantobservation ( |
|
| 6366 |
plantobservation_id int(11) NOT NULL, |
|
| 6367 |
source_id int(11) NOT NULL, |
|
| 6368 |
sourceaccessioncode varchar(255), |
|
| 6369 |
aggregateoccurrence_id int(11), |
|
| 6370 |
overallheight_m double, |
|
| 6371 |
overallheightaccuracy_m double, |
|
| 6372 |
authorplantcode varchar(255), |
|
| 6373 |
stemcount int(11), |
|
| 6374 |
reproductivecondition varchar(255), |
|
| 6375 |
plant_id int(11) |
|
| 6275 | 6376 |
); |
| 6276 | 6377 |
|
| 6277 | 6378 |
|
| 6278 | 6379 |
-- |
| 6279 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6380 |
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 6280 | 6381 |
-- |
| 6281 | 6382 |
|
| 6282 | 6383 |
|
| 6283 | 6384 |
|
| 6284 | 6385 |
|
| 6285 | 6386 |
-- |
| 6286 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6387 |
-- Name: COLUMN plantobservation.authorplantcode; Type: COMMENT; Schema: public; Owner: -
|
|
| 6287 | 6388 |
-- |
| 6288 | 6389 |
|
| 6289 | 6390 |
|
| 6290 | 6391 |
|
| 6291 | 6392 |
|
| 6292 | 6393 |
-- |
| 6293 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6394 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6294 | 6395 |
-- |
| 6295 | 6396 |
|
| 6296 |
CREATE TABLE cultivated_family_locations ( |
|
| 6297 |
family varchar(255) NOT NULL, |
|
| 6298 |
country varchar(255) NOT NULL |
|
| 6397 |
CREATE TABLE project ( |
|
| 6398 |
project_id int(11) NOT NULL, |
|
| 6399 |
source_id int(11) NOT NULL, |
|
| 6400 |
sourceaccessioncode varchar(255), |
|
| 6401 |
projectname varchar(255), |
|
| 6402 |
projectdescription varchar(255), |
|
| 6403 |
startdate date, |
|
| 6404 |
stopdate date |
|
| 6299 | 6405 |
); |
| 6300 | 6406 |
|
| 6301 | 6407 |
|
| 6302 | 6408 |
-- |
| 6303 |
-- Name: TABLE cultivated_family_locations; Type: COMMENT; Schema: public; Owner: -
|
|
| 6409 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6304 | 6410 |
-- |
| 6305 | 6411 |
|
| 6412 |
CREATE TABLE stratum ( |
|
| 6413 |
stratum_id int(11) NOT NULL, |
|
| 6414 |
source_id int(11) NOT NULL, |
|
| 6415 |
stratumname varchar(255) NOT NULL, |
|
| 6416 |
stratumheight double, |
|
| 6417 |
stratumbase double, |
|
| 6418 |
stratumcover double, |
|
| 6419 |
area double, |
|
| 6420 |
method_id int(11) |
|
| 6421 |
); |
|
| 6306 | 6422 |
|
| 6307 | 6423 |
|
| 6308 |
|
|
| 6309 | 6424 |
-- |
| 6310 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6425 |
-- Name: plot.**; Type: VIEW; Schema: public; Owner: -
|
|
| 6311 | 6426 |
-- |
| 6312 | 6427 |
|
| 6313 | 6428 |
|
| 6314 | 6429 |
|
| 6315 | 6430 |
|
| 6316 | 6431 |
-- |
| 6317 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6432 |
-- Name: COLUMN `plot.**`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6318 | 6433 |
-- |
| 6319 | 6434 |
|
| 6320 |
CREATE TABLE definedvalue ( |
|
| 6321 |
definedvalue_id int(11) NOT NULL, |
|
| 6322 |
userdefined_id int(11) NOT NULL, |
|
| 6323 |
tablerecord_id int(11) NOT NULL, |
|
| 6324 |
definedvalue varchar(255) |
|
| 6325 |
); |
|
| 6326 | 6435 |
|
| 6327 | 6436 |
|
| 6437 |
|
|
| 6328 | 6438 |
-- |
| 6329 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6439 |
-- Name: COLUMN `plot.**`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6330 | 6440 |
-- |
| 6331 | 6441 |
|
| 6332 | 6442 |
|
| 6333 | 6443 |
|
| 6334 | 6444 |
|
| 6335 | 6445 |
-- |
| 6336 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6446 |
-- Name: COLUMN `plot.**`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6337 | 6447 |
-- |
| 6338 | 6448 |
|
| 6339 | 6449 |
|
| 6340 | 6450 |
|
| 6341 | 6451 |
|
| 6342 | 6452 |
-- |
| 6343 |
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6453 |
-- Name: COLUMN `plot.**`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6344 | 6454 |
-- |
| 6345 | 6455 |
|
| 6346 |
CREATE TABLE disturbanceobs ( |
|
| 6347 |
disturbanceobs_id int(11) NOT NULL, |
|
| 6348 |
locationevent_id int(11) NOT NULL, |
|
| 6349 |
disturbancetype varchar(255) NOT NULL, |
|
| 6350 |
disturbanceintensity varchar(255), |
|
| 6351 |
disturbanceage double, |
|
| 6352 |
disturbanceextent double, |
|
| 6353 |
disturbancecomment varchar(255) |
|
| 6354 |
); |
|
| 6355 | 6456 |
|
| 6356 | 6457 |
|
| 6458 |
|
|
| 6357 | 6459 |
-- |
| 6358 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6460 |
-- Name: COLUMN `plot.**`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6359 | 6461 |
-- |
| 6360 | 6462 |
|
| 6361 | 6463 |
|
| 6362 | 6464 |
|
| 6363 | 6465 |
|
| 6364 | 6466 |
-- |
| 6365 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6467 |
-- Name: COLUMN `plot.**`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6366 | 6468 |
-- |
| 6367 | 6469 |
|
| 6368 | 6470 |
|
| 6369 | 6471 |
|
| 6370 | 6472 |
|
| 6371 | 6473 |
-- |
| 6372 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6474 |
-- Name: COLUMN `plot.**`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6373 | 6475 |
-- |
| 6374 | 6476 |
|
| 6375 |
CREATE TABLE family_higher_plant_group ( |
|
| 6376 |
family varchar(255) NOT NULL, |
|
| 6377 |
higher_plant_group varchar(255) |
|
| 6378 |
); |
|
| 6379 | 6477 |
|
| 6380 | 6478 |
|
| 6479 |
|
|
| 6381 | 6480 |
-- |
| 6382 |
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6481 |
-- Name: COLUMN `plot.**`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6383 | 6482 |
-- |
| 6384 | 6483 |
|
| 6385 |
CREATE TABLE geoscrub_input ( |
|
| 6386 |
country varchar(255), |
|
| 6387 |
`stateProvince` varchar(255), |
|
| 6388 |
county varchar(255), |
|
| 6389 |
`decimalLatitude` double, |
|
| 6390 |
`decimalLongitude` double |
|
| 6391 |
); |
|
| 6392 | 6484 |
|
| 6393 | 6485 |
|
| 6486 |
|
|
| 6394 | 6487 |
-- |
| 6395 |
-- Name: geoscrub_input_new; Type: VIEW; Schema: public; Owner: -
|
|
| 6488 |
-- Name: COLUMN `plot.**`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6396 | 6489 |
-- |
| 6397 | 6490 |
|
| 6398 | 6491 |
|
| 6399 | 6492 |
|
| 6400 | 6493 |
|
| 6401 | 6494 |
-- |
| 6402 |
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -
|
|
| 6495 |
-- Name: COLUMN `plot.**`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6403 | 6496 |
-- |
| 6404 | 6497 |
|
| 6405 | 6498 |
|
| 6406 | 6499 |
|
| 6407 | 6500 |
|
| 6408 | 6501 |
-- |
| 6409 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6502 |
-- Name: COLUMN `plot.**`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 6410 | 6503 |
-- |
| 6411 | 6504 |
|
| 6412 |
CREATE TABLE graphic ( |
|
| 6413 |
graphic_id int(11) NOT NULL, |
|
| 6414 |
locationevent_id int(11) NOT NULL, |
|
| 6415 |
graphicname varchar(255), |
|
| 6416 |
graphiclocation varchar(255), |
|
| 6417 |
graphicdescription varchar(255), |
|
| 6418 |
graphictype varchar(255), |
|
| 6419 |
graphicdata int(11), |
|
| 6420 |
graphicdate date |
|
| 6421 |
); |
|
| 6422 | 6505 |
|
| 6423 | 6506 |
|
| 6507 |
|
|
| 6424 | 6508 |
-- |
| 6425 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6509 |
-- Name: COLUMN `plot.**`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6426 | 6510 |
-- |
| 6427 | 6511 |
|
| 6428 | 6512 |
|
| 6429 | 6513 |
|
| 6430 | 6514 |
|
| 6431 | 6515 |
-- |
| 6432 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6516 |
-- Name: COLUMN `plot.**`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6433 | 6517 |
-- |
| 6434 | 6518 |
|
| 6435 | 6519 |
|
| 6436 | 6520 |
|
| 6437 | 6521 |
|
| 6438 | 6522 |
-- |
| 6439 |
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6523 |
-- Name: COLUMN `plot.**`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6440 | 6524 |
-- |
| 6441 | 6525 |
|
| 6442 |
CREATE TABLE higher_plant_group_nodes ( |
|
| 6443 |
higher_plant_group varchar(255), |
|
| 6444 |
node_name varchar(255) NOT NULL |
|
| 6445 |
); |
|
| 6446 | 6526 |
|
| 6447 | 6527 |
|
| 6528 |
|
|
| 6448 | 6529 |
-- |
| 6449 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: -
|
|
| 6530 |
-- Name: COLUMN `plot.**`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6450 | 6531 |
-- |
| 6451 | 6532 |
|
| 6452 | 6533 |
|
| 6453 | 6534 |
|
| 6454 | 6535 |
|
| 6455 | 6536 |
-- |
| 6456 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 6537 |
-- Name: COLUMN `plot.**`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6457 | 6538 |
-- |
| 6458 | 6539 |
|
| 6459 | 6540 |
|
| 6460 | 6541 |
|
| 6461 | 6542 |
|
| 6462 | 6543 |
-- |
| 6463 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6544 |
-- Name: COLUMN `plot.**`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6464 | 6545 |
-- |
| 6465 | 6546 |
|
| 6466 |
CREATE TABLE location ( |
|
| 6467 |
location_id int(11) NOT NULL, |
|
| 6468 |
source_id int(11) NOT NULL, |
|
| 6469 |
sourceaccessioncode varchar(255), |
|
| 6470 |
plot_location_id int(11) NOT NULL, |
|
| 6471 |
parent_id int(11), |
|
| 6472 |
authorlocationcode varchar(255), |
|
| 6473 |
place_id int(11), |
|
| 6474 |
accesslevel varchar(255), |
|
| 6475 |
accessconditions varchar(255), |
|
| 6476 |
sublocationxposition_m double, |
|
| 6477 |
sublocationyposition_m double, |
|
| 6478 |
iscultivated int(1), |
|
| 6479 |
authorzone varchar(255), |
|
| 6480 |
authordatum varchar(255), |
|
| 6481 |
authorlocation varchar(255), |
|
| 6482 |
locationnarrative varchar(255), |
|
| 6483 |
azimuth double, |
|
| 6484 |
shape varchar(255), |
|
| 6485 |
area_m2 double, |
|
| 6486 |
standsize varchar(255), |
|
| 6487 |
placementmethod varchar(255), |
|
| 6488 |
permanence int(1), |
|
| 6489 |
layoutnarrative varchar(255), |
|
| 6490 |
elevation_m double, |
|
| 6491 |
elevationaccuracy_m double, |
|
| 6492 |
elevationrange_m double, |
|
| 6493 |
verbatimelevation varchar(255), |
|
| 6494 |
slopeaspect_deg double, |
|
| 6495 |
minslopeaspect_deg double, |
|
| 6496 |
maxslopeaspect_deg double, |
|
| 6497 |
slopegradient_fraction double, |
|
| 6498 |
minslopegradient_fraction double, |
|
| 6499 |
maxslopegradient_fraction double, |
|
| 6500 |
topoposition varchar(255), |
|
| 6501 |
landform varchar(255), |
|
| 6502 |
surficialdeposits varchar(255), |
|
| 6503 |
rocktype varchar(255), |
|
| 6504 |
submitter_surname varchar(255), |
|
| 6505 |
submitter_givenname varchar(255), |
|
| 6506 |
submitter_email varchar(255), |
|
| 6507 |
notespublic int(1), |
|
| 6508 |
notesmgt int(1), |
|
| 6509 |
revisions int(1), |
|
| 6510 |
dateentered date , |
|
| 6511 |
locationrationalenarrative varchar(255) |
|
| 6512 |
); |
|
| 6513 | 6547 |
|
| 6514 | 6548 |
|
| 6549 |
|
|
| 6515 | 6550 |
-- |
| 6516 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
|
|
| 6551 |
-- Name: COLUMN `plot.**`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 6517 | 6552 |
-- |
| 6518 | 6553 |
|
| 6519 | 6554 |
|
| 6520 | 6555 |
|
| 6521 | 6556 |
|
| 6522 | 6557 |
-- |
| 6523 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6558 |
-- Name: COLUMN `plot.**`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6524 | 6559 |
-- |
| 6525 | 6560 |
|
| 6526 | 6561 |
|
| 6527 | 6562 |
|
| 6528 | 6563 |
|
| 6529 | 6564 |
-- |
| 6530 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6565 |
-- Name: COLUMN `plot.**`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6531 | 6566 |
-- |
| 6532 | 6567 |
|
| 6533 | 6568 |
|
| 6534 | 6569 |
|
| 6535 | 6570 |
|
| 6536 | 6571 |
-- |
| 6537 |
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6572 |
-- Name: COLUMN `plot.**`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6538 | 6573 |
-- |
| 6539 | 6574 |
|
| 6540 | 6575 |
|
| 6541 | 6576 |
|
| 6542 | 6577 |
|
| 6543 | 6578 |
-- |
| 6544 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6579 |
-- Name: COLUMN `plot.**`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6545 | 6580 |
-- |
| 6546 | 6581 |
|
| 6547 |
CREATE TABLE locationevent ( |
|
| 6548 |
locationevent_id int(11) NOT NULL, |
|
| 6549 |
source_id int(11) NOT NULL, |
|
| 6550 |
sourceaccessioncode varchar(255), |
|
| 6551 |
accesslevel varchar(255), |
|
| 6552 |
place_visit_id int(11) NOT NULL, |
|
| 6553 |
parent_id int(11), |
|
| 6554 |
plot_id int(11), |
|
| 6555 |
location_id int(11), |
|
| 6556 |
project_id int(11), |
|
| 6557 |
stratum_id int(11), |
|
| 6558 |
authoreventcode varchar(255), |
|
| 6559 |
previous_id int(11), |
|
| 6560 |
obsstartdate date, |
|
| 6561 |
obsenddate date, |
|
| 6562 |
dateaccuracy varchar(255), |
|
| 6563 |
method_id int(11), |
|
| 6564 |
temperature_c double, |
|
| 6565 |
precipitation_m double, |
|
| 6566 |
autotaxoncover int(1), |
|
| 6567 |
originaldata varchar(255), |
|
| 6568 |
effortlevel varchar(255), |
|
| 6569 |
floristicquality varchar(255), |
|
| 6570 |
bryophytequality varchar(255), |
|
| 6571 |
lichenquality varchar(255), |
|
| 6572 |
locationeventnarrative varchar(255), |
|
| 6573 |
landscapenarrative varchar(255), |
|
| 6574 |
homogeneity varchar(255), |
|
| 6575 |
phenologicaspect varchar(255), |
|
| 6576 |
representativeness varchar(255), |
|
| 6577 |
standmaturity varchar(255), |
|
| 6578 |
successionalstatus varchar(255), |
|
| 6579 |
basalarea double, |
|
| 6580 |
hydrologicregime varchar(255), |
|
| 6581 |
soilmoistureregime varchar(255), |
|
| 6582 |
soildrainage varchar(255), |
|
| 6583 |
watersalinity varchar(255), |
|
| 6584 |
waterdepth_m double, |
|
| 6585 |
shoredistance double, |
|
| 6586 |
soildepth double, |
|
| 6587 |
organicdepth double, |
|
| 6588 |
soiltaxon_id int(11), |
|
| 6589 |
soiltaxonsrc varchar(255), |
|
| 6590 |
percentbedrock double, |
|
| 6591 |
percentrockgravel double, |
|
| 6592 |
percentwood double, |
|
| 6593 |
percentlitter double, |
|
| 6594 |
percentbaresoil double, |
|
| 6595 |
percentwater double, |
|
| 6596 |
percentother double, |
|
| 6597 |
nameother varchar(255), |
|
| 6598 |
treeht double, |
|
| 6599 |
shrubht double, |
|
| 6600 |
fieldht double, |
|
| 6601 |
nonvascularht double, |
|
| 6602 |
submergedht double, |
|
| 6603 |
treecover double, |
|
| 6604 |
shrubcover double, |
|
| 6605 |
fieldcover double, |
|
| 6606 |
nonvascularcover double, |
|
| 6607 |
floatingcover double, |
|
| 6608 |
submergedcover double, |
|
| 6609 |
dominantstratum varchar(255), |
|
| 6610 |
growthform1type varchar(255), |
|
| 6611 |
growthform2type varchar(255), |
|
| 6612 |
growthform3type varchar(255), |
|
| 6613 |
growthform1cover double, |
|
| 6614 |
growthform2cover double, |
|
| 6615 |
growthform3cover double, |
|
| 6616 |
totalcover double, |
|
| 6617 |
notespublic int(1), |
|
| 6618 |
notesmgt int(1), |
|
| 6619 |
revisions int(1), |
|
| 6620 |
dateentered date , |
|
| 6621 |
toptaxon1name varchar(255), |
|
| 6622 |
toptaxon2name varchar(255), |
|
| 6623 |
toptaxon3name varchar(255), |
|
| 6624 |
toptaxon4name varchar(255), |
|
| 6625 |
toptaxon5name varchar(255), |
|
| 6626 |
numberoftaxa int(11) |
|
| 6627 |
); |
|
| 6628 | 6582 |
|
| 6629 | 6583 |
|
| 6584 |
|
|
| 6630 | 6585 |
-- |
| 6631 |
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
|
|
| 6586 |
-- Name: COLUMN `plot.**`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6632 | 6587 |
-- |
| 6633 | 6588 |
|
| 6634 | 6589 |
|
| 6635 | 6590 |
|
| 6636 | 6591 |
|
| 6637 | 6592 |
-- |
| 6638 |
-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6593 |
-- Name: COLUMN `plot.**`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6639 | 6594 |
-- |
| 6640 | 6595 |
|
| 6641 | 6596 |
|
| 6642 | 6597 |
|
| 6643 | 6598 |
|
| 6644 | 6599 |
-- |
| 6645 |
-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6600 |
-- Name: COLUMN `plot.**`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6646 | 6601 |
-- |
| 6647 | 6602 |
|
| 6648 | 6603 |
|
| 6649 | 6604 |
|
| 6650 | 6605 |
|
| 6651 | 6606 |
-- |
| 6652 |
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6607 |
-- Name: COLUMN `plot.**`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6653 | 6608 |
-- |
| 6654 | 6609 |
|
| 6655 | 6610 |
|
| 6656 | 6611 |
|
| 6657 | 6612 |
|
| 6658 | 6613 |
-- |
| 6659 |
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6614 |
-- Name: COLUMN `plot.**`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6660 | 6615 |
-- |
| 6661 | 6616 |
|
| 6662 | 6617 |
|
| 6663 | 6618 |
|
| 6664 | 6619 |
|
| 6665 | 6620 |
-- |
| 6666 |
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6621 |
-- Name: COLUMN `plot.**`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6667 | 6622 |
-- |
| 6668 | 6623 |
|
| 6669 |
CREATE TABLE locationeventcontributor ( |
|
| 6670 |
locationeventcontributor_id int(11) NOT NULL, |
|
| 6671 |
locationevent_id int(11) NOT NULL, |
|
| 6672 |
party_id int(11) NOT NULL, |
|
| 6673 |
role varchar(255), |
|
| 6674 |
contributiondate date |
|
| 6675 |
); |
|
| 6676 | 6624 |
|
| 6677 | 6625 |
|
| 6626 |
|
|
| 6678 | 6627 |
-- |
| 6679 |
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6628 |
-- Name: COLUMN `plot.**`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6680 | 6629 |
-- |
| 6681 | 6630 |
|
| 6682 | 6631 |
|
| 6683 | 6632 |
|
| 6684 | 6633 |
|
| 6685 | 6634 |
-- |
| 6686 |
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6635 |
-- Name: COLUMN `plot.**`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6687 | 6636 |
-- |
| 6688 | 6637 |
|
| 6689 | 6638 |
|
| 6690 | 6639 |
|
| 6691 | 6640 |
|
| 6692 | 6641 |
-- |
| 6693 |
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6642 |
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6694 | 6643 |
-- |
| 6695 | 6644 |
|
| 6696 |
CREATE TABLE locationeventsynonym ( |
|
| 6697 |
locationeventsynonym_id int(11) NOT NULL, |
|
| 6698 |
synonymlocationevent_id int(11) NOT NULL, |
|
| 6699 |
primarylocationevent_id int(11) NOT NULL, |
|
| 6700 |
party_id int(11) NOT NULL, |
|
| 6701 |
role varchar(255) NOT NULL, |
|
| 6702 |
synonymcomment varchar(255), |
|
| 6703 |
classstartdate date NOT NULL, |
|
| 6704 |
classstopdate date |
|
| 6645 |
CREATE TABLE sourcelist ( |
|
| 6646 |
sourcelist_id int(11) NOT NULL, |
|
| 6647 |
source_id int(11) NOT NULL, |
|
| 6648 |
name varchar(255) NOT NULL |
|
| 6705 | 6649 |
); |
| 6706 | 6650 |
|
| 6707 | 6651 |
|
| 6708 | 6652 |
-- |
| 6709 |
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6653 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6710 | 6654 |
-- |
| 6711 | 6655 |
|
| 6656 |
CREATE TABLE specimenreplicate ( |
|
| 6657 |
specimenreplicate_id int(11) NOT NULL, |
|
| 6658 |
source_id int(11) NOT NULL, |
|
| 6659 |
sourceaccessioncode varchar(255), |
|
| 6660 |
plantobservation_id int(11), |
|
| 6661 |
duplicate_institutions_sourcelist_id int(11), |
|
| 6662 |
collectioncode_dwc varchar(255), |
|
| 6663 |
catalognumber_dwc varchar(255), |
|
| 6664 |
collectionnumber varchar(255), |
|
| 6665 |
description varchar(255), |
|
| 6666 |
specimen_id int(11) |
|
| 6667 |
); |
|
| 6712 | 6668 |
|
| 6713 | 6669 |
|
| 6714 |
|
|
| 6715 | 6670 |
-- |
| 6716 |
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6671 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
|
|
| 6717 | 6672 |
-- |
| 6718 | 6673 |
|
| 6719 | 6674 |
|
| 6720 | 6675 |
|
| 6721 | 6676 |
|
| 6722 | 6677 |
-- |
| 6723 |
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6678 |
-- Name: COLUMN specimenreplicate.duplicate_institutions_sourcelist_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6724 | 6679 |
-- |
| 6725 | 6680 |
|
| 6726 |
CREATE TABLE locationplace ( |
|
| 6727 |
locationplace_id int(11) NOT NULL, |
|
| 6728 |
location_id int(11) NOT NULL, |
|
| 6729 |
place_id int(11) NOT NULL, |
|
| 6730 |
identifier_id int(11) |
|
| 6731 |
); |
|
| 6732 | 6681 |
|
| 6733 | 6682 |
|
| 6683 |
|
|
| 6734 | 6684 |
-- |
| 6735 |
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
|
|
| 6685 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 6736 | 6686 |
-- |
| 6737 | 6687 |
|
| 6738 | 6688 |
|
| 6739 | 6689 |
|
| 6740 | 6690 |
|
| 6741 | 6691 |
-- |
| 6742 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6692 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6743 | 6693 |
-- |
| 6744 | 6694 |
|
| 6695 |
CREATE TABLE taxondetermination ( |
|
| 6696 |
taxondetermination_id int(11) NOT NULL, |
|
| 6697 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 6698 |
source_id int(11) NOT NULL, |
|
| 6699 |
taxonverbatim_id int(11) NOT NULL, |
|
| 6700 |
party_id int(11), |
|
| 6701 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
|
| 6702 |
determinationtype varchar(255), |
|
| 6703 |
reference_id int(11), |
|
| 6704 |
isoriginal int(1), |
|
| 6705 |
iscurrent__verbatim int(1), |
|
| 6706 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 6707 |
taxonfit varchar(255), |
|
| 6708 |
taxonconfidence varchar(255), |
|
| 6709 |
grouptype varchar(255), |
|
| 6710 |
notes varchar(255), |
|
| 6711 |
revisions int(1), |
|
| 6712 |
determinationdate date |
|
| 6713 |
); |
|
| 6745 | 6714 |
|
| 6746 | 6715 |
|
| 6747 |
|
|
| 6748 | 6716 |
-- |
| 6749 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6717 |
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
|
|
| 6750 | 6718 |
-- |
| 6751 | 6719 |
|
| 6752 | 6720 |
|
| 6753 | 6721 |
|
| 6754 | 6722 |
|
| 6755 | 6723 |
-- |
| 6756 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6724 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6757 | 6725 |
-- |
| 6758 | 6726 |
|
| 6759 |
CREATE TABLE method (
|
|
| 6760 |
method_id int(11) NOT NULL,
|
|
| 6727 |
CREATE TABLE taxonoccurrence (
|
|
| 6728 |
taxonoccurrence_id int(11) NOT NULL,
|
|
| 6761 | 6729 |
source_id int(11) NOT NULL, |
| 6762 |
name varchar(255), |
|
| 6763 |
description varchar(255), |
|
| 6764 |
diameterheight_m double, |
|
| 6765 |
mindiameter_m double, |
|
| 6766 |
maxdiameter_m double, |
|
| 6767 |
minheight_m double, |
|
| 6768 |
maxheight_m double, |
|
| 6769 |
observationtype varchar(255), |
|
| 6770 |
observationmeasure varchar(255), |
|
| 6771 |
covermethod_id int(11), |
|
| 6772 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 6773 |
coverbasis varchar(255), |
|
| 6774 |
stemsamplemethod varchar(255), |
|
| 6775 |
shape varchar(255), |
|
| 6776 |
length_m double, |
|
| 6777 |
width_m double, |
|
| 6778 |
radius_m double, |
|
| 6779 |
area_m2 double, |
|
| 6780 |
samplearea_m2 double, |
|
| 6781 |
subplotspacing_m double, |
|
| 6782 |
subplotmethod_id int(11), |
|
| 6783 |
pointsperline int(11) |
|
| 6730 |
sourceaccessioncode varchar(255), |
|
| 6731 |
locationevent_id int(11), |
|
| 6732 |
authortaxoncode varchar(255), |
|
| 6733 |
collector_id int(11), |
|
| 6734 |
growthform varchar(255), |
|
| 6735 |
iscultivated int(1), |
|
| 6736 |
cultivatedbasis varchar(255), |
|
| 6737 |
isnative int(1) |
|
| 6784 | 6738 |
); |
| 6785 | 6739 |
|
| 6786 | 6740 |
|
| 6787 | 6741 |
-- |
| 6788 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
|
|
| 6742 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
|
|
| 6789 | 6743 |
-- |
| 6790 | 6744 |
|
| 6791 | 6745 |
|
| 6792 | 6746 |
|
| 6793 | 6747 |
|
| 6794 | 6748 |
-- |
| 6795 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6749 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
|
|
| 6796 | 6750 |
-- |
| 6797 | 6751 |
|
| 6798 | 6752 |
|
| 6799 | 6753 |
|
| 6800 | 6754 |
|
| 6801 | 6755 |
-- |
| 6802 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
|
|
| 6756 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 6803 | 6757 |
-- |
| 6804 | 6758 |
|
| 6805 | 6759 |
|
| 6806 | 6760 |
|
| 6807 | 6761 |
|
| 6808 | 6762 |
-- |
| 6809 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
|
|
| 6763 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
|
|
| 6810 | 6764 |
-- |
| 6811 | 6765 |
|
| 6812 | 6766 |
|
| 6813 | 6767 |
|
| 6814 | 6768 |
|
| 6815 | 6769 |
-- |
| 6816 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6770 |
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6817 | 6771 |
-- |
| 6818 | 6772 |
|
| 6773 |
CREATE TABLE taxonverbatim ( |
|
| 6774 |
taxonverbatim_id int(11) NOT NULL, |
|
| 6775 |
source_id int(11) NOT NULL, |
|
| 6776 |
taxonlabel_id int(11), |
|
| 6777 |
verbatimrank varchar(255), |
|
| 6778 |
taxonomicname varchar(255), |
|
| 6779 |
taxonname varchar(255), |
|
| 6780 |
author varchar(255), |
|
| 6781 |
family varchar(255), |
|
| 6782 |
genus varchar(255), |
|
| 6783 |
specific_epithet varchar(255), |
|
| 6784 |
subspecies varchar(255), |
|
| 6785 |
morphospecies varchar(255), |
|
| 6786 |
morphoname varchar(255), |
|
| 6787 |
growthform varchar(255), |
|
| 6788 |
description varchar(255) |
|
| 6789 |
); |
|
| 6819 | 6790 |
|
| 6820 | 6791 |
|
| 6821 |
|
|
| 6822 | 6792 |
-- |
| 6823 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6793 |
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 6824 | 6794 |
-- |
| 6825 | 6795 |
|
| 6826 | 6796 |
|
| 6827 | 6797 |
|
| 6828 | 6798 |
|
| 6829 | 6799 |
-- |
| 6830 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6800 |
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
|
|
| 6831 | 6801 |
-- |
| 6832 | 6802 |
|
| 6833 | 6803 |
|
| 6834 | 6804 |
|
| 6835 | 6805 |
|
| 6836 | 6806 |
-- |
| 6837 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6807 |
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 6838 | 6808 |
-- |
| 6839 | 6809 |
|
| 6840 | 6810 |
|
| 6841 | 6811 |
|
| 6842 | 6812 |
|
| 6843 | 6813 |
-- |
| 6844 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6814 |
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
|
|
| 6845 | 6815 |
-- |
| 6846 | 6816 |
|
| 6847 | 6817 |
|
| 6848 | 6818 |
|
| 6849 | 6819 |
|
| 6850 | 6820 |
-- |
| 6851 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
|
|
| 6821 |
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
|
|
| 6852 | 6822 |
-- |
| 6853 | 6823 |
|
| 6854 | 6824 |
|
| 6855 | 6825 |
|
| 6856 | 6826 |
|
| 6857 | 6827 |
-- |
| 6858 |
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
|
|
| 6828 |
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
|
|
| 6859 | 6829 |
-- |
| 6860 | 6830 |
|
| 6861 | 6831 |
|
| 6862 | 6832 |
|
| 6863 | 6833 |
|
| 6864 | 6834 |
-- |
| 6865 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 6835 |
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 6866 | 6836 |
-- |
| 6867 | 6837 |
|
| 6868 | 6838 |
|
| 6869 | 6839 |
|
| 6870 | 6840 |
|
| 6871 | 6841 |
-- |
| 6872 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 6842 |
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 6873 | 6843 |
-- |
| 6874 | 6844 |
|
| 6875 | 6845 |
|
| 6876 | 6846 |
|
| 6877 | 6847 |
|
| 6878 | 6848 |
-- |
| 6879 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 6849 |
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
|
|
| 6880 | 6850 |
-- |
| 6881 | 6851 |
|
| 6882 | 6852 |
|
| 6883 | 6853 |
|
| 6884 | 6854 |
|
| 6885 | 6855 |
-- |
| 6886 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 6856 |
-- Name: viewFullOccurrence_individual_view; Type: VIEW; Schema: public; Owner: -
|
|
| 6887 | 6857 |
-- |
| 6888 | 6858 |
|
| 6889 | 6859 |
|
| 6890 | 6860 |
|
| 6891 | 6861 |
|
| 6892 | 6862 |
-- |
| 6893 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 6863 |
-- Name: VIEW `viewFullOccurrence_individual_view`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6894 | 6864 |
-- |
| 6895 | 6865 |
|
| 6896 | 6866 |
|
| 6897 | 6867 |
|
| 6898 | 6868 |
|
| 6899 | 6869 |
-- |
| 6900 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6870 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6901 | 6871 |
-- |
| 6902 | 6872 |
|
| 6903 | 6873 |
|
| 6904 | 6874 |
|
| 6905 | 6875 |
|
| 6906 | 6876 |
-- |
| 6907 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6877 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6908 | 6878 |
-- |
| 6909 | 6879 |
|
| 6910 | 6880 |
|
| 6911 | 6881 |
|
| 6912 | 6882 |
|
| 6913 | 6883 |
-- |
| 6914 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
| 6884 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6915 | 6885 |
-- |
| 6916 | 6886 |
|
| 6917 | 6887 |
|
| 6918 | 6888 |
|
| 6919 | 6889 |
|
| 6920 | 6890 |
-- |
| 6921 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6891 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6922 | 6892 |
-- |
| 6923 | 6893 |
|
| 6924 | 6894 |
|
| 6925 | 6895 |
|
| 6926 | 6896 |
|
| 6927 | 6897 |
-- |
| 6928 |
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6898 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6929 | 6899 |
-- |
| 6930 | 6900 |
|
| 6931 | 6901 |
|
| 6932 | 6902 |
|
| 6933 | 6903 |
|
| 6934 | 6904 |
-- |
| 6935 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6905 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6936 | 6906 |
-- |
| 6937 | 6907 |
|
| 6938 |
CREATE TABLE methodtaxonclass ( |
|
| 6939 |
methodtaxonclass_id int(11) NOT NULL, |
|
| 6940 |
method_id int(11) NOT NULL, |
|
| 6941 |
taxonlabel_id int(11), |
|
| 6942 |
included int(1) NOT NULL, |
|
| 6943 |
submethod_id int(11), |
|
| 6944 |
taxonclass varchar(255) |
|
| 6945 |
); |
|
| 6946 | 6908 |
|
| 6947 | 6909 |
|
| 6910 |
|
|
| 6948 | 6911 |
-- |
| 6949 |
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
|
|
| 6912 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6950 | 6913 |
-- |
| 6951 | 6914 |
|
| 6952 | 6915 |
|
| 6953 | 6916 |
|
| 6954 | 6917 |
|
| 6955 | 6918 |
-- |
| 6956 |
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6919 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6957 | 6920 |
-- |
| 6958 | 6921 |
|
| 6959 | 6922 |
|
| 6960 | 6923 |
|
| 6961 | 6924 |
|
Also available in: Unified diff
schemas/public_.sql: other derived views: use viewFullOccurrence_individual instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)