XALGCONTRATOLOCGARANTIA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCADITGARANTIA.CODCOLCONTLOC FKXALGCONTRLOCDITGAR_XALGCONTRR
XALGCONTRATOLOCGARANTIACOMPL.CODCOLCONTLOC FKXALGCONTRATGARANT_XALGCONTIAR
XALGCONTRATOLOC.CODCOLCONTLOC FKXALGCONTLOCGAR_XALGCONTLOCR
CODCONTLOC int 4 null
XALGCONTRATOLOCADITGARANTIA.CODCONTLOC FKXALGCONTRLOCDITGAR_XALGCONTRR
XALGCONTRATOLOCGARANTIACOMPL.CODCONTLOC FKXALGCONTRATGARANT_XALGCONTIAR
XALGCONTRATOLOC.CODCONTLOC FKXALGCONTLOCGAR_XALGCONTLOCR
IDGARANTIA int 4 null
XALGCONTRATOLOCADITGARANTIA.IDGARANTIAANTERIOR FKXALGCONTRLOCDITGAR_XALGCONTRR
XALGCONTRATOLOCGARANTIACOMPL.IDGARANTIA FKXALGCONTRATGARANT_XALGCONTIAR
CODCOLCFOINSTITUICAO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKXALGCONTLOCGAR_FCFOR
CODCFOINSTITUICAO varchar 25 √ null
FCFO.CODCFO FKXALGCONTLOCGAR_FCFOR
NUMEROGARANTIA varchar 50 √ null
TIPOGARANTIA smallint 2 √ null
VALORTOTAL RMDVALOR4 17,4 √ null
DATADOPAGAMENTO DDATETIME 16,3 √ null
VALIDADEINICIAL DDATETIME 16,3 √ null
VALIDADEFINAL DDATETIME 16,3 √ null
SITUACAOGARANTIA smallint 2 √ null
OBSERVACAOGARANTIA varchar 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDGARANTIASUCESSORA int 4 √ null
VINCULOVALORCONTRATO int 4 √ ((0))
CODSEGURO int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOLOCGARANTIA Primary key Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + IDGARANTIA

Relationships

Close relationships within degrees of separation