VAGENDAEXAM

1096 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVAGENDAEXAM_PFUNCR
VCONSULTASPRONT.CODCOLIGADA FKVAGENDAEXAM_VCONSULTASPRONTR
VCONVENIOS.CODCOLIGADA FKVAGENDAEXAM_VCONVENIOSR
VEXAMES.CODCOLIGADA FKVAGENDAEXAM_VEXAMESR
CODEXAME varchar 10 null
VEXAMES.CODEXAME FKVAGENDAEXAM_VEXAMESR
VCONVENIOS.CODEXAME FKVAGENDAEXAM_VCONVENIOSR
CODENTIDADE varchar 16 null
VENTIDADES.CODENTIDADE FKVAGEDNAEXAM_VENTIDADESR
VCONVENIOS.CODENTIDADE FKVAGENDAEXAM_VCONVENIOSR
INICIOATEND datetime 16,3 null
TERMINOATEND datetime 16,3 √ null
CID varchar 10 √ null
VCID.CID FKVAGENDAEXAM_VCIDR
DIASEMANA smallint 2 null
CODPESSOA int 4 null
PPESSOA.CODIGO FKVAGENDAEXAM_PPESSOAR
SITUACAO char 1 ('R')
TIPOEXAME varchar 1 √ null
VTIPOEXAME.CODCLIENTE FKVAGENDAEXAM_VTIPOEXAMER
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODMEDICO int 4 √ null
VPROFISSIONALSAUDE.CODIGO FKVAGENDAEXAM_VPROFISSIONALSAUR
CONSULTA int 4 √ null
VCONSULTASPRONT.IDCONSULTA FKVAGENDAEXAM_VCONSULTASPRONTR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKVAGENDAEXAM_PFUNCR

Indexes

Constraint Name Type Sort Column(s)
PKVAGENDAEXAM Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODEXAME + CODENTIDADE + INICIOATEND + CODPESSOA

Relationships

Close relationships within degrees of separation