PFDADOSRESIDEXTERIOR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CHAPA DCHAPA 16 null
IDDADOSRESID smallint 2 null
DTINICIAL DDATETIME 16,3 null
DTFINAL DDATETIME 16,3 √ null
IDPAIS smallint 2 null
GPAIS.IDPAIS Implied ConstraintR
CODETD varchar 2 √ null
GETD.CODETD Implied ConstraintR
CODMUNICIPIO varchar 20 √ null
LOGRADOURO varchar 60 √ null
NUMERO varchar 6 √ null
COMPLEMENTO varchar 25 √ null
BAIRRO varchar 20 √ null
CODPOSTAL varchar 10 √ null
TELEFONE varchar 15 √ null
INDICABENEF varchar 1 null
NIF varchar 30 √ null
IDPAISEXIGENIF varchar 1 null
CODRECEITA varchar 4 null
TIPORENDIMENTO varchar 3 null
FORMATRIBUT varchar 2 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)
PKPFDADOSRESIDEXTERIOR Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + IDDADOSRESID

Relationships

Close relationships within degrees of separation