-- Generated by Oracle SQL Developer Data Modeler 3.1.3.706
--   at:        2013-12-22 17:43:16 CET
--   site:      Oracle Database 10g
--   type:      Oracle Database 10g

CREATE TABLE HELLO 
    ( 
     HELLO_ID NUMBER (20)  NOT NULL , 
     HELLO_DESC VARCHAR2 (30 BYTE) , 
     DESCRIPTION VARCHAR2 (20 BYTE) 
    ) 
;


CREATE UNIQUE INDEX SH.HELLO_PK ON HELLO 
    ( 
     HELLO_ID ASC 
    ) 
;

ALTER TABLE HELLO 
    ADD CONSTRAINT HELLO_PK PRIMARY KEY ( HELLO_ID ) 
    USING INDEX HELLO_PK ;



CREATE TABLE HELLO_CAT 
    ( 
     CAT_DESC VARCHAR2 (30 BYTE)  NOT NULL , 
     HELLO_ID NUMBER (20)  NOT NULL 
    ) 
	;


CREATE UNIQUE INDEX SH.HELLO_CAT_PK ON HELLO_CAT 
    ( 
     CAT_DESC ASC , 
     HELLO_ID ASC 
    ) 
    ;

ALTER TABLE HELLO_CAT 
    ADD CONSTRAINT HELLO_CAT_PK PRIMARY KEY ( CAT_DESC, HELLO_ID ) 
    USING INDEX HELLO_CAT_PK ;




ALTER TABLE HELLO_CAT 
    ADD CONSTRAINT HELLO_CAT_FK FOREIGN KEY 
    ( 
     HELLO_ID
    ) 
    REFERENCES HELLO 
    ( 
     HELLO_ID
    ) 
;