-- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: -

--

CREATE TYPE methodtraitname_appliesto AS ENUM (

    'locationevent',

    'taxonoccurrence'

);

--

SET default_with_oids = false;

-- Name: methodtrait; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE methodtrait (

    methodtrait_id integer NOT NULL,

    method_id integer NOT NULL,

    methodtraitname_id integer NOT NULL,

    value text NOT NULL

);

--

-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE methodtrait_methodtrait_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE methodtrait_methodtrait_id_seq OWNED BY methodtrait.methodtrait_id;

--

-- Name: methodtraitname; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE methodtraitname (

    methodtraitname_id integer NOT NULL,

    name text NOT NULL,

    appliesto methodtraitname_appliesto[] NOT NULL

);

--

-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE methodtraitname_methodtraitname_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE methodtraitname_methodtraitname_id_seq OWNED BY methodtraitname.methodtraitname_id;

SET default_with_oids = true;

--

-- Name: methodtrait_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE methodtrait ALTER COLUMN methodtrait_id SET DEFAULT nextval('methodtrait_methodtrait_id_seq'::regclass);

--

-- Name: methodtraitname_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE methodtraitname ALTER COLUMN methodtraitname_id SET DEFAULT nextval('methodtraitname_methodtraitname_id_seq'::regclass);

--

-- Name: methodtrait_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY methodtrait

    ADD CONSTRAINT methodtrait_keys UNIQUE (method_id, methodtraitname_id);

--

-- Name: methodtrait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY methodtrait

    ADD CONSTRAINT methodtrait_pkey PRIMARY KEY (methodtrait_id);

--

-- Name: methodtraitname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY methodtraitname

    ADD CONSTRAINT methodtraitname_keys UNIQUE (name);

--

-- Name: methodtraitname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY methodtraitname

    ADD CONSTRAINT methodtraitname_pkey PRIMARY KEY (methodtraitname_id);

--

-- Name: fki_methodtrait_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtrait_method_id ON methodtrait USING btree (method_id);

--

-- Name: fki_methodtrait_methodtraitname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtrait_methodtraitname_id ON methodtrait USING btree (methodtraitname_id);

--

-- Name: methodtrait_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY methodtrait

    ADD CONSTRAINT methodtrait_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: methodtrait_methodtraitname_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY methodtrait

    ADD CONSTRAINT methodtrait_methodtraitname_id FOREIGN KEY (methodtraitname_id) REFERENCES methodtraitname(methodtraitname_id) ON UPDATE CASCADE ON DELETE CASCADE;

--