All Downloads are FREE. Search and download functionalities are using the official Maven repository.

database.eu.nts.nmp.mac.entities.create-tables.sql Maven / Gradle / Ivy

There is a newer version: 1.3.34
Show newest version
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)
);		






© 2015 - 2024 Weber Informatics LLC | Privacy Policy