GUS Schema >> SRes::DevelopmentalStage

Describes the developmental stage of organisms that have such stages

column nulls? type description
DEVELOPMENTAL_STAGE_ID no NUMBER(4,0) Primary key Edit
PARENT_ID SRes::DevelopmentalStage (NUMBER(4,0) )Allows for the hierarchical structure of this table by indicating the primary key (developmental_stage_id) of the row in this same table that is one step closer to the root of the tree. Edit
TAXON_ID SRes::Taxon (NUMBER(12,0) )Foreign key to the SRes::Taxon table indicating the organism to which the developmental stage refers. Edit
NAME STRING(100) The name of the developmental stage as determined by the source. For example, Theiler Stage 12. Edit
SOURCE STRING(255) Indicates the source of the developmental stage name. Example: "Bard et al. An internet-accessible database of mouse developmental anatomy based on a systematic nomenclature. Mechanisms of Development 74:111-120." Edit
DEFINITION STRING(500) Definition of the developmental stage name as determined by the source. For example, the definition of Theiler Stage 12 is: "1-4 somites, allantois extends, 1st brancial arch, heart starts to form, foregut pocket visible, preotic sulcus (at 2-3 somite stage), Days post conception (range): 8 (7.5-8.75 )." Edit
LEVEL_1 STRING(50) 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, trophozoite has level_1 = blood phase and level_2 = trophozoite. Edit
LEVEL_2 STRING(50) Edit
LEVEL_3 STRING(50) 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:

Clones
     DoTS::DevStageLibrary
Regulatory Activities
     TESS::ActivityConditions
Developmental Stage Vocabulary
     SRes::DevelopmentalStage
Phenotype Vocabulary
     SRes::Phenotype

Subclasses: