GUS Schema >> TESS::SbcgAnnotationFilterTerm

This table contains comparisons between annotation attributes and constant values. These are linked to a TESS.SbcgRecogAnnotationFilter to make a complete filter.

column nulls? type description
SCBG_ANNOTATION_FILTER_TERM_ID no NUMBER(12,0) Primary key. Edit
SBCG_ANNOTATION_FILTER_ID no TESS::SbcgAnnotationFilter (NUMBER(12,0) )A link to a TESS::SbcgAnnotationFilter that will use this filter term. Edit
ORDINAL no NUMBER(4,0) Position in list of comparisions. Edit
ATTRIBUTE_NAME no STRING(32) Comparison should be made to this attribute of the annotation. Edit
SBCG_COMPARISON_TYPE_ID no TESS::SbcgComparisonType (NUMBER(12,0) )Type of comparison to perform. Edit
IS_NUMERIC_VALUE no NUMBER(1,0) True when the value is numeric. Edit
CONSTANT_VALUE no STRING(255) Compare to this constant value. 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: