Revision 642
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 282 | 282 |
( |
| 283 | 283 |
specimen_id int(11) NOT NULL AUTO_INCREMENT, |
| 284 | 284 |
reference_id int(11) NOT NULL, |
| 285 |
collectioncode_dwc character varying(255), |
|
| 285 |
collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
|
|
| 286 | 286 |
catalognumber_dwc character varying(255), |
| 287 | 287 |
collectiondate timestamp NULL, |
| 288 | 288 |
museum_id int(11), |
| ... | ... | |
| 290 | 290 |
accessioncode character varying(255), |
| 291 | 291 |
taxonoccurrence_id int(11) NOT NULL, |
| 292 | 292 |
verbatimcollectorname character varying(255), |
| 293 |
collectionnumber character varying(255), |
|
| 293 |
collectionnumber character varying(255), -- The number of the specimen within the collection.
|
|
| 294 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 295 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 296 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 95 | 95 |
( |
| 96 | 96 |
specimen_id serial NOT NULL, |
| 97 | 97 |
reference_id integer NOT NULL, |
| 98 |
collectioncode_dwc character varying(255), |
|
| 98 |
collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
|
|
| 99 | 99 |
catalognumber_dwc character varying(255), |
| 100 | 100 |
collectiondate timestamp with time zone, |
| 101 | 101 |
museum_id integer, |
| ... | ... | |
| 103 | 103 |
accessioncode character varying(255), |
| 104 | 104 |
taxonoccurrence_id integer NOT NULL, |
| 105 | 105 |
verbatimcollectorname character varying(255), |
| 106 |
collectionnumber character varying(255), |
|
| 106 |
collectionnumber character varying(255), -- The number of the specimen within the collection.
|
|
| 107 | 107 |
); |
| 108 | 108 |
|
| 109 | 109 |
CREATE TABLE voucher |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 282 | 282 |
( |
| 283 | 283 |
specimen_id serial NOT NULL, |
| 284 | 284 |
reference_id integer NOT NULL, |
| 285 |
collectioncode_dwc character varying(255), |
|
| 285 |
collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
|
|
| 286 | 286 |
catalognumber_dwc character varying(255), |
| 287 | 287 |
collectiondate timestamp with time zone, |
| 288 | 288 |
museum_id integer, |
| ... | ... | |
| 290 | 290 |
accessioncode character varying(255), |
| 291 | 291 |
taxonoccurrence_id integer NOT NULL, |
| 292 | 292 |
verbatimcollectorname character varying(255), |
| 293 |
collectionnumber character varying(255), |
|
| 293 |
collectionnumber character varying(255), -- The number of the specimen within the collection.
|
|
| 294 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 295 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 296 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| schemas/vegbien.sql | ||
|---|---|---|
| 2285 | 2285 |
|
| 2286 | 2286 |
|
| 2287 | 2287 |
-- |
| 2288 |
-- Name: COLUMN specimen.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 2289 |
-- |
|
| 2290 |
|
|
| 2291 |
COMMENT ON COLUMN specimen.collectioncode_dwc IS 'The code for the collection that the specimen is from.'; |
|
| 2292 |
|
|
| 2293 |
|
|
| 2294 |
-- |
|
| 2295 |
-- Name: COLUMN specimen.collectionnumber; Type: COMMENT; Schema: public; Owner: - |
|
| 2296 |
-- |
|
| 2297 |
|
|
| 2298 |
COMMENT ON COLUMN specimen.collectionnumber IS 'The number of the specimen within the collection.'; |
|
| 2299 |
|
|
| 2300 |
|
|
| 2301 |
-- |
|
| 2288 | 2302 |
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2289 | 2303 |
-- |
| 2290 | 2304 |
|
Also available in: Unified diff
vegbien.sql: Added comments to specimen.collectioncode_dwc and collectionnumber to differentiate them