GeneX @ SourceForge

Destinations

GeneX Release Home

GeneX Dev Home

Download GeneX Software

GeneX Server SW

Development

GeneX development page

Join the GeneX mailing list

Weekly Status Updates

Review the GeneX development timeline: 2002

Source Code Repository

G2G: data exchange

SourceForge Project Page

Required Software

Apache Web Server

Perl

Required Perl modules

Suggested Software

R stats pkg

Documentation & Help

Server Installation

Genex-2 Schema Tables

GeneX Mailing Lists

CyberT Help

Troubleshooting

SourceForge BugTracking

Related Resources

Other Tools Page

Leming Shi's
DNA Microarray site

Gene-Arrays Listserv
by Subscription
or by egroups

David Lanes's Stats Books
and Tutorials

GeneX Development Supported By

Tracker

- Bugs ( 53 open / 229 total )
Bug Tracking System

- Support Requests ( 0 open / 0 total )
Tech Support Tracking System

- Patches ( 0 open / 0 total )
Patch Tracking System

- Feature Requests ( 8 open / 70 total )
Feature Request Tracking System

Forums ( 3 messages in 3 forums )

Doc Manager

Mailing Lists ( 5 mailing lists )

Screenshots

Task Manager
- SourceForge.net WWW Site
- Genex Server
- Documentation

CVS Tree ( 2502 commits, 834 adds )

Released Files

GeneX-2.0 DB: TableDef Table

GeneX-2.0 DB: TableDef Table
Table Type	Inherits	Comment
DATA	none	The TableDef table defines information about individual tables in the DB, such as their abbreviated names and their API names.

Column Information
Column Name	Full Name	Data Type	Not NULL	Comment
api_name	API Name	char32	true	The name of the table in the programming language API, this usually contains mixed case, and will often remove underscores, etc.
audit_fk	Audit	int	true	The audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger.
description	Description	text	false
is_abstract	Is Abstract	bool	true	Whether this table is an abstract table that holds no real data, but instead provides an inheritance template.
lc_table_name	Lowercase Table Name	char32	true	The name of the table in all lowercase letters
table_name	Table Name	char32	true	The name of the table
td_pk	Accession Number	serial	false

Primary Key Information
Column Name
td_pk

Foreign Key Information
Column Name	Foreign Table	Primary Key in Foreign Table	Foreign Key Type
audit_fk	Audit	audit_pk	ONE_TO_ONE

Unique Column Information
Column Names

Index Information
Name	Column Name