           (
           id                                             NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,
           fk_appshare_application_id                     NUMBER,
+          fk_appshare_schema_id                          NUMBER,
           application_environment                        VARCHAR2(200 BYTE),
           database_schema_name                           VARCHAR2(200 BYTE),
           CONSTRAINT  APPSHARE_APPLICATION_SCHEMAS_PK    PRIMARY KEY (ID)

(make-logins-table)
(make-applications-table)
(make-app-schemas-table)
(make-triggers-table)
(make-log-table)


          (
          id                                               serial NOT NULL,
          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)
