CREATE TABLE OBSERVER (
    OBS_NAME    	VARCHAR2(20)    NOT NULL,
    OBS_AGE    		NUMBER(3)		NOT NULL,
					CHECK (OBS_AGE BETWEEN 001 AND 115),
    PRIMARY KEY    (OBS_NAME)
	);
	CREATE INDEX observer_age ON OBSERVER(OBS_AGE);




CREATE TABLE INTERACTION (
    INT_ID    	NUMBER(7,0)    	 NOT NULL,
    INT_OBSBEHAV    VARCHAR2(2000)    NOT NULL,
	INT_ANIBEHAV    VARCHAR2(2000)    NOT NULL,
    PRIMARY KEY    (INT_ID)
);

COMMIT;