database.eu.nts.nmp.mac.entities.create-tables.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of quarkus-kafka Show documentation
Show all versions of quarkus-kafka Show documentation
DSL based modeling framework - facilities Quarkus Kafka
CREATE TABLE IF NOT EXISTS ORGANIZATION_MODEL (
ID UUID NOT NULL,
NAME VARCHAR,
CONSTRAINT ORGANIZATION_MODEL_PK PRIMARY KEY (ID)
);
CREATE TABLE IF NOT EXISTS HOST_ALERT (
HOST_ID BIGINT NOT NULL,
CHECK_ID BIGINT,
MONITORING_SOURCE_ID VARCHAR,
MESSAGE VARCHAR,
STATE VARCHAR,
EVENT_STATE_TYPE VARCHAR,
SCHEDULED_DOWN BOOLEAN,
ACKNOWLEDGED BOOLEAN,
NOTIFICATION_ENABLED BOOLEAN,
FLAPPING BOOLEAN,
CREATED_AT_SOURCE_ON BIGINT,
CREATED_ON BIGINT,
CONSTRAINT HOST_ALERT_PK PRIMARY KEY (HOST_ID)
);