behavior

Column	Type	PK	Required	Default
behavior_id	VARCHAR	Yes	Yes
device_id	TEXT	No	Yes
behavior_name	TEXT	No	Yes
behavior_conf_json	TEXT	No	Yes
assurance_schema_id	TEXT	No	No
governance	TEXT	No	No
created_at	TIMESTAMPTZ	No	No	CURRENT_TIMESTAMP
created_by	TEXT	No	No	'UNKNOWN'
updated_at	TIMESTAMPTZ	No	No
updated_by	TEXT	No	No
deleted_at	TIMESTAMPTZ	No	No
deleted_by	TEXT	No	No
activity_log	TEXT	No	No

Foreign Keys

No data

Indexes

Column Name	Index Name
device_id	behavior_device_id_behavior_name_unique
behavior_name	behavior_device_id_behavior_name_unique
behavior_id	sqlite_autoindex_behavior_1

SQL DDL

CREATE TABLE `behavior` (
	`behavior_id` VARCHAR PRIMARY KEY NOT NULL,
	`device_id` text NOT NULL,
	`behavior_name` text NOT NULL,
	`behavior_conf_json` text NOT NULL,
	`assurance_schema_id` text,
	`governance` text,
	`created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
	`created_by` text DEFAULT 'UNKNOWN',
	`updated_at` TIMESTAMPTZ,
	`updated_by` text,
	`deleted_at` TIMESTAMPTZ,
	`deleted_by` text,
	`activity_log` text,
	CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL),
	CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL)
)