treebase-devel

[Treebase-devel] unusual PK in stepmatrixelement

[Vladimir G. <vla...@du...>]

Table stepmatrixelement has an unusual name and definition of its  
primary key: it appears to have been copied from another table,  
discretecharstate.  (Definitions of both are below.)
Is this indeed a cut-and-paste error?

--Vladimir


CREATE TABLE stepmatrixelement
(
   discretecharstate_id bigint NOT NULL DEFAULT  
nextval('discretecharstate_id_sequence'::regclass),
   "version" integer,
   transcost double precision,
   state1_id bigint,
   state2_id bigint,
   stepmatrix_id bigint NOT NULL,
   CONSTRAINT stepmatrixelement_pkey PRIMARY KEY (discretecharstate_id),
   CONSTRAINT fk891100af6e972a88 FOREIGN KEY (state1_id)
       REFERENCES discretecharstate (discretecharstate_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT fk891100af6e979ee7 FOREIGN KEY (state2_id)
       REFERENCES discretecharstate (discretecharstate_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT fk891100af9e8198e FOREIGN KEY (stepmatrix_id)
       REFERENCES usertype (usertype_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION
)

CREATE TABLE discretecharstate
(
   discretecharstate_id bigint NOT NULL DEFAULT  
nextval('discretecharstate_id_sequence'::regclass),
   "version" integer,
   description character varying(255),
   notes character varying(255),
   symbol character(1),
   phylochar_id bigint NOT NULL,
   stateset_id bigint,
   ancestralstate_id bigint,
   CONSTRAINT discretecharstate_pkey PRIMARY KEY (discretecharstate_id),
   CONSTRAINT fk2eef2802163c67ce FOREIGN KEY (stateset_id)
       REFERENCES stateset (stateset_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT fk2eef2802c7beaafe FOREIGN KEY (ancestralstate_id)
       REFERENCES ancestralstate (ancestralstate_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT fk2eef2802fe41a723 FOREIGN KEY (phylochar_id)
       REFERENCES phylochar (phylochar_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION
)

Re: [Treebase-devel] unusual PK in stepmatrixelement

[Rutger V. <rut...@gm...>]

We actually never use stepmatrices, so this could very well be an
unnoticed cut-and-paste error.

On Tuesday, February 2, 2010, Vladimir Gapeyev
<vla...@du...> wrote:
> Table stepmatrixelement has an unusual name and definition of its primary key: it appears to have been copied from another table, discretecharstate.  (Definitions of both are below.)Is this indeed a cut-and-paste error?
> --Vladimir
>
> CREATE TABLE stepmatrixelement(  discretecharstate_id bigint NOT NULL DEFAULT nextval('discretecharstate_id_sequence'::regclass),  "version" integer,  transcost double precision,  state1_id bigint,  state2_id bigint,  stepmatrix_id bigint NOT NULL,  CONSTRAINT stepmatrixelement_pkey PRIMARY KEY (discretecharstate_id),  CONSTRAINT fk891100af6e972a88 FOREIGN KEY (state1_id)      REFERENCES discretecharstate (discretecharstate_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION,  CONSTRAINT fk891100af6e979ee7 FOREIGN KEY (state2_id)      REFERENCES discretecharstate (discretecharstate_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION,  CONSTRAINT fk891100af9e8198e FOREIGN KEY (stepmatrix_id)      REFERENCES usertype (usertype_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION)
> CREATE TABLE discretecharstate(  discretecharstate_id bigint NOT NULL DEFAULT nextval('discretecharstate_id_sequence'::regclass),  "version" integer,  description character varying(255),  notes character varying(255),  symbol character(1),  phylochar_id bigint NOT NULL,  stateset_id bigint,  ancestralstate_id bigint,  CONSTRAINT discretecharstate_pkey PRIMARY KEY (discretecharstate_id),  CONSTRAINT fk2eef2802163c67ce FOREIGN KEY (stateset_id)      REFERENCES stateset (stateset_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION,  CONSTRAINT fk2eef2802c7beaafe FOREIGN KEY (ancestralstate_id)      REFERENCES ancestralstate (ancestralstate_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION,  CONSTRAINT fk2eef2802fe41a723 FOREIGN KEY (phylochar_id)      REFERENCES phylochar (phylochar_id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION)
>
>

-- 
Dr. Rutger A. Vos
School of Biological Sciences
Philip Lyle Building, Level 4
University of Reading
Reading
RG6 6BX
United Kingdom
Tel: +44 (0) 118 378 7535
http://www.nexml.org
http://rutgervos.blogspot.com