GUS Schema >> SRes::Disease

Describes a disease process

column nulls? type description
DISEASE_ID no NUMBER(4,0) Primary key Edit
PARENT_ID SRes::Disease (NUMBER(4,0) )Allows for the hierarchical structure of this table by indicating the primary key (disease_id) of the row in this same table that is one step closer to the root of the tree. Edit
SOURCE STRING(255) Indicates the source of the disease name and definition. For example, "CDC ICD-9 (KEGG version)" Edit
NAME no STRING(255) The name of the disease as determined by the source. For example, "Isolated tracheal or broncial tuberculosis". Edit
DEFINITION STRING(500) Optional definition of the disease. Edit
LEVEL_1 STRING(255) Each level contains the name attribute of that level of the hierarchy. The highest level that is entered should represent the name of the selected row. For example, disease name Isolated tracheal or broncial tuberculosis has level_1 = INFECTIOUS AND PARASITIC DISEASES and level_2 = TUBERCULOSIS Edit
LEVEL_2 STRING(255) Edit
LEVEL_3 STRING(255) Edit
LEVEL_4 STRING(255) Edit
LEVEL_5 STRING(255) 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 Activities
     TESS::ActivityConditions
Disease Vocabulary
     SRes::Disease

Subclasses: