Project

General

Profile

« Previous | Next » 

Revision 4963

schemas/vegbien.sql: taxonpath columns other than named ranks: Added descriptive comments for data dictionary

View differences:

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