Project

General

Profile

« Previous | Next » 

Revision 7130

schemas/vegbien.sql: taxonverbatim: taxonverbatim_unique: Added morphospecies so that there can be multiple taxonverbatims for the same taxonlabel, each with different morphospecies suffixes

View differences:

vegbien.my.sql
4925 4925

  
4926 4926

  
4927 4927
--
4928
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4929
--
4930

  
4931
ALTER TABLE taxonverbatim
4932
    ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
4933

  
4934

  
4935
--
4936 4928
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4937 4929
--
4938 4930

  
......
6151 6143

  
6152 6144

  
6153 6145
--
6146
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
6147
--
6148

  
6149

  
6150

  
6151

  
6152
--
6154 6153
-- Name: telephone_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
6155 6154
--
6156 6155

  

Also available in: Unified diff