GDIC

128903 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TABELA varchar 30 null
GDICDATAPROTECTION.TABELA FKGDICDATAPROTECTION_GDICR
COLUNA varchar 30 null
GDICDATAPROTECTION.COLUNA FKGDICDATAPROTECTION_GDICR
DESCRICAO varchar 150 √ null
RELATORIO smallint 2 √ null
APLICACOES varchar 100 √ null
PORTUGAL varchar 40 √ null
RELPTG smallint 2 √ null
MEXICO varchar 40 √ null
RELMEX smallint 2 √ null
CONSULTATEXTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PODECONSULTARTEXTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ACTION varchar 120 √ null
ACTIONKEYFIELD varchar 255 √ null
ACTIONSEARCHFIELD varchar 255 √ null
SECCOLNAME varchar 120 √ null
SECCOLIGADACOLUMN varchar 120 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
STATUS bit 1 √ ((0))
APINAME nvarchar 240 √ null
ANONIMIZAVEL bit 1 ((0))
CODCLASSIFICACAO smallint 2 ((0))
PESSOAL bit 1 ((0))
SENSIVEL bit 1 ((0))
CODCLASSIFICACAODETALHADO smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKGDIC Primary key Asc/Asc TABELA + COLUNA
IXGDIC_DESCRICAO Performance Asc/Asc TABELA + DESCRICAO

Relationships

Close relationships within degrees of separation