Project

General

Profile

« Previous | Next » 

Revision 7613

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: analytical_stem_view: Moved recordedBy, recordNumber before dateCollected as requested by Brad <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#ACAD>

View differences:

vegbien.my.sql
816 816 
    `elevationInMeters` double precision,
817 817 
    `plotArea_ha` double precision,
818 818 
    `samplingProtocol` varchar(255),
819 
    `recordedBy` varchar(255),
820 
    `recordNumber` varchar(255),
819 821 
    `dateCollected` date,
820 822 
    family_verbatim varchar(255),
821 823 
    `scientificName_verbatim` varchar(255),
......
837 839 
    `reproductiveCondition` varchar(255),
838 840 
    cultivated_bien int(11),
839 841 
    `cultivatedBasis_bien` varchar(255),
840 
    `recordedBy` varchar(255),
841 
    `recordNumber` varchar(255),
842 842 
    `coverPercent` double precision,
843 843 
    `diameterBreastHeight_cm` double precision,
844 844 
    height_m double precision,

Also available in: Unified diff