Project

General

Profile

« Previous | Next » 

Revision 5309

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: taxonconcept: Moved identifyingtaxonomicname near other full-taxonomic-name-related fields, after the fields that contain just the current level's component of the full name

View differences:

schemas/vegbien.my.sql
781 781 
CREATE TABLE taxonconcept (
782 782 
    taxonconcept_id int(11) NOT NULL,
783 783 
    creator_id int(11) NOT NULL,
784 
    identifyingtaxonomicname text,
785 784 
    canon_taxonconcept_id int(11),
786 785 
    parent_id int(11),
787 786 
    taxonname text,
788 787 
    rank text,
789 788 
    verbatimrank text,
789 
    identifyingtaxonomicname text,
790 790 
    taxonomicname text,
791 791 
    author text,
792 792 
    taxonomicnamewithauthor text,
......
813 813 

  		




  814
  814
  
    

  		




  815
  815
  
    
--


  		




  816
  
  
    
-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: -


  		




  
  816
  
    
-- Name: COLUMN taxonconcept.canon_taxonconcept_id; Type: COMMENT; Schema: public; Owner: -


  		




  817
  817
  
    
--


  		




  818
  818
  
    

  		




  819
  819
  
    

  		




  820
  820
  
    

  		




  821
  821
  
    

  		




  822
  822
  
    
--


  		




  823
  
  
    
-- Name: COLUMN taxonconcept.canon_taxonconcept_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  823
  
    
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: -


  		




  824
  824
  
    
--


  		




  825
  825
  
    

  		




  826
  826
  
    

  		




  827
  827
  
    

  		




  828
  828
  
    

  		




  829
  829
  
    
--


  		




  830
  
  
    
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  830
  
    
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: -


  		




  831
  831
  
    
--


  		




  832
  832
  
    

  		




  833
  833
  
    

  		




  834
  834
  
    

  		




  835
  835
  
    

  		




  836
  836
  
    
--


  		




  837
  
  
    
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: -


  		




  
  837
  
    
-- Name: COLUMN taxonconcept.rank; Type: COMMENT; Schema: public; Owner: -


  		




  838
  838
  
    
--


  		




  839
  839
  
    

  		




  840
  840
  
    

  		




  841
  841
  
    

  		




  842
  842
  
    

  		




  843
  843
  
    
--


  		




  844
  
  
    
-- Name: COLUMN taxonconcept.rank; Type: COMMENT; Schema: public; Owner: -


  		




  
  844
  
    
-- Name: COLUMN taxonconcept.verbatimrank; Type: COMMENT; Schema: public; Owner: -


  		




  845
  845
  
    
--


  		




  846
  846
  
    

  		




  847
  847
  
    

  		




  848
  848
  
    

  		




  849
  849
  
    

  		




  850
  850
  
    
--


  		




  851
  
  
    
-- Name: COLUMN taxonconcept.verbatimrank; Type: COMMENT; Schema: public; Owner: -


  		




  
  851
  
    
-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: -


  		




  852
  852
  
    
--


  		




  853
  853
  
    

  		




  854
  854
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  1115
  1115
  
    
CREATE TABLE taxonconcept (


  		




  1116
  1116
  
    
    taxonconcept_id integer NOT NULL,


  		




  1117
  1117
  
    
    creator_id integer NOT NULL,


  		




  1118
  
  
    
    identifyingtaxonomicname text,


  		




  1119
  1118
  
    
    canon_taxonconcept_id integer,


  		




  1120
  1119
  
    
    parent_id integer,


  		




  1121
  1120
  
    
    taxonname text,


  		




  1122
  1121
  
    
    rank taxonrank,


  		




  1123
  1122
  
    
    verbatimrank text,


  		




  
  1123
  
    
    identifyingtaxonomicname text,


  		




  1124
  1124
  
    
    taxonomicname text,


  		




  1125
  1125
  
    
    author text,


  		




  1126
  1126
  
    
    taxonomicnamewithauthor text,


  		




  ......




  1154
  1154
  
    

  		




  1155
  1155
  
    

  		




  1156
  1156
  
    
--


  		




  1157
  
  
    
-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: -


  		




  1158
  
  
    
--


  		




  1159
  
  
    

  		




  1160
  
  
    
COMMENT ON COLUMN taxonconcept.identifyingtaxonomicname IS 'The taxonomic name that uniquely identifies this taxonconcept. If set, the other fields will not be used in duplicate elimination.';


  		




  1161
  
  
    

  		




  1162
  
  
    

  		




  1163
  
  
    
--


  		




  1164
  1157
  
    
-- Name: COLUMN taxonconcept.canon_taxonconcept_id; Type: COMMENT; Schema: public; Owner: -


  		




  1165
  1158
  
    
--


  		




  1166
  1159
  
    

  		




  ......




  1202
  1195
  
    

  		




  1203
  1196
  
    

  		




  1204
  1197
  
    
--


  		




  
  1198
  
    
-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: -


  		




  
  1199
  
    
--


  		




  
  1200
  
    

  		




  
  1201
  
    
COMMENT ON COLUMN taxonconcept.identifyingtaxonomicname IS 'The taxonomic name that uniquely identifies this taxonconcept. If set, the other fields will not be used in duplicate elimination.';


  		




  
  1202
  
    

  		




  
  1203
  
    

  		




  
  1204
  
    
--


  		




  1205
  1205
  
    
-- Name: COLUMN taxonconcept.taxonomicname; Type: COMMENT; Schema: public; Owner: -


  		




  1206
  1206
  
    
--


  		




  1207
  1207
  
    

  		












Also available in:  Unified diff