/*==============================================================*/ 
 /* Database name:  ObjectOrientedModel_1                        */ 
 /* DBMS name:      Microsoft SQL Server 2000                    */ 
 /* Created on:     14.09.2004 11:29:41                          */ 
 /*==============================================================*/ 


alter table банк
   drop constraint FK_БАНК_GENERALIZ_ЮРИК
go


alter table физик
   drop constraint FK_ФИЗИК_GENERALIZ_КЛИЕНТ
go


alter table юрик
   drop constraint FK_ЮРИК_GENERALIZ_КЛИЕНТ
go


if exists (select  1 
            from  sysobjects
           where  id = object_id('банк')
            and   type = 'U')
   drop table банк
go


if exists (select  1 
            from  sysobjects
           where  id = object_id('клиент')
            and   type = 'U')
   drop table клиент
go


if exists (select  1 
            from  sysobjects
           where  id = object_id('физик')
            and   type = 'U')
   drop table физик
go


if exists (select  1 
            from  sysobjects
           where  id = object_id('юрик')
            and   type = 'U')
   drop table юрик
go


 /*==============================================================*/ 
 /* Table: банк                                                  */ 
 /*==============================================================*/ 
create table банк (
   клиент_id            int                  not null,
   бик                  int                  null,
   constraint PK_БАНК primary key  (клиент_id)
)
go


 /*==============================================================*/ 
 /* Table: клиент                                                */ 
 /*==============================================================*/ 
create table клиент (
   клиент_id            int                  not null,
   имя                  int                  null,
   инн                  int                  null,
   огрн                 int                  null,
   constraint PK_КЛИЕНТ primary key  (клиент_id)
)
go


 /*==============================================================*/ 
 /* Table: физик                                                 */ 
 /*==============================================================*/ 
create table физик (
   клиент_id            int                  not null,
   паспорт              int                  null,
   constraint PK_ФИЗИК primary key  (клиент_id)
)
go


 /*==============================================================*/ 
 /* Table: юрик                                                  */ 
 /*==============================================================*/ 
create table юрик (
   клиент_id            int                  not null,
   окато                int                  null,
   окпо                 int                  null,
   constraint PK_ЮРИК primary key  (клиент_id)
)
go


alter table банк
   add constraint FK_БАНК_GENERALIZ_ЮРИК foreign key (клиент_id)
      references юрик (клиент_id)
go


alter table физик
   add constraint FK_ФИЗИК_GENERALIZ_КЛИЕНТ foreign key (клиент_id)
      references клиент (клиент_id)
go


alter table юрик
   add constraint FK_ЮРИК_GENERALIZ_КЛИЕНТ foreign key (клиент_id)
      references клиент (клиент_id)
go