Project

General

Profile

« Previous | Next » 

Revision 7604

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: analytical_stem_view: Moved identifiedBy, dateIdentified, identificationRemarks right after the *_verbatim terms that they relate to, as requested by Brad <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#ACAD>

View differences:

vegbien.my.sql
820 820 
    family_verbatim varchar(255),
821 821 
    `scientificName_verbatim` varchar(255),
822 822 
    `scientificNameAuthorship_verbatim` varchar(255),
823 
    `identifiedBy` varchar(255),
824 
    `dateIdentified` date,
825 
    `identificationRemarks` varchar(255),
823 826 
    family_matched varchar(255),
824 827 
    `taxonName_matched` varchar(255),
825 828 
    `scientificNameAuthorship_matched` varchar(255),
......
830 833 
    `taxonName` varchar(255),
831 834 
    `scientificNameAuthorship` varchar(255),
832 835 
    threatened_bien int(11),
833 
    `identifiedBy` varchar(255),
834 
    `dateIdentified` date,
835 
    `identificationRemarks` varchar(255),
836 836 
    `growthForm` varchar(255),
837 837 
    cultivated_bien int(11),
838 838 
    `cultivatedBasis_bien` varchar(255),

Also available in: Unified diff