Revision 1030
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2373 | 2373 |
ALTER SEQUENCE role_role_id_seq OWNED BY role.role_id; |
| 2374 | 2374 |
|
| 2375 | 2375 |
|
| 2376 |
SET default_with_oids = false; |
|
| 2377 |
|
|
| 2378 | 2376 |
-- |
| 2379 |
-- Name: sizeclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2380 |
-- |
|
| 2381 |
|
|
| 2382 |
CREATE TABLE sizeclass ( |
|
| 2383 |
sizeclass_id integer NOT NULL, |
|
| 2384 |
mindiameter double precision, |
|
| 2385 |
minheight double precision, |
|
| 2386 |
maxdiameter double precision, |
|
| 2387 |
maxheight double precision, |
|
| 2388 |
accessioncode text |
|
| 2389 |
); |
|
| 2390 |
|
|
| 2391 |
|
|
| 2392 |
-- |
|
| 2393 |
-- Name: TABLE sizeclass; Type: COMMENT; Schema: public; Owner: - |
|
| 2394 |
-- |
|
| 2395 |
|
|
| 2396 |
COMMENT ON TABLE sizeclass IS 'A range of size measurements used to aggregate organisms.'; |
|
| 2397 |
|
|
| 2398 |
|
|
| 2399 |
-- |
|
| 2400 |
-- Name: sizeclass_sizeclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2401 |
-- |
|
| 2402 |
|
|
| 2403 |
CREATE SEQUENCE sizeclass_sizeclass_id_seq |
|
| 2404 |
START WITH 1 |
|
| 2405 |
INCREMENT BY 1 |
|
| 2406 |
NO MINVALUE |
|
| 2407 |
NO MAXVALUE |
|
| 2408 |
CACHE 1; |
|
| 2409 |
|
|
| 2410 |
|
|
| 2411 |
-- |
|
| 2412 |
-- Name: sizeclass_sizeclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2413 |
-- |
|
| 2414 |
|
|
| 2415 |
ALTER SEQUENCE sizeclass_sizeclass_id_seq OWNED BY sizeclass.sizeclass_id; |
|
| 2416 |
|
|
| 2417 |
|
|
| 2418 |
SET default_with_oids = true; |
|
| 2419 |
|
|
| 2420 |
-- |
|
| 2421 | 2377 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2422 | 2378 |
-- |
| 2423 | 2379 |
|
| ... | ... | |
| 3795 | 3751 |
|
| 3796 | 3752 |
|
| 3797 | 3753 |
-- |
| 3798 |
-- Name: sizeclass_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3799 |
-- |
|
| 3800 |
|
|
| 3801 |
ALTER TABLE sizeclass ALTER COLUMN sizeclass_id SET DEFAULT nextval('sizeclass_sizeclass_id_seq'::regclass);
|
|
| 3802 |
|
|
| 3803 |
|
|
| 3804 |
-- |
|
| 3805 | 3754 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: - |
| 3806 | 3755 |
-- |
| 3807 | 3756 |
|
| ... | ... | |
| 4561 | 4510 |
|
| 4562 | 4511 |
|
| 4563 | 4512 |
-- |
| 4564 |
-- Name: sizeclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4565 |
-- |
|
| 4566 |
|
|
| 4567 |
ALTER TABLE ONLY sizeclass |
|
| 4568 |
ADD CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id); |
|
| 4569 |
|
|
| 4570 |
|
|
| 4571 |
-- |
|
| 4572 | 4513 |
-- Name: soilobs_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4573 | 4514 |
-- |
| 4574 | 4515 |
|
| ... | ... | |
| 6146 | 6087 |
|
| 6147 | 6088 |
|
| 6148 | 6089 |
-- |
| 6149 |
-- Name: aggregateoccurrence_sizeclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6150 |
-- |
|
| 6151 |
|
|
| 6152 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 6153 |
ADD CONSTRAINT aggregateoccurrence_sizeclass_id FOREIGN KEY (sizeclass_id) REFERENCES sizeclass(sizeclass_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6154 |
|
|
| 6155 |
|
|
| 6156 |
-- |
|
| 6157 | 6090 |
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6158 | 6091 |
-- |
| 6159 | 6092 |
|
Also available in: Unified diff
vegbien.sql: Removed no longer needed sizeclass table (whose fields are now in method)