           (
           id                                               serial NOT NULL,
           fk_appshare_publisher_id                         integer,
-          application_environment                          character varying,
           database_schema_name                             character varying,
           CONSTRAINT appshare_schemas_pkey    PRIMARY KEY (id)
           );

          fk_appshare_application_id                       integer,
          fk_appshare_schema_id                            integer,
          application_environment                          character varying,
          database_schema_name                             character varying,
          CONSTRAINT appshare_applications_schemas_pkey    PRIMARY KEY (id)
          );
          "


          (
          id                                             NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,
          fk_appshare_publisher_id                       NUMBER,
          database_schema_name                           VARCHAR2(200 BYTE),
          CONSTRAINT  APPSHARE_SCHEMAS_PK    PRIMARY KEY (ID)
          )")
