GUS Schema >> TESS::MoietyComplex (subclass of TESS::Moiety )

A generic complex class. There can be any number of members in the complex.

Light yellow rows indicate columns provided from the superclass.

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
NUMBER_OF_MEMBERS NUMBER(12,0) This stores the number of members in the complex. Number is unknown or not relevant if this is NULL. Edit

Child tables:

Subclasses: