Project

General

Profile

« Previous | Next » 

Revision 5856

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: place.matched_place_id: Changed comment to say that places are linked in a three-level (instead of two-level) hierarchy of datasource place -> verbatim place -> accepted place, and this field contains the closest match

View differences:

schemas/vegbien.sql
1567 1567 
-- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public; Owner: -
1568 1568 
--
1569 1569 

  		




  1570
  
  
    
COMMENT ON COLUMN place.matched_place_id IS 'The canonical place for this verbatim place. Places should be linked in a two-level hierarchy of verbatim place -> accepted place.


  		




  
  1570
  
    
COMMENT ON COLUMN place.matched_place_id IS 'The closest match to this place. Places should be linked in a three-level hierarchy of datasource place -> verbatim place -> accepted place.


  		




  1571
  1571
  
    

  		




  1572
  1572
  
    
An accepted place should point to itself in this field. This will happen automatically by setting it to the special value 0.';


  		




  1573
  1573
  
    

  		












Also available in:  Unified diff