-- d:\orant\bin\FPDdbase.con
--
-- Generated for Oracle 8 on Thu Aug 16  09:11:45 2001 by Server Generator 6.0.3.3.0
  
PROMPT Creating Primary Key on 'ALARMS'
ALTER TABLE ALARMS
 ADD CONSTRAINT AL_PK PRIMARY KEY 
  (ID)
/

PROMPT Creating Primary Key on 'POTS'
ALTER TABLE POTS
 ADD CONSTRAINT PT_PK PRIMARY KEY 
  (NAME
  ,TIME)
/
 
PROMPT Creating Check Constraints on 'ALARMS'
ALTER TABLE ALARMS
 ADD CONSTRAINT AVCON_101657_CABLE_000 CHECK (CABLE IN ('YES', 'NO', 'NA'))
 ADD CONSTRAINT AVCON_101657_DRIVE_000 CHECK (DRIVER IN ('YES', 'NO', 'NA'))
 ADD CONSTRAINT AVCON_101657_MECHA_000 CHECK (MECHANICAL IN ('YES', 'NO', 'NA'))
 ADD CONSTRAINT AVCON_101657_SMOKE_000 CHECK (SMOKE IN ('YES', 'NO', 'NA'))
/
 
PROMPT Creating Foreign Keys on 'ALARMS'
ALTER TABLE ALARMS ADD CONSTRAINT
 AL_PT_FK FOREIGN KEY 
  (NAME
  ,TIME) REFERENCES POTS
  (NAME
  ,TIME)
/