-- C:\users\oracle\goPath.2003-11.tab
--
-- Generated for Oracle 8.1 on Wed Nov 19  15:31:25 2003 by Server Generator 6.5.69.1.0
 


PROMPT Creating Table 'GO_PATH'
CREATE TABLE GO_PATH
 (GO_PATH_NO NUMBER(10) NOT NULL
 ,ANCESTOR_GOID NUMBER(10) NOT NULL
 ,CHILD_GOID NUMBER(10) NOT NULL
 ,GENERATION NUMBER(2) NOT NULL
 ,ANCESTOR_PATH VARCHAR2(240) NOT NULL
 ,RELATIONSHIP_TYPE VARCHAR2(40)
 )
 PCTUSED 70
 PCTFREE 5
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE DATA2
/

COMMENT ON TABLE GO_PATH IS 'Contains the structure of the Gene Onotology, ie. the parent:child relationships between the terms.'
/

COMMENT ON COLUMN GO_PATH.GO_PATH_NO IS 'Unique identifier for the GO_PATH table; Oracle generated sequence number.'
/

COMMENT ON COLUMN GO_PATH.ANCESTOR_GOID IS 'The GO_ID of the ancestor GO term.'
/

COMMENT ON COLUMN GO_PATH.CHILD_GOID IS 'The GO_ID of the child GO term.'
/

COMMENT ON COLUMN GO_PATH.GENERATION IS 'The number of generations between the parent and child term; for example, for a grandchild:grandparent relationship, the generation = 2.'
/

COMMENT ON COLUMN GO_PATH.ANCESTOR_PATH IS 'A list of all GOIDs corresponding to all the GO terms in between the ancestor and the child, separated by double colons (::).'
/

COMMENT ON COLUMN GO_PATH.RELATIONSHIP_TYPE IS 'A coded value to describe the type of relationship between the parent and child; valid values are "part of" and "is a".'
/

PROMPT Creating Table 'GO'
CREATE TABLE GO
 (GOID NUMBER(10) NOT NULL
 ,GO_TERM VARCHAR2(240) NOT NULL
 ,GO_ASPECT VARCHAR2(40) NOT NULL
 ,GO_DEFINITION VARCHAR2(2000)
 ,DATE_CREATED DATE DEFAULT SYSDATE NOT NULL
 ,CREATED_BY VARCHAR2(12) DEFAULT SUBSTR(USER,1,12) NOT NULL
 )
 PCTUSED 60
 PCTFREE 20
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE DATA2
/

COMMENT ON TABLE GO IS 'Contains terms that comprise the Gene Ontology (GO), not the relationships between them.'
/

COMMENT ON COLUMN GO.GOID IS 'GO number assigned by GO software.'
/

COMMENT ON COLUMN GO.GO_TERM IS 'Term or word in the Gene Ontology.'
/

COMMENT ON COLUMN GO.GO_ASPECT IS 'Aspect of the GO term (coded: function, process, component).'
/

COMMENT ON COLUMN GO.GO_DEFINITION IS 'Definition for the GO term.'
/

COMMENT ON COLUMN GO.DATE_CREATED IS 'Date the record was entered into the database.'
/

COMMENT ON COLUMN GO.CREATED_BY IS 'Userid of the person who entered the record into the database.'
/

-- C:\users\oracle\goPath.2003-11.ind
--
-- Generated for Oracle 8.1 on Wed Nov 19  15:31:26 2003 by Server Generator 6.5.69.1.0
  


PROMPT Creating Index 'GO_CHILD_FK__I'
CREATE INDEX GO_CHILD_FK__I ON GO_PATH
 (CHILD_GOID)
 PCTFREE 5
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE INDEX2
/

PROMPT Creating Index 'GO_ANCESTOR_FK_I'
CREATE INDEX GO_ANCESTOR_FK_I ON GO_PATH
 (ANCESTOR_GOID)
 PCTFREE 5
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE INDEX2
/

-- C:\users\oracle\goPath.2003-11.con
--
-- Generated for Oracle 8.1 on Wed Nov 19  15:31:26 2003 by Server Generator 6.5.69.1.0
  
PROMPT Creating Primary Key on 'GO_PATH'
ALTER TABLE GO_PATH
 ADD (CONSTRAINT GO_PATH_PK PRIMARY KEY 
  (GO_PATH_NO)
 USING INDEX 
 PCTFREE 5
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE INDEX2)
/

PROMPT Creating Primary Key on 'GO'
ALTER TABLE GO
 ADD (CONSTRAINT GO_PK PRIMARY KEY 
  (GOID)
 USING INDEX 
 PCTFREE 5
 STORAGE
 (
   INITIAL 400K
   NEXT 400K
   PCTINCREASE 0
 ) TABLESPACE INDEX1)
/


PROMPT Creating Unique Key on 'GO_PATH'
ALTER TABLE GO_PATH
 ADD (CONSTRAINT GO_PATH_UK UNIQUE 
  (ANCESTOR_PATH
  ,CHILD_GOID)
 USING INDEX 
 PCTFREE 10
 STORAGE
 (
   INITIAL 8M
   NEXT 8M
   PCTINCREASE 0
 ) TABLESPACE INDEX2)
/

PROMPT Creating Unique Key on 'GO'
ALTER TABLE GO
 ADD (CONSTRAINT GO_TERM_ASPECT_UK UNIQUE 
  (GO_TERM
  ,GO_ASPECT)
 USING INDEX 
 PCTFREE 10
 STORAGE
 (
   INITIAL 400K
   NEXT 400K
   PCTINCREASE 0
 ) TABLESPACE INDEX1)
/

  

PROMPT Creating Foreign Key on 'GO_PATH'
ALTER TABLE GO_PATH ADD (CONSTRAINT
 GO_CHILD_FK FOREIGN KEY 
  (CHILD_GOID) REFERENCES GO
  (GOID))
/

PROMPT Creating Foreign Key on 'GO_PATH'
ALTER TABLE GO_PATH ADD (CONSTRAINT
 GO_ANCESTOR_FK FOREIGN KEY 
  (ANCESTOR_GOID) REFERENCES GO
  (GOID))
/


-- C:\users\oracle\goPath.2003-11.sqs
--
-- Generated for Oracle 8.1 on Wed Nov 19  15:31:26 2003 by Server Generator 6.5.69.1.0
 
PROMPT Creating Sequence 'GOPATHNO_SEQ'
CREATE SEQUENCE GOPATHNO_SEQ
 INCREMENT BY 1
 START WITH 1
 NOMAXVALUE
 MINVALUE 1
 NOCYCLE
 NOCACHE
/