ALTER TABLE nodecabinet
  ADD (
    INSERTEDBY  VARCHAR2(255),
    CHANGEDBY   VARCHAR2(255),
	EXTERNAL_CODE    VARCHAR2(255),
    NET_STATUS       VARCHAR2(100),
    SUBNETSTATUS     VARCHAR2(100),
    INSERTDATE  DATE,
    CHANGEDATE  DATE,
    PROVISIONEDDATE  DATE
  );

ALTER TABLE nodeshelf
  ADD (
    INSERTEDBY  VARCHAR2(255),
    CHANGEDBY   VARCHAR2(255),
	EXTERNAL_CODE    VARCHAR2(255),
    NET_STATUS       VARCHAR2(100),
    SUBNETSTATUS     VARCHAR2(100),
    INSERTDATE  DATE,
    CHANGEDATE  DATE,
    PROVISIONEDDATE  DATE
  );
  
  
ALTER TABLE VERTEX
  ADD (
    INSERTEDBY  VARCHAR2(255),
    CHANGEDBY   VARCHAR2(255),
	EXTERNAL_CODE    VARCHAR2(255),
    NET_STATUS       VARCHAR2(100),
    SUBNETSTATUS     VARCHAR2(100),
    INSERTDATE  DATE,
    CHANGEDATE  DATE,
    PROVISIONEDDATE  DATE
  );