| 1124 |
1124 |
taxonomicname text,
|
| 1125 |
1125 |
author text,
|
| 1126 |
1126 |
taxonomicnamewithauthor text,
|
| 1127 |
|
domain text,
|
| 1128 |
|
kingdom text,
|
| 1129 |
|
phylum text,
|
| 1130 |
|
class text,
|
| 1131 |
|
"order" text,
|
| 1132 |
1127 |
family text,
|
| 1133 |
1128 |
genus text,
|
| 1134 |
1129 |
species text,
|
| 1135 |
|
subspecies text,
|
| 1136 |
|
variety text,
|
| 1137 |
|
forma text,
|
| 1138 |
|
cultivar text,
|
| 1139 |
1130 |
description text,
|
| 1140 |
1131 |
accessioncode text,
|
| 1141 |
1132 |
CONSTRAINT taxonconcept_required_key CHECK ((((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)) OR ((parent_id IS NOT NULL) AND (author IS NOT NULL))))
|
| ... | ... | |
| 1239 |
1230 |
|
| 1240 |
1231 |
|
| 1241 |
1232 |
--
|
| 1242 |
|
-- Name: COLUMN taxonconcept.domain; Type: COMMENT; Schema: public; Owner: -
|
| 1243 |
|
--
|
| 1244 |
|
|
| 1245 |
|
COMMENT ON COLUMN taxonconcept.domain IS 'The domain portion of the taxonomic name.';
|
| 1246 |
|
|
| 1247 |
|
|
| 1248 |
|
--
|
| 1249 |
|
-- Name: COLUMN taxonconcept.kingdom; Type: COMMENT; Schema: public; Owner: -
|
| 1250 |
|
--
|
| 1251 |
|
|
| 1252 |
|
COMMENT ON COLUMN taxonconcept.kingdom IS 'The kingdom portion of the taxonomic name.';
|
| 1253 |
|
|
| 1254 |
|
|
| 1255 |
|
--
|
| 1256 |
|
-- Name: COLUMN taxonconcept.phylum; Type: COMMENT; Schema: public; Owner: -
|
| 1257 |
|
--
|
| 1258 |
|
|
| 1259 |
|
COMMENT ON COLUMN taxonconcept.phylum IS 'The phylum portion of the taxonomic name.';
|
| 1260 |
|
|
| 1261 |
|
|
| 1262 |
|
--
|
| 1263 |
|
-- Name: COLUMN taxonconcept.class; Type: COMMENT; Schema: public; Owner: -
|
| 1264 |
|
--
|
| 1265 |
|
|
| 1266 |
|
COMMENT ON COLUMN taxonconcept.class IS 'The class portion of the taxonomic name.';
|
| 1267 |
|
|
| 1268 |
|
|
| 1269 |
|
--
|
| 1270 |
|
-- Name: COLUMN taxonconcept."order"; Type: COMMENT; Schema: public; Owner: -
|
| 1271 |
|
--
|
| 1272 |
|
|
| 1273 |
|
COMMENT ON COLUMN taxonconcept."order" IS 'The order portion of the taxonomic name.';
|
| 1274 |
|
|
| 1275 |
|
|
| 1276 |
|
--
|
| 1277 |
1233 |
-- Name: COLUMN taxonconcept.family; Type: COMMENT; Schema: public; Owner: -
|
| 1278 |
1234 |
--
|
| 1279 |
1235 |
|
| ... | ... | |
| 1295 |
1251 |
|
| 1296 |
1252 |
|
| 1297 |
1253 |
--
|
| 1298 |
|
-- Name: COLUMN taxonconcept.subspecies; Type: COMMENT; Schema: public; Owner: -
|
| 1299 |
|
--
|
| 1300 |
|
|
| 1301 |
|
COMMENT ON COLUMN taxonconcept.subspecies IS 'The subspecies portion of the taxonomic name.';
|
| 1302 |
|
|
| 1303 |
|
|
| 1304 |
|
--
|
| 1305 |
|
-- Name: COLUMN taxonconcept.variety; Type: COMMENT; Schema: public; Owner: -
|
| 1306 |
|
--
|
| 1307 |
|
|
| 1308 |
|
COMMENT ON COLUMN taxonconcept.variety IS 'The variety portion of the taxonomic name.';
|
| 1309 |
|
|
| 1310 |
|
|
| 1311 |
|
--
|
| 1312 |
|
-- Name: COLUMN taxonconcept.forma; Type: COMMENT; Schema: public; Owner: -
|
| 1313 |
|
--
|
| 1314 |
|
|
| 1315 |
|
COMMENT ON COLUMN taxonconcept.forma IS 'The forma portion of the taxonomic name.';
|
| 1316 |
|
|
| 1317 |
|
|
| 1318 |
|
--
|
| 1319 |
|
-- Name: COLUMN taxonconcept.cultivar; Type: COMMENT; Schema: public; Owner: -
|
| 1320 |
|
--
|
| 1321 |
|
|
| 1322 |
|
COMMENT ON COLUMN taxonconcept.cultivar IS 'The cultivar portion of the taxonomic name.';
|
| 1323 |
|
|
| 1324 |
|
|
| 1325 |
|
--
|
| 1326 |
1254 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
| 1327 |
1255 |
--
|
| 1328 |
1256 |
|
| ... | ... | |
| 4627 |
4555 |
-- Name: taxonconcept_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
| 4628 |
4556 |
--
|
| 4629 |
4557 |
|
| 4630 |
|
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(domain, '\\N'::text)), (COALESCE(kingdom, '\\N'::text)), (COALESCE(phylum, '\\N'::text)), (COALESCE(class, '\\N'::text)), (COALESCE("order", '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)), (COALESCE(subspecies, '\\N'::text)), (COALESCE(variety, '\\N'::text)), (COALESCE(forma, '\\N'::text)), (COALESCE(cultivar, '\\N'::text)));
|
|
4558 |
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)));
|
| 4631 |
4559 |
|
| 4632 |
4560 |
|
| 4633 |
4561 |
--
|
schemas/vegbien.sql: taxonconcept: Removed no longer used higher- and infraspecific taxonomic rank fields because these terms are now stored in their own taxonconcepts. family, genus, and species have not been removed because these are used to cache names of parent taxa for fast access by analytical_db_view.