GUS Schema >> TESS::ActivityConditions

Storing the conditions in the activity takes place. The links in this table are to be interpreted as logical conjunctions, i.e., all are true simultaneously. If an activity takes place under multiple conditions, e.g., in multiple organs, then each organ would have a record in this table.

column nulls? type description
ACTIVITY_CONDITIONS_ID no NUMBER(12,0) Primary key. Edit
ACTIVITY_ID no TESS::Activity (NUMBER(12,0) )A link to the Activity. Edit
REVIEW_STATUS_ID SRes::ReviewStatus (NUMBER(12,0) )To what extent has this been reviewed? Edit
TAXON_ID SRes::Taxon (NUMBER(12,0) )In what species? Edit
ANATOMY_ID SRes::Anatomy (NUMBER(12,0) )Where in the does 'body' does this activity take place? Edit
CELL_TYPE_ID SRes::Anatomy (NUMBER(12,0) )In what cell type? Edit
DEVELOPMENTAL_STAGE_ID SRes::DevelopmentalStage (NUMBER(12,0) )At what developmental stage? Edit
DISEASE_ID SRes::Disease (NUMBER(12,0) )In what disease state? Edit
PHENOTYPE_ID SRes::Phenotype (NUMBER(12,0) )In what phenotype? 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: