Revision 675
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 401 | 401 |
stratum_id int(11) NOT NULL AUTO_INCREMENT, |
| 402 | 402 |
locationevent_id int(11) NOT NULL, |
| 403 | 403 |
stratumtype_id int(11) NOT NULL, |
| 404 |
stratummethod_id int(11), |
|
| 405 |
stratumname character varying(30), |
|
| 406 | 404 |
stratumheight double precision, |
| 407 | 405 |
stratumbase double precision, |
| 408 | 406 |
stratumcover double precision, |
| 409 |
stratumdescription character varying(200), |
|
| 410 | 407 |
CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ), |
| 411 | 408 |
CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) |
| 412 | 409 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
Also available in: Unified diff
vegbien.sql: Removed denormalized duplicate fields from stratum