device

Column	Type	PK	Required	Default
device_id	VARCHAR	Yes	Yes
name	TEXT	No	Yes
state	TEXT	No	Yes
boundary	TEXT	No	Yes
segmentation	TEXT	No	No
state_sysinfo	TEXT	No	No
elaboration	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
name	device_name_state_boundary_unique
state	device_name_state_boundary_unique
boundary	device_name_state_boundary_unique
name	idx_device__name__state
state	idx_device__name__state
device_id	sqlite_autoindex_device_1

SQL DDL

CREATE TABLE `device` (
	`device_id` VARCHAR PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`state` text NOT NULL,
	`boundary` text NOT NULL,
	`segmentation` text,
	`state_sysinfo` text,
	`elaboration` 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 "state_check_valid_json" CHECK(json_valid("device"."state") OR "device"."state" IS NULL),
	CONSTRAINT "segmentation_check_valid_json" CHECK(json_valid("device"."segmentation") OR "device"."segmentation" IS NULL),
	CONSTRAINT "state_sysinfo_check_valid_json" CHECK(json_valid("device"."state_sysinfo") OR "device"."state_sysinfo" IS NULL),
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("device"."elaboration") OR "device"."elaboration" IS NULL)
)