PSECAOPT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PESTABPT.CODCOLIGADA FKPSECAOPT_PESTABPTR
PSECAO.CODCOLIGADA FKPSECAOPT_PSECAOR
CODIGO varchar 35 null
PSECAO.CODIGO FKPSECAOPT_PSECAOR
NISS varchar 11 √ null
ESTABSS varchar 4 √ null
CODATIVIDADE varchar 5 √ null
CODFREGUESIA varchar 10 √ null
GFREGUESIAPT.CODIGO FKPSECAOPT_GFREGUESIAPTR
CODPOSTAL varchar 8 √ null
GCODIGOPOSTALPT.CODIGO FKPSECAOPT_GCODIGOPOSTALPTR
CODMUNICIPIO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKPSECAOPT_GMUNICIPIOR
CODETDMUNICIPIO varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKPSECAOPT_GMUNICIPIOR
CODASSPATRONAL1 varchar 3 √ null
CODASSPATRONAL2 varchar 3 √ null
CODASSPATRONAL3 varchar 3 √ null
CODFILIALESTAB smallint 2 √ null
PESTABPT.CODFILIAL FKPSECAOPT_PESTABPTR
CODESTAB smallint 2 √ null
PESTABPT.CODESTAB FKPSECAOPT_PESTABPTR
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)
PKPSECAOPT Primary key Asc/Asc CODCOLIGADA + CODIGO

Relationships

Close relationships within degrees of separation