This is the new server for GMOD.org. Please let us know if you notice anything weird while it's getting broken in.

Chado WWW Module

From GMOD
Jump to: navigation, search

Introduction

This page or section needs to be edited. Please help by editing this page to add your revisions or additions.


Tables

Table: wwwuser

Keep track of WWW users. This may also be useful in an audit module at some point.

wwwuser Structure
F-Key Name Type Description
wwwuser_id serial PRIMARY KEY
username character varying(32) UNIQUE NOT NULL
password character varying(32) NOT NULL
email character varying(128) NOT NULL
profile text

Tables referencing this one via Foreign Key Constraints:



Table: wwwuser_cvterm

Track wwwuser interest in cvterms.

wwwuser_cvterm Structure
F-Key Name Type Description
wwwuser_cvterm_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

cvterm

cvterm_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_expression

Track wwwuser interest in expressions.

wwwuser_expression Structure
F-Key Name Type Description
wwwuser_expression_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

expression

expression_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_feature

Track wwwuser interest in features.

wwwuser_feature Structure
F-Key Name Type Description
wwwuser_feature_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

feature

feature_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_genotype

Track wwwuser interest in genotypes.

wwwuser_genotype Structure
F-Key Name Type Description
wwwuser_genotype_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

genotype

genotype_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_organism

Track wwwuser interest in organisms.

wwwuser_organism Structure
F-Key Name Type Description
wwwuser_organism_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

organism

organism_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_phenotype

Track wwwuser interest in phenotypes.

wwwuser_phenotype Structure
F-Key Name Type Description
wwwuser_phenotype_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

phenotype

phenotype_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_project

Link wwwuser accounts to projects

wwwuser_project Structure
F-Key Name Type Description
wwwuser_project_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

project

project_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuser_pub

Track wwwuser interest in publications.

wwwuser_pub Structure
F-Key Name Type Description
wwwuser_pub_id serial PRIMARY KEY

wwwuser

wwwuser_id integer UNIQUE#1 NOT NULL

pub

pub_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1


Table: wwwuserrelationship

Track wwwuser interest in other wwwusers.

wwwuserrelationship Structure
F-Key Name Type Description
wwwuserrelationship_id serial PRIMARY KEY

wwwuser

objwwwuser_id integer UNIQUE#1 NOT NULL

wwwuser

subjwwwuser_id integer UNIQUE#1 NOT NULL
world_read smallint NOT NULL DEFAULT 1