Revision 576
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 252 | 252 |
museum_id int(11), |
| 253 | 253 |
sourceaccessionnumber character varying(100), |
| 254 | 254 |
accessioncode character varying(255), |
| 255 |
taxonoccurrence_id int(11), |
|
| 255 |
taxonoccurrence_id int(11) NOT NULL,
|
|
| 256 | 256 |
collectornumber_dwc character varying(255), |
| 257 | 257 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 258 | 258 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 98 | 98 |
museum_id integer, |
| 99 | 99 |
sourceaccessionnumber character varying(100), |
| 100 | 100 |
accessioncode character varying(255), |
| 101 |
taxonoccurrence_id integer, |
|
| 101 |
taxonoccurrence_id integer NOT NULL,
|
|
| 102 | 102 |
collectornumber_dwc character varying(255), |
| 103 | 103 |
); |
| 104 | 104 |
|
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 252 | 252 |
museum_id integer, |
| 253 | 253 |
sourceaccessionnumber character varying(100), |
| 254 | 254 |
accessioncode character varying(255), |
| 255 |
taxonoccurrence_id integer, |
|
| 255 |
taxonoccurrence_id integer NOT NULL,
|
|
| 256 | 256 |
collectornumber_dwc character varying(255), |
| 257 | 257 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 258 | 258 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
| schemas/vegbien.sql | ||
|---|---|---|
| 2270 | 2270 |
museum_id integer, |
| 2271 | 2271 |
sourceaccessionnumber character varying(100), |
| 2272 | 2272 |
accessioncode character varying(255), |
| 2273 |
taxonoccurrence_id integer, |
|
| 2273 |
taxonoccurrence_id integer NOT NULL,
|
|
| 2274 | 2274 |
collectornumber_dwc character varying(255) |
| 2275 | 2275 |
); |
| 2276 | 2276 |
|
Also available in: Unified diff
vegbien.sql: Made specimen.taxonoccurrence_id required