alter table ACCOUNT add constraint FK_ACCOUNT_REFERENCE_BUILDING foreign key (ACCOUNTID)
      references BUILDING (BUILDINGID) on delete restrict on update restrict;

alter table BILL add constraint FK_BILL_REFERENCE_BUILDING foreign key (BUILDINGEXPENSEID)
      references BUILDINGEXPENSE (BUILDINGEXPENSEID) on delete restrict on update restrict;

alter table BUILDINGEXPENSE add constraint FK_BUILDING_REFERENCE_BUILDING foreign key (BUILDINGID)
      references BUILDING (BUILDINGID) on delete restrict on update restrict;

alter table BUILDINGEXPENSE add constraint FK_BUILDING_REFERENCE_EXPENSE foreign key (EXPENSEID)
      references EXPENSE (EXPENSEID) on delete restrict on update restrict;

alter table BUILDINGEXPENSE add constraint FK_BUILDING_REFERENCE_FREQUENC foreign key (FREQUENCYID)
      references FREQUENCY (FREQUENCYID) on delete restrict on update restrict;

alter table BUILDINGEXPENSE add constraint FK_BUILDING_REFERENCE_USER foreign key (SETTERID)
      references USER (USERID) on delete restrict on update restrict;

alter table EXPENSE add constraint FK_EXPENSE_REFERENCE_USER foreign key (USERID)
      references USER (USERID) on delete restrict on update restrict;

alter table MANAGES add constraint FK_MANAGES_REFERENCE_USER foreign key (ID)
      references USER (USERID) on delete restrict on update restrict;

alter table MANAGES add constraint FK_MANAGES_REFERENCE_BUILDING foreign key (BUILDINGID)
      references BUILDING (BUILDINGID) on delete restrict on update restrict;

alter table OCCUPIES add constraint FK_OCCUPIES_REFERENCE_USER foreign key (USERID)
      references USER (USERID) on delete restrict on update restrict;

alter table OCCUPIES add constraint FK_OCCUPIES_REFERENCE_UNIT foreign key (UNITID)
      references UNIT (UNITID) on delete restrict on update restrict;

alter table TRANSACTION add constraint FK_TRANSACT_REFERENCE_UNITACCO foreign key (UNITACCOUNTID)
      references UNITACCOUNT (UNITACCOUNTID) on delete restrict on update restrict;

alter table TRANSACTION add constraint FK_TRANSACT_REFERENCE_USER foreign key (USERID)
      references USER (USERID) on delete restrict on update restrict;

alter table TRANSACTION add constraint FK_TRANSACT_REFERENCE_UNITBILL foreign key (UNITBILLID)
      references UNITBILL (UNITBILLID) on delete restrict on update restrict;

alter table UNIT add constraint FK_UNIT_REFERENCE_BUILDING foreign key (BUILDINGID)
      references BUILDING (BUILDINGID) on delete restrict on update restrict;

alter table UNIT add constraint FK_UNIT_REFERENCE_UNITSTAT foreign key (UNITSTATUSID)
      references UNITSTATUS (UNITSTATUSID) on delete restrict on update restrict;

alter table UNIT add constraint FK_UNIT_REFERENCE_UNITTYPE foreign key (UNITTYPEID)
      references UNITTYPE (UNITTYPEID) on delete restrict on update restrict;

alter table UNITACCOUNT add constraint FK_UNITACCO_REFERENCE_ACCOUNT foreign key (BUILDINGID)
      references ACCOUNT (ACCOUNTID) on delete restrict on update restrict;

alter table UNITACCOUNT add constraint FK_UNITACCO_REFERENCE_UNIT foreign key (UNITID)
      references UNIT (UNITID) on delete restrict on update restrict;

alter table UNITBILL add constraint FK_UNITBILL_REFERENCE_BILL foreign key (BILLID)
      references BILL (BILLID) on delete restrict on update restrict;

alter table UNITBILL add constraint FK_UNITBILL_REFERENCE_UNIT foreign key (UNITID)
      references UNIT (UNITID) on delete restrict on update restrict;

alter table USER add constraint FK_USER_REFERENCE_USERTYPE foreign key (USERTYPEID)
      references USERTYPE (USERTYPEID) on delete restrict on update restrict;