ALTER TABLE device
ADD CHECK (length(trim(name)) > 0),
ADD CHECK (length(trim(description)) > 0);

ALTER TABLE device_property
ADD CHECK (length(trim(name)) > 0),
ADD CHECK (length(trim(description)) > 0);