create domain D_TP_CEP as varchar(10) character set UTF8 check (trim(trailing from value) similar to '[0-9][0-9][0-9][0-9][0-9][-][0-9][0-9][0-9]'); create domain D_TP_EMAIL as varchar(200) character set UTF8 check (trim(trailing from value) similar to '[a-z]+@{1}[a-z]+.{1}[a-z]+');