GUS Schema >> TESS::ActivityModel

This table connects a model to an activity. Rows in this table assert that the model describes an arrangement of DNA bases or features that is believed to be at least correlated with the activity taking place at locations in sequence that match the model.

For example, a row in this table might link a DNABinding activity to a weight matrix model of a transcription factor binding site. If a match is found to that weight matrix in genomic sequence, then it may be inferred (with some level of reliability) that the transcription factor will bind there.

Since TESS.Activity and TESS.Model are views with many subclasses, this table serves to link any kind of model to any kind of activity.

column nulls? type description
ACTIVITY_MODEL_ID no NUMBER(12,0) Primary key Edit
ACTIVITY_ID no TESS::Activity (NUMBER(12,0) ) This is the gene regulation-related activity the model is supposed to describe. Edit
MODEL_ID no TESS::Model (NUMBER(12,0) ) This is the model of features of DNA or other sequence that are indicative of the activity. 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:

Subclasses: