GUS Schema >> DoTS::Complex

Table used to specify a complex. A complex consists of many ComplexComponents

column nulls? type description
COMPLEX_ID no NUMBER(10,0) Primary key, used to uniquely identify a complex Edit
NAME STRING(80) Name of the complex Edit
DESCRIPTION STRING(255) Description of the complex Edit
COMPLEX_TYPE_ID no DoTS::ComplexType (NUMBER(10,0) )Foreign key to ComplexType; specifies the type of the complex Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) )Foreign key to SRes::ExternalDatabaseRelease; this attribute is used when the complex has been loaded from an external source Edit
SOURCE_ID STRING(32) The primary identifier of the complex in the external database specified by external_database_release_id 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:

Interaction
     DoTS::ComplexAnatomy
     DoTS::ComplexComponent

Subclasses: