Project

General

Profile

« Previous | Next » 

Revision 676

vegbien.sql: Added stratum.area

View differences:

schemas/vegbien.for_ERD.my.sql
404 404
  stratumheight double precision,
405 405
  stratumbase double precision,
406 406
  stratumcover double precision,
407
  area double precision,
407 408
  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),
408 409
  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)
409 410
      REFERENCES locationevent (locationevent_id) MATCH SIMPLE
schemas/vegbien.for_wiki.sql
165 165
  stratumheight double precision,
166 166
  stratumbase double precision,
167 167
  stratumcover double precision,
168
  area double precision,
168 169
);
169 170

  
170 171
CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.
schemas/vegbien.for_ERD.sql
404 404
  stratumheight double precision,
405 405
  stratumbase double precision,
406 406
  stratumcover double precision,
407
  area double precision,
407 408
  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),
408 409
  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)
409 410
      REFERENCES locationevent (locationevent_id) MATCH SIMPLE
schemas/vegbien.sql
2488 2488
    stratumtype_id integer NOT NULL,
2489 2489
    stratumheight double precision,
2490 2490
    stratumbase double precision,
2491
    stratumcover double precision
2491
    stratumcover double precision,
2492
    area double precision
2492 2493
);
2493 2494

  
2494 2495

  

Also available in: Unified diff