Project

General

Profile

« Previous | Next » 

Revision 607

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Made aggregateoccurrence.count to handle individuals data (for which count should be dynamically determined from # individual plants inside the aggregateoccurrence)

View differences:

schemas/vegbien.for_ERD.my.sql
221 221 
  stratumheight double precision,
222 222 
  emb_aggregateoccurrence int(11),
223 223 
  covercode character varying(10),
224 
  count int(11) NOT NULL,
224 
  count int(11),
225 225 
  accessioncode character varying(255),
226 226 
  sourceaccessioncode character varying(100),
227 227 
  CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),
schemas/vegbien.for_wiki.sql
55 55 
  stratumheight double precision,
56 56 
  emb_aggregateoccurrence integer,
57 57 
  covercode character varying(10),
58 
  count integer NOT NULL,
58 
  count integer,
59 59 
  accessioncode character varying(255),
60 60 
  sourceaccessioncode character varying(100),
61 61 
);
schemas/vegbien.for_ERD.sql
221 221 
  stratumheight double precision,
222 222 
  emb_aggregateoccurrence integer,
223 223 
  covercode character varying(10),
224 
  count integer NOT NULL,
224 
  count integer,
225 225 
  accessioncode character varying(255),
226 226 
  sourceaccessioncode character varying(100),
227 227 
  CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),
schemas/vegbien.sql
87 87 
    stratumheight double precision,
88 88 
    emb_aggregateoccurrence integer,
89 89 
    covercode character varying(10),
90 
    count integer NOT NULL,
90 
    count integer,
91 91 
    accessioncode character varying(255),
92 92 
    sourceaccessioncode character varying(100)
93 93 
);

Also available in: Unified diff