XALGIMOVELINSCRICAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIMOVEL DCODCOLIGADA 2 null
XALGIMOVELINSCRICAOHIST.CODCOLIMOVEL FKXALGIMOVELINSCRICAOHIST_XALGR
XDESPESA.CODCOLIGADA FKXDESPESA_XALGIMOVELINSCRICAOR
XTIPODESPESA.CODCOLIGADA FKXALGIMOVELINSCRICAO_XTIPODESR
XALGIMOVEL.CODCOLIMOVEL FKXALGIMOVELINSCRICAO_XALGIMOVR
CODIMOVEL int 4 null
XALGIMOVELINSCRICAOHIST.CODIMOVEL FKXALGIMOVELINSCRICAOHIST_XALGR
XDESPESA.CODIMOVEL FKXDESPESA_XALGIMOVELINSCRICAOR
XALGIMOVEL.CODIMOVEL FKXALGIMOVELINSCRICAO_XALGIMOVR
IDINSCRICAO int 4 null
XALGIMOVELINSCRICAOHIST.IDINSCRICAO FKXALGIMOVELINSCRICAOHIST_XALGR
XDESPESA.IDINSCRICAOMUNICIPAL FKXDESPESA_XALGIMOVELINSCRICAOR
CODINSCRICAO varchar 30 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
AREATERRENO RMDVALOR4 17,4 √ null
AREACONSTRUIDA RMDVALOR4 17,4 √ null
VALORVENAL RMDVALOR4 17,4 √ null
DESCRICAO varchar 200 √ null
CODTIPODESPESA int 4 √ null
XTIPODESPESA.CODTIPODESPESA FKXALGIMOVELINSCRICAO_XTIPODESR

Indexes

Constraint Name Type Sort Column(s)
PKXALGIMOVELINSCRICAO Primary key Asc/Asc/Asc CODCOLIMOVEL + CODIMOVEL + IDINSCRICAO

Relationships

Close relationships within degrees of separation