CREATE TABLE "SOGINS"."INSOBJECT"
  (    "INSOBJECTID" NUMBER(10,0) NOT NULL ENABLE,
       "ENTITYID" NUMBER(10,0) NOT NULL ENABLE,
       "INSOBJECTTYPEID" NUMBER(10,0),
       "NAME" VARCHAR2(300),
       "AREA" VARCHAR2(300 CHAR),
       "PRODUCEDATE" DATE,
       "MODELID" NUMBER(10,0),
       "NOTE" CLOB,
       "CHARACTERUSES" VARCHAR2(100 CHAR),
       "YEARBUILDING" NUMBER(10,0) DEFAULT 0,
       "YEARCAPREMONT" NUMBER(10,0) DEFAULT 0,
       "SQUARE" NUMBER(25,4),
       "NUMSTOREYS" NUMBER(25,4),
       "STOREY" NUMBER(10,0),
       "BASEMENT" NUMBER(10,0),
       "WALL" NUMBER(10,0),
       "FLOOR" NUMBER(10,0),
       "PARTITION" NUMBER(10,0),
       "HOUSETOP" NUMBER(10,0),
       "DEADWEIGHT" NUMBER(25,4),
       "TYPEAKVATORII" NUMBER(10,0),
       "PEREDVIGENIE" NUMBER(3,0) DEFAULT 0,
       "PORTPRIPISKI" VARCHAR2(50 CHAR),
       "SQUARELIVING" NUMBER(25,4),
       "CEILINGSHEIGHT" NUMBER(25,4),
       "ROOMSNUM" NUMBER(10,0),
       "SQUAREKITCHEN" NUMBER(25,4),
       "ROOMSTYPE" NUMBER(10,0) DEFAULT 2,
       "LAVATORY" NUMBER(10,0) DEFAULT -1,
       "BARS" NUMBER(3,0) DEFAULT 0,
       "BALCONY" VARCHAR2(50 CHAR),
       "FITTEDCUPBOARDS" NUMBER(3,0) DEFAULT 0,
       "ENTRESOL" NUMBER(3,0) DEFAULT 0,
       "STOREROOM" NUMBER(3,0) DEFAULT 0,
       "CHUTE" NUMBER(10,0) DEFAULT (-1),
       "STOVEPLATE" NUMBER(10,0) DEFAULT (-1),
       "PHONE" NUMBER(3,0) DEFAULT 0,
       "CEILINGS" NUMBER(10,0),
       "DOOR" NUMBER(10,0),
       "BUILDINGCONDITION" NUMBER(10,0),
       "NEXTBUILDINGINTERVAL" NUMBER(25,4),
       "BAGGAGE" VARCHAR2(200 CHAR),
       "GLASSSTYLE" NUMBER(10,0) DEFAULT 0,
       "LOADFROMID" NUMBER(10,0),
       "LOADINTOID" NUMBER(10,0),
       "ADDINGSLOADINFO" VARCHAR2(300 CHAR),
       "KINDPACKING" VARCHAR2(200 CHAR),
       "WEIGHT" NUMBER(25,4),
       "SHIPCLASS" VARCHAR2(100 CHAR),
       "SHIPTYPE" VARCHAR2(100 CHAR),
       "NAVIGATIONAREA" VARCHAR2(200 CHAR),
       "MODEL" VARCHAR2(50 CHAR),
       "TRANSPORTKIND" NUMBER(10,0),
       "CLASSID" NUMBER(10,0) DEFAULT 5,
       "GOTOREGISTERCHECK" NUMBER(3,0) DEFAULT 0,
       "OLDID" NUMBER(10,0),
       "RENT" NUMBER(3,0) DEFAULT 0,
       "MARK" VARCHAR2(100 CHAR),
       "MODELPTS" VARCHAR2(50 CHAR),
       "TRANSPORTTYPEID" NUMBER(10,0),
       "TRANSPORTMARKID" NUMBER(10,0),
       "TRANSPORTMODELID" NUMBER(10,0),
       "TRANSPORTCATEGORY" VARCHAR2(1 CHAR),
       "RPSID" NUMBER(10,0),
       "EXPLYEAR" NUMBER(10,0),
       "TRANSPORTCATEGORYID" NUMBER(10,0),
       "ISDAMAGES" NUMBER(3,0) DEFAULT 0,
       "TECHNOBLOCK" NUMBER(3,0) DEFAULT 0,
       "TRANSPORTCOST" NUMBER(25,4),
       "ENDIVISION_ORGSTRUCTUREID" NUMBER(10,0) DEFAULT 28,
       "WEBMADE" NUMBER(10,0) DEFAULT 0,
       "EXTERNALID" NUMBER(10,0),
       "VIN" VARCHAR2(50 CHAR),
       "ADDRESS_LV" VARCHAR2(300 CHAR),
       "BODYNUMBER_LV" VARCHAR2(50 CHAR),
       "CAPACITY_LV" NUMBER(25,4),
       "CHASSISNUMBER_LV" VARCHAR2(50 CHAR),
       "COLOR_LV" VARCHAR2(50 CHAR),
       "ENGINENUMBER_LV" VARCHAR2(50 CHAR),
       "FLAG_LV" NUMBER(10,0),
       "FOREIGNNUMBER_LV" NUMBER(3,0) DEFAULT 0,
       "MAXWEIGHT_LV" NUMBER(25,4),
       "OPERATINGMODE_LV" NUMBER(3,0) DEFAULT 0,
       "OWNERID_LV" NUMBER(10,0),
       "PLACECOUNT_LV" NUMBER(10,0),
       "REGCERTIFDATE_LV" DATE,
       "REGCERTIFDISTRIB_LV" VARCHAR2(50 CHAR),
       "REGCERTIFNUMBER_LV" VARCHAR2(50 CHAR),
       "REGCERTIFSERIES_LV" VARCHAR2(50 CHAR),
       "SQUARE_LV" NUMBER(25,4),
       "STATENUMBER_LV" VARCHAR2(50 CHAR),
       "TONNAGE_LV" NUMBER(14,4),
       "TRANSPORTPURPOSEID_LV" NUMBER(10,0),
       "TRANZITNUMBER_LV" NUMBER(3,0) DEFAULT 0,
       "WEIGHT_LV" NUMBER(25,4),
       "CLASSKBM_LV" NUMBER(10,0),
       "OWNERADDRESSID_LV" NUMBER(10,0),
       "OWNERCERTIFICATEID_LV" NUMBER(10,0),
       "FILIALEXIST_LV" NUMBER(3,0) DEFAULT 0,
       "TEMPREGEXIST_LV" NUMBER(3,0) DEFAULT 0,
       "TRANSPORTTYPEID_LV" NUMBER(10,0),
       "VIOLATIONS_LV" NUMBER(3,0) DEFAULT 0,
       "FOREIGNTS_LV" NUMBER(3,0) DEFAULT 0,
       "POWERWATT_LV" NUMBER(25,4),
       "INS_PH_MOB_LV" VARCHAR2(50 CHAR),
       "INS_PH_WORK_LV" VARCHAR2(50 CHAR),
       "INS_FAX_LV" VARCHAR2(50 CHAR),
       "INS_EMAIL_LV" VARCHAR2(50 CHAR),
       "INS_PH_HOME_LV" VARCHAR2(50 CHAR),
       "DOCSERIES_LV" VARCHAR2(50 CHAR),
       "DOCNUMBER_LV" VARCHAR2(50 CHAR),
       "DOCDATE_LV" DATE,
       "REGCERTIFTYPEDOC_LV" VARCHAR2(60 CHAR),
       "REGCERTIFTYPEDOCID_LV" NUMBER(10,0),
       "ADDRESSID" NUMBER(10,0),
       "DOCTS" NUMBER(10,0),
       "ISTESTDRIVEMODE" NUMBER(3,0) DEFAULT 0,
       "ISTAXIMODE" NUMBER(3,0) DEFAULT 0,
       "ISHIREMODE" NUMBER(3,0) DEFAULT 0,
       "EXPLMONTH" NUMBER(2,0),
       "TYPEINTERIOR" NUMBER(3,0),
       "ENGENEREQUIPMENT" NUMBER(3,0),
       "MILEAGE_LV" NUMBER(10,0),
       "EXPDATE" DATE,
       "EXPLDAY" NUMBER(2,0),
       "CONTEXT_HASH" VARCHAR2(4000),
        CONSTRAINT "PK_INSOBJECT" PRIMARY KEY ("INSOBJECTID")
 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 TABLESPACE "DIASOFT_IDX"  ENABLE,
        CONSTRAINT "FKEN_15329_2598" FOREIGN KEY ("DOCTS")
         REFERENCES "SOGINS"."DOCTS" ("DOCTSID") ENABLE,
        CONSTRAINT "FKEN_14268_2336" FOREIGN KEY ("REGCERTIFTYPEDOCID_LV")
         REFERENCES "SOGINS"."TSPASSPORTTYPE" ("TSPASSPORTTYPEID") ENABLE,
        CONSTRAINT "FKEN_14275_1822" FOREIGN KEY ("CLASSKBM_LV")
         REFERENCES "SOGINS"."KBM" ("KBM_ID") ENABLE,
        CONSTRAINT "FKEN_14302_1012" FOREIGN KEY ("FLAG_LV")
         REFERENCES "SOGINS"."AREA" ("AREAID") ENABLE,
        CONSTRAINT "FKEN_14304_1718" FOREIGN KEY ("TRANSPORTPURPOSEID_LV")
         REFERENCES "SOGINS"."TRANSPORTPURPOSE" ("TRASPORTPURPOSEID") ENABLE,
        CONSTRAINT "FKEN_4442_1022" FOREIGN KEY ("DOOR")
         REFERENCES "SOGINS"."MISCREF" ("MISCREFID") ENABLE,
        CONSTRAINT "FKEN_7558_1435" FOREIGN KEY ("TRANSPORTMARKID")
         REFERENCES "SOGINS"."TRANSPORTMARK" ("TRANSPORTMARKID") ENABLE,
        CONSTRAINT "FKEN_4238_1022" FOREIGN KEY ("BASEMENT")
         REFERENCES "SOGINS"."MISCREF" ("MISCREFID") ENABLE,
        CONSTRAINT "FKEN_3549_1435" FOREIGN KEY ("MODELID")
         REFERENCES "SOGINS"."TRANSPORTMARK" ("TRANSPORTMARKID") ENABLE,
        CONSTRAINT "FKEN_7559_1436" FOREIGN KEY ("TRANSPORTMODELID")
         REFERENCES "SOGINS"."TRANSPORTMODEL" ("TRANSPORTMODELID") ENABLE,
        CONSTRAINT "FKEN_8354_1973" FOREIGN KEY ("RPSID")
         REFERENCES "SOGINS"."REFERENCEKRPC" ("REFERENCEKRPCID") ENABLE,
        CONSTRAINT "FKEN_4419_1022" FOREIGN KEY ("TYPEAKVATORII")
         REFERENCES "SOGINS"."MISCREF" ("MISCREFID") ENABLE,
        CONSTRAINT "FKEN_14300_1271" FOREIGN KEY ("OWNERCERTIFICATEID_LV")
         REFERENCES "SOGINS"."PASSPORTFACE" ("PASSPORTFACEID") ENABLE,
        CONSTRAINT "FKEN_14267_1031" FOREIGN KEY ("OWNERADDRESSID_LV")
         REFERENCES "SOGINS"."ADDRESS" ("ADDRESSID") ENABLE,
        CONSTRAINT "FKEN_14469_1031" FOREIGN KEY ("ADDRESSID")
         REFERENCES "SOGINS"."ADDRESS" ("ADDRESSID") ENABLE,
        CONSTRAINT "FKEN_14269_1000" FOREIGN KEY ("OWNERID_LV")
         REFERENCES "SOGINS"."FACE" ("FACEID") ENABLE NOVALIDATE
  ) SEGMENT CREATION IMMEDIATE
 PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS NOLOGGING
 STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645
 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 TABLESPACE "DIASOFT_DAT"
LOB ("NOTE") STORE AS BASICFILE (
 TABLESPACE "DIASOFT_LOB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
 NOCACHE LOGGING
 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))