Versions Compared

Old Version 11

changes.mady.by.user Petr Jůza

Saved on

compared with

New Version 12

changes.mady.by.user Petr Jůza

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Child pages (Children Display)


Warning

There is the following prerequisites for using scripts for creating DB schema: "openhub" user role has to defined. This role is owner of all tables and has granted all necessary privileges:

Code Block
-- grant privileges to 'openhub' user
GRANT SELECT, USAGE, UPDATE ON openhub_sequence TO openhub;
GRANT SELECT, INSERT, UPDATE, DELETE ON message, external_call, request, response, configuration TO openhub


...

Table stores evidence of cluster nodes. See Nodes evidence for more details.

Attribute

Type

NULL

Default

Description

node_id

number

No


primary key, technical identifier

code

stringNo
unique node code
namestringNo
unique node name
descriptionstringYes
Node description
statestringNo

Node's state:

  • RUN: Node handles new and existing (saved messages in ESB) messages
  • HANDLES_EXISTING_MESSAGES: Node handles only existing messages. New messages/requests are rejected. Used is Stopping mode.
  • STOPPED: Node not handles existing messages and new messages.