CREATE TABLE  "SDELKA" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"NEDVIJ_ID" NUMBER, 
	"TIP_SDELKI_ID" NUMBER, 
	"DATE_SD" DATE, 
	"SUMMA_SD" VARCHAR2(50), 
	"PORYID_PAY" VARCHAR2(50), 
	"COMMISSION" VARCHAR2(50), 
	"RIELT_ID" NUMBER, 
	 CONSTRAINT "SDELKA_PK" PRIMARY KEY ("ID") ENABLE
   ) ;

CREATE TABLE  "STORONA_SDELKI" 
   (	"SDELKA_ID" NUMBER, 
	"CONTRACTOR_ID" NUMBER, 
	"TIP_STORONI_ID" NUMBER
   ) ;ALTER TABLE  "STORONA_SDELKI" ADD CONSTRAINT "TC_TYPEN4" FOREIGN KEY ("SDELKA_ID")
	  REFERENCES  "SDELKA" ("ID") ENABLE;ALTER TABLE  "STORONA_SDELKI" ADD CONSTRAINT "TC_TYPEN5" FOREIGN KEY ("CONTRACTOR_ID")
	  REFERENCES  "СONTRACTOR" ("ID") ENABLE;

 CREATE SEQUENCE   "SDELKA_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE ;

CREATE SEQUENCE   "TIP_STORONI_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

CREATE USER ффффф
      IDENTIFIED BY ввввввввввв
      DEFAULT TABLESPACE users
      TEMPORARY TABLESPACE temp
/
grant connect, dba to ффффф
/

CREATE OR REPLACE TRIGGER  "BI_SDELKA" 
  before insert on "SDELKA"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "SDELKA_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_SDELKA" ENABLE;
/
ALTER TRIGGER  "BI_SDELKA" ENABLE;

CREATE TABLE  "STORONA_SDELKI" 
   (	"SDELKA_ID" NUMBER, 
	"CONTRACTOR_ID" NUMBER, 
	"TIP_STORONI_ID" NUMBER
   ) ;ALTER TABLE  "STORONA_SDELKI" ADD CONSTRAINT "TC_TYPEN4" FOREIGN KEY ("SDELKA_ID")
	  REFERENCES  "SDELKA" ("ID") ENABLE;ALTER TABLE  "STORONA_SDELKI" ADD CONSTRAINT "TC_TYPEN5" FOREIGN KEY ("CONTRACTOR_ID")
	  REFERENCES  "СONTRACTOR" ("ID") ENABLE;

	  
	  CREATE TABLE  "TIP_STORONI" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"TIP_STR" VARCHAR2(100), 
	 CONSTRAINT "TIP_STORONI_PK" PRIMARY KEY ("ID") ENABLE
   ) ;ALTER TABLE  "TIP_STORONI" ADD CONSTRAINT "TIP_STORONI_CON" FOREIGN KEY ("ID")
	  REFERENCES  "TIP_STORONI" ("ID") ENABLE;

CREATE TABLE  "SDELKA" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"NEDVIJ_ID" NUMBER, 
	"TIP_SDELKI_ID" NUMBER, 
	"DATE_SD" DATE, 
	"SUMMA_SD" VARCHAR2(50), 
	"PORYID_PAY" VARCHAR2(50), 
	"COMMISSION" VARCHAR2(50), 
	"RIELT_ID" NUMBER, 
	 CONSTRAINT "SDELKA_PK" PRIMARY KEY ("ID") ENABLE
   ) ;

CREATE OR REPLACE TRIGGER  "BI_SDELKA" 
  before insert on "SDELKA"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "SDELKA_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end; 



/
ALTER TRIGGER  "BI_SDELKA" ENABLE;

CREATE SEQUENCE   "SDELKA_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE ;

CREATE TABLE  "STORONA_SDELKI" 
   (	"SDELKA_ID" NUMBER NOT NULL ENABLE, 
	"CONTRACTOR_ID" NUMBER NOT NULL ENABLE, 
	"TIP_STORONI_ID" NUMBER, 
	 CONSTRAINT "STORONA_SDELKI_PK" PRIMARY KEY ("SDELKA_ID") ENABLE
   ) ;

CREATE OR REPLACE TRIGGER  "BI_STORONA_SDELKI" 
  before insert on "STORONA_SDELKI"               
  for each row  
begin   
  if :NEW."SDELKA_ID" is null then 
    select "STORONA_SDELKI_SEQ".nextval into :NEW."SDELKA_ID" from dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_STORONA_SDELKI" ENABLE;


CREATE SEQUENCE   "STORONA_SDELKI_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

CREATE TABLE  "TIP_STORONI" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"TIP_STR" VARCHAR2(100), 
	 CONSTRAINT "TIP_STORONI_PK" PRIMARY KEY ("ID") ENABLE
   ) ;

CREATE OR REPLACE TRIGGER  "BI_TIP_STORONI" 
  before insert on "TIP_STORONI"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "TIP_STORONI1_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_TIP_STORONI" ENABLE;


 CREATE SEQUENCE   "TIP_STORONI1_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;