create table DEVELOPER.GEO_POINT  (
   ID_GEO_POINT         NUMBER( 14 )                      not null, --primary key
   ID_POINT_FROM        NUMBER( 14 )                      not null, --внешний ключ, который приходит из дочерней таблицы
   constraint XPKGEO_POINT primary key (ID_GEO_POINT)
         using index
       pctfree  10 
       initrans  2 
       storage
       (
           initial 64K
           minextents  1 
           maxextents unlimited
       )
       tablespace USERS
        logging
)
pctfree  10 
initrans  1 
storage
(
    initial 64K
    minextents  1 
    maxextents unlimited
)
tablespace USERS
logging
monitoring
 noparallel;

alter table DEVELOPER.GEO_POINT
   add constraint R_1199_GEO_POINT_ID_DIRECT_POI foreign key (ID_DIRECT_POINT)
      references DEVELOPER.SURV_POINT (ID_SURV_POINT)
      on delete set null
      not deferrable;

alter table DEVELOPER.GEO_POINT
   add constraint FK_GEO_POIN_REFERENCE_SURV_POI foreign key (ID_POINT_FROM)
      references DEVELOPER.SURV_POINT (ID_SURV_POINT);

create table DEVELOPER.SURV_POINT  (
   ID_SURV_POINT        NUMBER( 14 )                      not null,
   constraint XPKSURVEY_POINTS primary key (ID_SURV_POINT)
         using index
       pctfree  10 
       initrans  2 
       storage
       (
           initial 64K
           minextents  1 
           maxextents unlimited
       )
       tablespace USERS
        logging
)
pctfree  10 
initrans  1 
storage
(
    initial 64K
    minextents  1 
    maxextents unlimited
)
tablespace USERS
logging
monitoring
 noparallel;

alter table DEVELOPER.SURV_POINT
   add constraint R_1030_SURV_POINTS_ID_SURV_POI foreign key (ID_SURV_POINT)
      references DEVELOPER.GEO_POINT (ID_GEO_POINT)
      not deferrable;