IRESP

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IALOCACAORESPONSAVEL.CODCOLIGADA FKIALOCACAORESPONSAVEL_IRESPR
IBEM_OLD.CODCOLIGADA FKIBEMOLD_IRESPATUALR
IBEMINVENTARIO_OLD.CODCOLIGADA FKIBEMINVENTARIO_IRESPR
IBEMRESP_OLD.CODCOLIGADA FKIBEMRESP_IRESPR
IBEMTRANSFERENCIA_OLD.CODCOLIGADA FKIBEMTRANS_IRESPORIGEMR
IINVENTARIO.CODCOLIGADA FKIINVENTARIO_IRESPR
ILOCAL.CODCOLIGADA FKILOCAL_IRESPR
IPATRIMONIOALOCACAO.CODCOLIGADA FKIPATRIMONIOALOC_IRESPORIGR
IPATRIMONIORESPONSAVEL.CODCOLIGADA FKIPATRIMONIORESPONS_IRESPR
IPATRIMONIOTRANSFERENCIA.CODCOLIGADA FKIPATRIMONIOTRANSFE_IRESPR
GCOLIGADA.CODCOLIGADA FKIRESP_GCOLIGADAR
CODRESP varchar 10 null
IALOCACAORESPONSAVEL.CODRESPONSAVEL FKIALOCACAORESPONSAVEL_IRESPR
IBEM_OLD.CODRESPATUAL FKIBEMOLD_IRESPATUALR
IBEMINVENTARIO_OLD.CODRESP FKIBEMINVENTARIO_IRESPR
IBEMRESP_OLD.CODRESP FKIBEMRESP_IRESPR
IBEMTRANSFERENCIA_OLD.CODRESPDESTINO FKIBEMTRANS_IRESPDESTINOR
IBEMTRANSFERENCIA_OLD.CODRESPORIGEM FKIBEMTRANS_IRESPORIGEMR
IINVENTARIO.CODRESPONSAVEL FKIINVENTARIO_IRESPR
ILOCAL.CODRESP FKILOCAL_IRESPR
IPATRIMONIOALOCACAO.CODRESPONSAVELDESTINO FKIPATRIMONIOALOC_IRESPDESTR
IPATRIMONIOALOCACAO.CODRESPONSAVELORIGEM FKIPATRIMONIOALOC_IRESPORIGR
IPATRIMONIORESPONSAVEL.CODRESPONSAVEL FKIPATRIMONIORESPONS_IRESPR
IPATRIMONIOTRANSFERENCIA.CODRESPONSAVELDESTINO FKIPATRIMONIOTRANSFE_IRESPR
IPATRIMONIOTRANSFERENCIA.CODRESPONSAVELORIGEM FKIPATRIMONIOTRANSF_IRESPR
NOME varchar 40 √ null
ATIVO smallint 2 √ (1)
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)
PKIRESP Primary key Asc/Asc CODCOLIGADA + CODRESP

Relationships

Close relationships within degrees of separation