BCLASSIFICACAO

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
BPERFILCLASSIF.CODCOLIGADA FKBPERFILCLASSIF_BCLASSIFICACAR
BPROVACLASSIF.CODCOLIGADA FKBPROVACLASSIF_BCLASSIFICACAOR
BQUESTAOCLASSIF.CODCOLIGADA FKBQUESTAOCLASSIF_BCLASSIFICACR
ID int 4 null
BPERFILCLASSIF.IDCLASSIFICACAO FKBPERFILCLASSIF_BCLASSIFICACAR
BPROVACLASSIF.IDCLASSIFICACAO FKBPROVACLASSIF_BCLASSIFICACAOR
BQUESTAOCLASSIF.IDCLASSIFICACAO FKBQUESTAOCLASSIF_BCLASSIFICACR
CODCLASSIFICACAO varchar 35 null
NOME varchar 65 null
DESCRICAO varchar 255 √ null
ITEMCLASSIFICADO smallint 2 null
BINTITEMCLASSIF.CODINTERNO FKBCLASSIFICACAO_BINTITEMCLASSR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKBCLASSIFICACAO Primary key Asc/Asc CODCOLIGADA + ID
BXBCLASSIFICACAO Must be unique Asc/Asc/Asc CODCOLIGADA + CODCLASSIFICACAO + ITEMCLASSIFICADO

Relationships

Close relationships within degrees of separation