XALGCONTRATOLOCADITEXCLIMOVEL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCADIT.CODCOLCONTLOC FKXALGCONTRATOLOCIMOVEL_ADITR
XALGCONTRATOLOCHISTVALOR.CODCOLCONTLOC FKXALGCONTRATOLOCIMOVEL_HISTR
CODCONTLOC int 4 null
XALGCONTRATOLOCHISTVALOR.CODCONTLOC FKXALGCONTRATOLOCIMOVEL_HISTR
XALGCONTRATOLOCADIT.CODCONTLOC FKXALGCONTRATOLOCIMOVEL_ADITR
CODADITIVOCONTLOC int 4 null
XALGCONTRATOLOCADIT.CODADITIVOCONTLOC FKXALGCONTRATOLOCIMOVEL_ADITR
CODCOLIMOVEL DCODCOLIGADA 2 null
XALGIMOVEL.CODCOLIMOVEL FKXALGCONTRATOLOCMOVEL_IMOVELR
CODIMOVEL int 4 null
XALGIMOVEL.CODIMOVEL FKXALGCONTRATOLOCMOVEL_IMOVELR
IDHISTORICOEXCLUSAOIMOVEL int 4 √ null
XALGCONTRATOLOCHISTVALOR.IDHISTORICOVALOR FKXALGCONTRATOLOCIMOVEL_HISTR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
VRIMOVELCONTLOC RMDVALOR4 17,4 √ null
VRMETROQUADRADO RMDVALOR4 17,4 √ null
AREALOCADA RMDVALOR4 17,4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation