Project

General

Profile

« Previous | Next » 

Revision 6475

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: analytical_*: Removed primary keys and NOT NULL constraints on columns that sometimes have NULL values

View differences:

vegbien.my.sql
610 610 
    `speciesBinomial` varchar(255),
611 611 
    `scientificName` varchar(255),
612 612 
    `scientificNameAuthorship` varchar(255),
613 
    `scientificNameWithMorphospecies` varchar(255) NOT NULL,
613 
    `scientificNameWithMorphospecies` varchar(255),
614 614 
    threatened int(1),
615 615 
    `identifiedBy` varchar(255),
616 616 
    `growthForm` varchar(255),
......
651 651 
    `speciesBinomial` varchar(255),
652 652 
    `scientificName` varchar(255),
653 653 
    `scientificNameAuthorship` varchar(255),
654 
    `scientificNameWithMorphospecies` varchar(255) NOT NULL,
654 
    `scientificNameWithMorphospecies` varchar(255),
655 655 
    threatened int(1),
656 656 
    `identifiedBy` varchar(255),
657 657 
    `growthForm` varchar(255),
......
664 664 
    `organismX_m` double precision,
665 665 
    `organismY_m` double precision,
666 666 
    `recordedBy` varchar(255),
667 
    `recordNumber` varchar(255) NOT NULL
667 
    `recordNumber` varchar(255)
668 668 
);
669 669 

  		




  670
  670
  
    

  		




  ......




  4271
  4271
  
    

  		




  4272
  4272
  
    

  		




  4273
  4273
  
    
--


  		




  4274
  
  
    
-- Name: analytical_aggregate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 


  		




  4275
  
  
    
--


  		




  4276
  
  
    

  		




  4277
  
  
    
ALTER TABLE analytical_aggregate


  		




  4278
  
  
    
    ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`);


  		




  4279
  
  
    

  		




  4280
  
  
    

  		




  4281
  
  
    
--


  		




  4282
  
  
    
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 


  		




  4283
  
  
    
--


  		




  4284
  
  
    

  		




  4285
  
  
    
ALTER TABLE analytical_stem


  		




  4286
  
  
    
    ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`, `recordNumber`);


  		




  4287
  
  
    

  		




  4288
  
  
    

  		




  4289
  
  
    
--


  		




  4290
  4274
  
    
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 


  		




  4291
  4275
  
    
--


  		




  4292
  4276
  
    

  		












Also available in:  Unified diff