Project

General

Profile

« Previous | Next » 

Revision 5326

schemas/vegbien.sql: taxonconcept: family, genus, species: Added comment that each is a cached field for easy querying and the scoping version of it is stored in the chain of parent_id ancestors

View differences:

schemas/vegbien.my.sql
887 887
-- Name: COLUMN taxonconcept.family; Type: COMMENT; Schema: public; Owner: -
888 888
--
889 889

  
890
 the scoping version of this field is stored in the chain of parent_id ancestors.';
890 891

  
891 892

  
892

  
893 893
--
894 894
-- Name: COLUMN taxonconcept.genus; Type: COMMENT; Schema: public; Owner: -
895 895
--
896 896

  
897
 the scoping version of this field is stored in the chain of parent_id ancestors.';
897 898

  
898 899

  
899

  
900 900
--
901 901
-- Name: COLUMN taxonconcept.species; Type: COMMENT; Schema: public; Owner: -
902 902
--
903 903

  
904
 the scoping version of this field is stored in the chain of parent_id ancestors.';
904 905

  
905 906

  
906

  
907 907
--
908 908
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
909 909
--
schemas/vegbien.sql
1243 1243
-- Name: COLUMN taxonconcept.family; Type: COMMENT; Schema: public; Owner: -
1244 1244
--
1245 1245

  
1246
COMMENT ON COLUMN taxonconcept.family IS 'The family portion of the taxonomic name.';
1246
COMMENT ON COLUMN taxonconcept.family IS 'The family of the taxonomic name. This is a cached field for easy querying; the scoping version of this field is stored in the chain of parent_id ancestors.';
1247 1247

  
1248 1248

  
1249 1249
--
1250 1250
-- Name: COLUMN taxonconcept.genus; Type: COMMENT; Schema: public; Owner: -
1251 1251
--
1252 1252

  
1253
COMMENT ON COLUMN taxonconcept.genus IS 'The genus portion of the taxonomic name.';
1253
COMMENT ON COLUMN taxonconcept.genus IS 'The genus portion of the taxonomic name. This is a cached field for easy querying; the scoping version of this field is stored in the chain of parent_id ancestors.';
1254 1254

  
1255 1255

  
1256 1256
--
1257 1257
-- Name: COLUMN taxonconcept.species; Type: COMMENT; Schema: public; Owner: -
1258 1258
--
1259 1259

  
1260
COMMENT ON COLUMN taxonconcept.species IS 'The species portion of the taxonomic name.';
1260
COMMENT ON COLUMN taxonconcept.species IS 'The species portion of the taxonomic name. This is a cached field for easy querying; the scoping version of this field is stored in the chain of parent_id ancestors.';
1261 1261

  
1262 1262

  
1263 1263
--

Also available in: Unified diff