Revision 4963
Added by Aaron Marcuse-Kubitza about 12 years ago
vegbien.sql | ||
---|---|---|
1138 | 1138 |
|
1139 | 1139 |
|
1140 | 1140 |
-- |
1141 |
-- Name: COLUMN taxonpath.plantcode; Type: COMMENT; Schema: public; Owner: - |
|
1142 |
-- |
|
1143 |
|
|
1144 |
COMMENT ON COLUMN taxonpath.plantcode IS 'The datasource''s unique identifier for this taxonomic name.'; |
|
1145 |
|
|
1146 |
|
|
1147 |
-- |
|
1148 |
-- Name: COLUMN taxonpath.canon_taxonpath_id; Type: COMMENT; Schema: public; Owner: - |
|
1149 |
-- |
|
1150 |
|
|
1151 |
COMMENT ON COLUMN taxonpath.canon_taxonpath_id IS 'The taxonpath containing the scrubbed name of this verbatim taxonomic name. taxonpaths should be linked only one level deep, with verbatim taxonomic names pointing to scrubbed names.'; |
|
1152 |
|
|
1153 |
|
|
1154 |
-- |
|
1155 |
-- Name: COLUMN taxonpath.taxon_id; Type: COMMENT; Schema: public; Owner: - |
|
1156 |
-- |
|
1157 |
|
|
1158 |
COMMENT ON COLUMN taxonpath.taxon_id IS 'The corresponding taxon in the tree of life. Only used for scrubbed names.'; |
|
1159 |
|
|
1160 |
|
|
1161 |
-- |
|
1162 |
-- Name: COLUMN taxonpath.scientificname; Type: COMMENT; Schema: public; Owner: - |
|
1163 |
-- |
|
1164 |
|
|
1165 |
COMMENT ON COLUMN taxonpath.scientificname IS 'The concatenated taxonomic name which uniquely identifies this taxon. Does not include the author of the name. |
|
1166 |
|
|
1167 |
Equivalent to Darwin Core''s scientificName.'; |
|
1168 |
|
|
1169 |
|
|
1170 |
-- |
|
1141 | 1171 |
-- Name: COLUMN taxonpath.author; Type: COMMENT; Schema: public; Owner: - |
1142 | 1172 |
-- |
1143 | 1173 |
|
1144 |
COMMENT ON COLUMN taxonpath.author IS 'The author of the scientific name'; |
|
1174 |
COMMENT ON COLUMN taxonpath.author IS 'The author of the scientific name.';
|
|
1145 | 1175 |
|
1146 | 1176 |
|
1147 | 1177 |
-- |
1148 | 1178 |
-- Name: COLUMN taxonpath.scientificnamewithauthor; Type: COMMENT; Schema: public; Owner: - |
1149 | 1179 |
-- |
1150 | 1180 |
|
1151 |
COMMENT ON COLUMN taxonpath.scientificnamewithauthor IS 'Equivalent to "Name sec. x".';
|
|
1181 |
COMMENT ON COLUMN taxonpath.scientificnamewithauthor IS 'The concatenated taxonomic name which uniquely identifies this taxon, plus the author of that name.
|
|
1152 | 1182 |
|
1183 |
Equivalent to Darwin Core''s scientificName + scientificNameAuthorship. |
|
1184 |
Equivalent to "Name sec. x".'; |
|
1153 | 1185 |
|
1186 |
|
|
1154 | 1187 |
-- |
1155 | 1188 |
-- Name: COLUMN taxonpath.otherranks; Type: COMMENT; Schema: public; Owner: - |
1156 | 1189 |
-- |
1157 | 1190 |
|
1158 |
COMMENT ON COLUMN taxonpath.otherranks IS 'Put ranks in path order, so that lower-level taxa come after higher-level taxa.'; |
|
1191 |
COMMENT ON COLUMN taxonpath.otherranks IS 'Additional ranks which do not have a named column. Put ranks in path order, so that lower-level taxa come after higher-level taxa.';
|
|
1159 | 1192 |
|
1160 | 1193 |
|
1161 | 1194 |
-- |
1162 | 1195 |
-- Name: COLUMN taxonpath.scope_id; Type: COMMENT; Schema: public; Owner: - |
1163 | 1196 |
-- |
1164 | 1197 |
|
1165 |
COMMENT ON COLUMN taxonpath.scope_id IS 'The morphospecies scope'; |
|
1198 |
COMMENT ON COLUMN taxonpath.scope_id IS 'The morphospecies scope.';
|
|
1166 | 1199 |
|
1167 | 1200 |
|
1168 | 1201 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonpath columns other than named ranks: Added descriptive comments for data dictionary