Project

General

Profile

« Previous | Next » 

Revision 3736

schemas/vegbien.sql: unique_within unique indexes used for 1:1 relationships: Renamed to __1_to_1 to better reflect what they do

View differences:

vegbien.my.sql
3837 3837

  
3838 3838

  
3839 3839
--
3840
-- Name: stemobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3840
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3841 3841
--
3842 3842

  
3843 3843

  
3844 3844

  
3845 3845

  
3846 3846
--
3847
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3847
-- Name: stemobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3848 3848
--
3849 3849

  
3850 3850

  
......
3872 3872

  
3873 3873

  
3874 3874
--
3875
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3875
-- Name: taxonoccurrence_locationevent_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3876 3876
--
3877 3877

  
3878 3878

  
3879 3879

  
3880 3880

  
3881 3881
--
3882
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3882
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3883 3883
--
3884 3884

  
3885 3885

  

Also available in: Unified diff