XALGCONTRATOLOCADITVALOR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCADITAREA.CODCOLCONTLOC FKXALGADITAREA_XALGADITVALORR
XALGCONTRATOLOCADIT.CODCOLCONTLOC FKXALGCONTLOCADITVAL_XALGCOLADR
XALGCONTRATOLOCHISTVALOR.CODCOLCONTLOC FKXALGCONTRATOLOCADITVR_XALGCOR
CODCONTLOC int 4 null
XALGCONTRATOLOCADITAREA.CODCONTLOC FKXALGADITAREA_XALGADITVALORR
XALGCONTRATOLOCHISTVALOR.CODCONTLOC FKXALGCONTRATOLOCADITVR_XALGCOR
XALGCONTRATOLOCADIT.CODCONTLOC FKXALGCONTLOCADITVAL_XALGCOLADR
CODADITIVOCONTLOC int 4 null
XALGCONTRATOLOCADITAREA.CODADITIVOCONTLOC FKXALGADITAREA_XALGADITVALORR
XALGCONTRATOLOCADIT.CODADITIVOCONTLOC FKXALGCONTLOCADITVAL_XALGCOLADR
CODCOLIMOVEL DCODCOLIGADA 2 null
XALGCONTRATOLOCADITAREA.CODCOLIMOVEL FKXALGADITAREA_XALGADITVALORR
XALGIMOVEL.CODCOLIMOVEL FKXALGCONTLOCADITVAL_XALGIMOVER
CODIMOVEL int 4 null
XALGCONTRATOLOCADITAREA.CODIMOVEL FKXALGADITAREA_XALGADITVALORR
XALGIMOVEL.CODIMOVEL FKXALGCONTLOCADITVAL_XALGIMOVER
VRIMOVELCONTLOCANTERIOR RMDVALOR4 17,4 √ null
NOVOVRIMOVELCONTLOC RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDHISTORICOVALOR int 4 √ null
XALGCONTRATOLOCHISTVALOR.IDHISTORICOVALOR FKXALGCONTRATOLOCADITVR_XALGCOR

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOLOCADITVALOR Primary key Asc/Asc/Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + CODADITIVOCONTLOC + CODCOLIMOVEL + CODIMOVEL

Relationships

Close relationships within degrees of separation