Revision 670
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 281 | 281 |
CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode ) |
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 |
CREATE TABLE specimen |
|
| 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together.
|
|
| 285 | 285 |
( |
| 286 | 286 |
specimen_id int(11) NOT NULL AUTO_INCREMENT, |
| 287 | 287 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ) |
| 288 | 288 |
); |
| 289 | 289 |
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
|
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
|
|
| 291 | 291 |
( |
| 292 | 292 |
specimenreplicate_id int(11) NOT NULL AUTO_INCREMENT, |
| 293 | 293 |
reference_id int(11) NOT NULL, |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 92 | 92 |
sourceaccessioncode character varying(100), |
| 93 | 93 |
); |
| 94 | 94 |
|
| 95 |
CREATE TABLE specimen |
|
| 95 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together.
|
|
| 96 | 96 |
( |
| 97 | 97 |
specimen_id serial NOT NULL, |
| 98 | 98 |
); |
| 99 | 99 |
|
| 100 |
CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
|
|
| 100 |
CREATE TABLE specimenreplicate -- A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
|
|
| 101 | 101 |
( |
| 102 | 102 |
specimenreplicate_id serial NOT NULL, |
| 103 | 103 |
reference_id integer NOT NULL, |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 281 | 281 |
CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode ) |
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 |
CREATE TABLE specimen |
|
| 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together.
|
|
| 285 | 285 |
( |
| 286 | 286 |
specimen_id serial NOT NULL, |
| 287 | 287 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ) |
| 288 | 288 |
); |
| 289 | 289 |
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
|
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
|
|
| 291 | 291 |
( |
| 292 | 292 |
specimenreplicate_id serial NOT NULL, |
| 293 | 293 |
reference_id integer NOT NULL, |
| schemas/vegbien.sql | ||
|---|---|---|
| 2269 | 2269 |
|
| 2270 | 2270 |
|
| 2271 | 2271 |
-- |
| 2272 |
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: - |
|
| 2273 |
-- |
|
| 2274 |
|
|
| 2275 |
COMMENT ON TABLE specimen IS 'A physical specimen collected from a plant. Used to link replicates of the same specimen together.'; |
|
| 2276 |
|
|
| 2277 |
|
|
| 2278 |
-- |
|
| 2272 | 2279 |
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2273 | 2280 |
-- |
| 2274 | 2281 |
|
| ... | ... | |
| 2311 | 2318 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - |
| 2312 | 2319 |
-- |
| 2313 | 2320 |
|
| 2314 |
COMMENT ON TABLE specimenreplicate IS 'A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.';
|
|
| 2321 |
COMMENT ON TABLE specimenreplicate IS 'A herbarium''s replicate of a specimen. Contains Darwin Core specimen data.';
|
|
| 2315 | 2322 |
|
| 2316 | 2323 |
|
| 2317 | 2324 |
-- |
Also available in: Unified diff
vegbien.sql: Updated table comments for specimenreplicate and specimen