Project

General

Profile

« Previous | Next » 

Revision 8580

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/VegCore/VegCore.ERD.mwb: added primary columns. changed VARCHAR columns to TEXT and also set default type in ERD so future columns won't need to be changed.

View differences:

schemas/VegCore/VegCore.my.sql
28 28 
CREATE  TABLE IF NOT EXISTS `record` (
29 29 
  `id` TEXT NOT NULL ,
30 30 
  `source` TEXT NOT NULL ,
31 
  `source_record_id` TEXT NULL ,
31 32 
  PRIMARY KEY (`id`) ,
32 33 
  INDEX `fk_record_source1` (`source` ASC) ,
34 
  UNIQUE INDEX `record_unique` (`source` ASC, `source_record_id` ASC) ,
33 35 
  CONSTRAINT `fk_record_source1`
34 36 
    FOREIGN KEY (`source` )
35 37 
    REFERENCES `source` (`id` )
......
80 82 
  `formal_name` TEXT NULL ,
81 83 
  `taxon_name` TEXT NULL ,
82 84 
  `author` TEXT NULL ,
85 
  `common_name` TEXT NULL ,
83 86 
  `rank` TEXT NULL ,
84 87 
  PRIMARY KEY (`id`) ,
85 88 
  INDEX `fk_taxon_concept_taxon_string10` (`unique_name` ASC) ,
......
246 249 
-- -----------------------------------------------------
247 250 
CREATE  TABLE IF NOT EXISTS `place_path` (
248 251 
  `id` TEXT NOT NULL ,
249 
  `continent` VARCHAR(45) NULL ,
250 
  `country` VARCHAR(45) NULL ,
251 
  `state_province` VARCHAR(45) NULL ,
252 
  `county` VARCHAR(45) NULL ,
253 
  `municipality` VARCHAR(45) NULL ,
252 
  `continent` TEXT NULL ,
253 
  `country` TEXT NULL ,
254 
  `state_province` TEXT NULL ,
255 
  `county` TEXT NULL ,
256 
  `municipality` TEXT NULL ,
254 257 
  `ranks` SET('hstore') NULL ,
255 258 
  PRIMARY KEY (`id`) )
256 259 
ENGINE = InnoDB
......
266 269 
  `parent` TEXT NOT NULL ,
267 270 
  `coordinates` TEXT NULL ,
268 271 
  `path` TEXT NULL ,
269 
  `locality` VARCHAR(45) NULL ,
272 
  `locality` TEXT NULL ,
270 273 
  PRIMARY KEY (`id`) ,
271 274 
  INDEX `fk_place_coordinates1` (`coordinates` ASC) ,
272 275 
  INDEX `fk_place1` (`parent` ASC) ,
......
320 323 
  `id` TEXT NOT NULL ,
321 324 
  `parent` TEXT NOT NULL ,
322 325 
  `name` TEXT NULL ,
326 
  `date_range` TEXT NULL ,
323 327 
  `place` TEXT NULL ,
324 328 
  `method` TEXT NULL ,
325 329 
  PRIMARY KEY (`id`) ,
......
356 360 
-- -----------------------------------------------------
357 361 
CREATE  TABLE IF NOT EXISTS `taxon_occurrence` (
358 362 
  `id` TEXT NOT NULL ,
363 
  `collector` TEXT NULL ,
364 
  `collector_number` TEXT NULL ,
359 365 
  `current_determination` TEXT NULL ,
360 366 
  `original_determination` TEXT NULL ,
367 
  `growth_form` TEXT NULL ,
361 368 
  `cultivated` TINYINT(1) NULL ,
362 369 
  `traits` SET('hstore') NULL ,
363 370 
  PRIMARY KEY (`id`) ,
364 371 
  INDEX `fk_taxon_occurrence_taxon_determination1` (`original_determination` ASC) ,
365 372 
  INDEX `fk_taxon_occurrence_taxon_determination2` (`current_determination` ASC) ,
373 
  INDEX `fk_taxon_occurrence_party1` (`collector` ASC) ,
366 374 
  CONSTRAINT `fk_taxon_occurrence_taxon_determination1`
367 375 
    FOREIGN KEY (`original_determination` )
368 376 
    REFERENCES `taxon_determination` (`id` )
......
377 385 
    FOREIGN KEY (`id` )
378 386 
    REFERENCES `event` (`id` )
379 387 
    ON DELETE CASCADE
388 
    ON UPDATE CASCADE,
389 
  CONSTRAINT `fk_taxon_occurrence_party1`
390 
    FOREIGN KEY (`collector` )
391 
    REFERENCES `party` (`id` )
392 
    ON DELETE CASCADE
380 393 
    ON UPDATE CASCADE)
381 394 
ENGINE = InnoDB
382 395 
DEFAULT CHARACTER SET = latin1
......
388 401 
-- -----------------------------------------------------
389 402 
CREATE  TABLE IF NOT EXISTS `collection` (
390 403 
  `id` TEXT NOT NULL ,
404 
  `code` TEXT NULL ,
391 405 
  PRIMARY KEY (`id`) ,
392 406 
  CONSTRAINT `fk_collection_source1`
393 407 
    FOREIGN KEY (`id` )
......
404 418 
-- -----------------------------------------------------
405 419 
CREATE  TABLE IF NOT EXISTS `specimen` (
406 420 
  `id` TEXT NOT NULL ,
407 
  `collection` TEXT NOT NULL ,
421 
  `specimen_holder_institutions` TEXT NULL ,
422 
  `donor_institution` TEXT NULL ,
423 
  `owner` TEXT NULL ,
424 
  `stamping_institution` TEXT NULL ,
425 
  `collection` TEXT NULL ,
426 
  `barcode` TEXT NULL ,
427 
  `accession_number` TEXT NULL ,
408 428 
  PRIMARY KEY (`id`) ,
409 429 
  INDEX `fk_specimen_collection1` (`collection` ASC) ,
410 430 
  CONSTRAINT `fk_specimen_taxon_occurrence1`
......
459 479 
CREATE  TABLE IF NOT EXISTS `individual` (
460 480 
  `id` TEXT NOT NULL ,
461 481 
  `tag` TEXT NULL ,
462 
  `author_code` VARCHAR(45) NULL ,
482 
  `code` TEXT NULL ,
463 483 
  PRIMARY KEY (`id`) ,
464 484 
  CONSTRAINT `fk_individual_record1`
465 485 
    FOREIGN KEY (`id` )

Also available in: Unified diff