GUS Schema >> TESS::Model

This table is a many-to-many link between TESS.Activity and TESS.SbcgGrammar. TRANSFAC will use the same matrix to multiple factors so we are forced to do the same. New models will typically be for a single activity.

column nulls? type description
MODEL_ID no NUMBER(12,0) Edit
SUBCLASS_VIEW no STRING(32) Edit
NAME no STRING(255) Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(12,0) ) Edit
SOURCE_ID STRING(32) Edit
VERSION_STRING STRING(32) Edit
VERSION_DESCRIPTION CLOB Edit
SECONDARY_ID STRING(32) Edit
BEST_PRACTICE_PARAM_GROUP_ID TESS::ParameterGroup (NUMBER(12,0) ) Edit
REVIEW_STATUS_ID SRes::ReviewStatus (NUMBER(12,0) ) Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Regulatory Activities
     TESS::ActivityModel
Models
     TESS::MarkovChainObs
High Volume Genome Annotation
     TESS::PredictedBindingSite
Data Transformations and Analyses
     TESS::ModelResult
     TESS::PredictionResult
Bounded Collection Grammars
     TESS::SbcgAnnotationGuide
     TESS::SbcgNonterminal
     TESS::SbcgProduction
     TESS::SbcgRecognition
     TESS::SbcgStream
Uncategorized
     TESS::SequenceFeature

Subclasses:

TESS::ModelMarkovChain
TESS::ModelSbcgGrammar