Domínios

Todos os Domínios criados pela Intelliware deve iniciar coma a letra T, abreviação de Tipo, pois os domínios são criados para serem utilizado como tipos de dados dos campos.

Domínio Tipo Tamanho Not Null 1) Check 2) Valor Padrão 3) Descrição
TALPHA1CHAR1
TALPHA10VARCHAR10
TALPHA100VARCHAR100
TALPHA100NVARCHAR100X
TALPHA1024VARCHAR1024
TALPHA10NVARCHAR10
TALPHA12VARCHAR12
TALPHA120VARCHAR120
TALPHA12NVARCHAR12X
TALPHA13NVARCHAR13X
TALPHA14VARCHAR14
TALPHA14NVARCHAR14X
TALPHA15CHAR15
TALPHA150NVARCHAR150X
TALPHA15NVARCHAR15X
TALPHA1NCHAR1
TALPHA2CHAR2
TALPHA20VARCHAR20
TALPHA2048VARCHAR2048
TALPHA20NVARCHAR20X
TALPHA25VARCHAR25
TALPHA255VARCHAR255
TALPHA255NVARCHAR255X
TALPHA2NVARCHAR2X
TALPHA3CHAR3
TALPHA30VARCHAR30
TALPHA30NVARCHAR30X
TALPHA3NCHAR3X
TALPHA4CHAR4
TALPHA40VARCHAR40
TALPHA40NVARCHAR40X
TALPHA4NCHAR4X
TALPHA5VARCHAR5
TALPHA50VARCHAR50
TALPHA50NVARCHAR50X
TALPHA512VARCHAR512
TALPHA5120VARCHAR5120
TALPHA5NVARCHAR5X
TALPHA6CHAR6
TALPHA60VARCHAR60
TALPHA60NVARCHAR60X
TALPHA6NVARCHAR6X
TALPHA7NVARCHAR7X
TALPHA8VARCHAR8
TALPHA9NVARCHAR9X
TBIGINTBIGINT
TBIGINTNBIGINT X
TBINARYBLOB
TCHARCHAR1
TCHAR10CHAR10
TCHAR12CHAR12
TCHAR126CHAR126
TCHAR13CHAR13
TCHAR14CHAR14
TCHAR14NCHAR14X
TCHAR16CHAR16
TCHAR18CHAR18
TCHAR2CHAR2
TCHAR20CHAR20
TCHAR20NCHAR20X
TCHAR22CHAR22
TCHAR26CHAR26
TCHAR28CHAR28
TCHAR2NCHAR2X
TCHAR3CHAR3
TCHAR30CHAR29
TCHAR37CHAR37
TCHAR3NCHAR3X
TCHAR4CHAR4
TCHAR4NCHAR4X
TCHAR53CHAR53
TCHAR53NCHAR53X
TCHAR6CHAR6
TCHAR6NCHAR6X
TCHAR7CHAR7
TCHAR79CHAR79
TCHAR8CHAR8
TCHAR8NCHAR8X
TCHARNCHAR1X
TCHASSIVARCHAR17X
TCTBCONTROLEVARCHAR3XCHECK(VALUE IN ('F', 'G', 'F/G'))
TCTBESPECIECHAR1XCHECK(VALUE IN ('A', 'S'))
TCTBNATUREZACHAR1XCHECK(VALUE IN ('C', 'D'))
TCTBORIGEMLANCTOCHAR1 CHECK(VALUE IN ('C', 'F', 'P', 'R', 'M'))DEFAULT 'M'
TCTBTIPOLANCCHAR1XCHECK(VALUE IN ('R', 'P', 'A', 'N'))
TCUSTONUMERIC18,6
TCUSTONNUMERIC18,6X
TDATAHORATIMESTAMP
TDATAHORANTIMESTAMP X DEFAULT CURRENT_TIMESTAMP
TDATEDATE
TDIAINTEGER
TDIAMESINTEGER CHECK ( (VALUE IS NULL) OR (VALUE BETWEEN 1 AND 31))
TFATORESINTEGER XCHECK(VALUE BETWEEN -1 AND 1)
TFLOATFLOAT
TFLOAT3NUMERIC18,3
TFLOAT3NNUMERIC18,3X
TFLOAT4NUMERIC18,4
TFLOAT4NNUMERIC18,4X
TFLOAT5NUMERIC18,5
TFLOAT5NNUMERIC18,5X
TFLOATNFLOAT X
THOJEDATE X DEFAULT CURRENT_DATE
THOJENDATE X DEFAULT CURRENT_DATE
THORA
THORAN X
TINT64BIGINT
TINTBOOL0SMALLINT XCHECK(VALUE IN (0,1))DEFAULT 0
TINTBOOL1SMALLINT XCHECK(VALUE IN (0,1))DEFAULT 1
TINTEGERINTEGER
TINTEGER0INTEGER X DEFAULT 0
TINTEGER1INTEGER X DEFAULT 1
TINTEGERNINTEGER X
TMONEY2NUMERIC18,2
TMONEY2NNUMERIC18,2X
TMONEY3NUMERIC18,3
TMONEY3NNUMERIC18,3X
TMONEYUNID10NNUMERIC18,10X
TNUM2NINTEGER X
TNUMERONFVARCHAR7X
TNUMERONFEVARCHAR10
TPERCENTNUMERIC18,8X DEFAULT 0
TPERCENTNLNUMERIC18,8
TPICTUREBLOB
TPKEYBIGINT X
TQTDEPESO3NNUMERIC18,3X
TSEXOCHAR1XCHECK(VALUE IN ('M','F', ' '))DEFAULT 'M'
TSMALLINTSMALLINT
TSMALLINTNSMALLINT X DEFAULT 1
TTEXTOBLOB
TTIPOACAONVARCHAR1XCHECK (VALUE IN ('U', 'D', 'I'))
TTIPOPESSOANCHAR1XCHECK (VALUE IN ('F','J'))
TTIPOTURNONCHAR3XCHECK(VALUE IN ('T1','T2', 'T3'))
1) Não permite que o campo seja NULL
2) Verificação feita ao ser inserido ou alterado o registro
3) Valor usado no caso da ausência de valores