Destinations
Download GeneX Software
Development
Required Software
Suggested Software
Documentation & Help
Troubleshooting
Related Resources
GeneX Development Supported By
 Tracker
- Bugs
( 53 open / 229 total )
- Support Requests
( 0 open / 0 total )
- Patches
( 0 open / 0 total )
- Feature Requests
( 8 open / 70 total )  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: ControlledVocab Table | ||
|---|---|---|
| Table Type | Inherits | Comment |
| VALIDATION | Identifiable | The ControlledVocab table is used to store the vocabularies for the columns of all tables in the DB that are curated |
| Column Information | ||||
|---|---|---|---|---|
| Column Name | Full Name | Data Type | Not NULL | Comment |
| column_name | Column Name | char128 | false | the exact column DB table this term describes |
| cv_pk | Accession Number | serial | false | |
| table_name | Table Name | char128 | false | the DB table this term describes |
| term_string | Term String | char128 | false | |
| vocab_name | Vocabulary Name | char128 | false | the combination of table_name and column_name used to describe the vocab. Explicitly stating this helps map to the XML definition file, as well as identifying all terms from from the same vocab |
| Primary Key Information |
|---|
| Column Name |
| cv_pk |
| Foreign Key Information | |||
|---|---|---|---|
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| Unique Column Information |
|---|
| Column Names |
| table_name column_name term_string |
| vocab_name term_string |
| Index Information | |
|---|---|
| Name | Column Name |
genex-dev@lists.sourceforge.net