AVISITA

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ABATREFVIS.CODCOLIGADA FKABATREFVIS_AVISITAR
ABATVIS.CODCOLIGADA FKABATVIS_AVISITAR
ACRELVIS.CODCOLIGADA FKACRELVIS_AVISITAR
AIREFVIS.CODCOLIGADA FKAIREFVIS_AVISITAR
AREFVIS.CODCOLIGADA FKAREFVIS_AVISITAR
ARELVIS.CODCOLIGADA FKARELVIS_AVISITAR
ASECVIS.CODCOLIGADA FKASECVIS_AVISITAR
PFUNC.CODCOLIGADA FKAVISITA_PFUNCRESPR
GCOLIGADA.CODCOLIGADA FKAVISITA_GCOLIGADAR
CHAPA DCHAPA 16 null
ABATREFVIS.CHAPAVIS FKABATREFVIS_AVISITAR
ABATVIS.CHAPA FKABATVIS_AVISITAR
ACRELVIS.CHAPA FKACRELVIS_AVISITAR
AIREFVIS.CHAPAVIS FKAIREFVIS_AVISITAR
AREFVIS.CHAPA FKAREFVIS_AVISITAR
ARELVIS.CHAPA FKARELVIS_AVISITAR
ASECVIS.CHAPA FKASECVIS_AVISITAR
EMPRESA varchar 40 √ null
DATACADASTRO datetime 16,3 null
RESPONSAVEL varchar 16 √ null
PFUNC.CHAPA FKAVISITA_PFUNCRESPR
CODPESSOA int 4 null
PPESSOA.CODIGO FKAVISITA_PPESSOAR
ID int identity 4 √ null
DIGVERIFICADOR int 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)
PKAVISITA Primary key Asc/Asc CODCOLIGADA + CHAPA
AXVISITAID Must be unique Asc ID

Relationships

Close relationships within degrees of separation