Revision 559
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 338 | 338 |
CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ), |
| 339 | 339 |
CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) |
| 340 | 340 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
| 341 |
ON UPDATE CASCADE ON DELETE CASCADE,
|
|
| 341 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
| 342 | 342 |
); |
| 343 | 343 |
|
| 344 | 344 |
CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms. |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 338 | 338 |
CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ), |
| 339 | 339 |
CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) |
| 340 | 340 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
| 341 |
ON UPDATE CASCADE ON DELETE CASCADE,
|
|
| 341 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
| 342 | 342 |
); |
| 343 | 343 |
|
| 344 | 344 |
CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms. |
Also available in: Unified diff
vegbien.for_ERD.sql: Fixed syntax error in stratum table