From GMOD

Contents 1 Introduction 2 Tables 2.1 Table: wwwuser 2.2 Table: wwwuser_cvterm 2.3 Table: wwwuser_expression 2.4 Table: wwwuser_feature 2.5 Table: wwwuser_genotype 2.6 Table: wwwuser_organism 2.7 Table: wwwuser_phenotype 2.8 Table: wwwuser_project 2.9 Table: wwwuser_pub 2.10 Table: wwwuserrelationship

[edit] Introduction

This page or section needs to be edited. Please help improve this page with your revisions or additions.

[edit] Tables

[edit] 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:

• wwwuser_cvterm

• wwwuser_expression

• wwwuser_feature

• wwwuser_genotype

• wwwuser_organism

• wwwuser_phenotype

• wwwuser_project

• wwwuser_pub

• wwwuserrelationship

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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

---

[edit] 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