GUS Schema >> TESS::Moiety

A base class for inheritance.

column nulls? type description
MOIETY_ID no NUMBER(12,0) Primary key. Edit
SUBCLASS_VIEW no STRING(32) Edit
TYPE_NAME no STRING(32) Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(12,0) ) Edit
SOURCE_ID STRING(32) Edit
NAME STRING(255) Edit
TAXON_ID no SRes::Taxon (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 Moieties
     TESS::MoietyInstance
     TESS::MoietyMember
     TESS::MoietySynonym
Regulatory Activities
     TESS::Activity

Subclasses:

TESS::MoietyHeteroDimer
TESS::MoietyMonomer
TESS::MoietyMultimer
TESS::MoietyComplex