Project

General

Profile

« Previous | Next » 

Revision 12165

schemas/vegbien.sql: public_validation_traits: added Brad's notes as comments

View differences:

trunk/schemas/vegbien.my.sql
3491 3491

  
3492 3492

  
3493 3493
--
3494
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: -
3495
--
3496

  
3497

  
3498

  
3499

  
3500
--
3494 3501
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -
3495 3502
--
3496 3503

  
......
3498 3505

  
3499 3506

  
3500 3507
--
3508
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: -
3509
--
3510

  
3511

  
3512

  
3513

  
3514
--
3501 3515
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -
3502 3516
--
3503 3517

  
trunk/schemas/vegbien.sql
5240 5240

  
5241 5241

  
5242 5242
--
5243
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: -
5244
--
5245

  
5246
COMMENT ON VIEW _05_count_taxa IS 'Note: No morphospecies in trait table, therefore count taxon + authority only
5247
';
5248

  
5249

  
5250
--
5243 5251
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: -
5244 5252
--
5245 5253

  
......
5251 5259

  
5252 5260

  
5253 5261
--
5262
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: -
5263
--
5264

  
5265
COMMENT ON VIEW _06_list_taxa IS 'Note 1: No morphospecies in trait table, use taxon + authority 
5266
Note 2: Note formation of taxonCorrected: includes family ONLY if taxon is not determined at least to genus
5267
';
5268

  
5269

  
5270
--
5254 5271
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: -
5255 5272
--
5256 5273

  

Also available in: Unified diff