XALGCONTRATOLOCALGDOBRO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCADITALGDOBRO.CODCOLCONTLOC FKXALGCONTLOCADITALGDOBRO_NOVOR
XALGCONTRATOLOC.CODCOLCONTLOC FKXALGCONTRATOLOCALGDOBRO_XALGR
CODCONTLOC int 4 null
XALGCONTRATOLOCADITALGDOBRO.CODCONTLOC FKXALGCONTLOCADITALGDOBRO_ANTER
XALGCONTRATOLOC.CODCONTLOC FKXALGCONTRATOLOCALGDOBRO_XALGR
CODALGDOBRO int 4 null
XALGCONTRATOLOCADITALGDOBRO.CODALGDOBROANTERIOR FKXALGCONTLOCADITALGDOBRO_ANTER
XALGCONTRATOLOCADITALGDOBRO.NOVOCODALGDOBRO FKXALGCONTLOCADITALGDOBRO_NOVOR
COMPETENCIA int 4 √ null
PERCENTUAL RMDVALOR4 17,4 √ null
DATAINICIAL datetime2 16,7 √ null
DATAFINAL datetime2 16,7 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
DESCRICAO varchar 200 √ null
CTODOBRADO smallint 2 √ ((0))

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOLOCALGDOBRO Primary key Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + CODALGDOBRO

Relationships

Close relationships within degrees of separation