XALGCONTRATOLOCHISTVRIMOVEL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCHISTVALOR.CODCOLCONTLOC FKXALGCONTRATOLOCHIST_XALGCHISR
CODCONTLOC int 4 null
XALGCONTRATOLOCHISTVALOR.CODCONTLOC FKXALGCONTRATOLOCHIST_XALGCHISR
IDHISTORICOVALOR int 4 null
XALGCONTRATOLOCHISTVALOR.IDHISTORICOVALOR FKXALGCONTRATOLOCHIST_XALGCHISR
CODCOLIMOVEL DCODCOLIGADA 2 null
XALGIMOVEL.CODCOLIMOVEL FKXALGCONTRATOLOCHISTVRIMOVEL_R
CODIMOVEL int 4 null
XALGIMOVEL.CODIMOVEL FKXALGCONTRATOLOCHISTVRIMOVEL_R
DATAINICIAL DDATETIME 16,3 null
DATAFINAL DDATETIME 16,3 √ null
VRIMOVELCONTLOC RMDVALOR4 17,4 √ null
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)
PKXALGCONTRATOLOCHISTVRIMOVEL Primary key Asc/Asc/Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + IDHISTORICOVALOR + CODCOLIMOVEL + CODIMOVEL

Relationships

Close relationships within degrees of separation