VEXAMES

22 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VAGENDAEXAM.CODCOLIGADA FKVAGENDAEXAM_VEXAMESR
VBATERIAEXAMES.CODCOLIGADA FKVBATERIAEXAMES_VEXAMESR
VCONVENIOS.CODCOLIGADA FKVCONVENIOS_VEXAMESR
VEXAMESINFCLINICA.CODCOLIGADA FKVEXAMESINFCLINICA_VEXAMESR
VEXAMESPEND.CODCOLIGADA FKVEXAMESPEND_VEXAMESR
VEXAMESPRONT.CODCOLIGADA FKVEXAMESPRONT_VEXAMESR
VPERFILEXAMEFUNC.CODCOLIGADA FKVPERFILEXAMEFUNC_VEXAMESR
VPERFILEXAMEPESSOA.CODCOLIGADA FKVPERFILEXAMEPESSOA_VEXAMESR
VRELACAOCAMPOSEXAMES.CODCOLIGADA FKVRELACAOCAMPOSEXAMES_VEXAMESR
CODEXAME varchar 10 null
VAGENDAEXAM.CODEXAME FKVAGENDAEXAM_VEXAMESR
VBATERIAEXAMES.CODEXAME FKVBATERIAEXAMES_VEXAMESR
VCONVENIOS.CODEXAME FKVCONVENIOS_VEXAMESR
VEXAMESINFCLINICA.CODEXAME FKVEXAMESINFCLINICA_VEXAMESR
VEXAMESPEND.CODEXAME FKVEXAMESPEND_VEXAMESR
VEXAMESPRONT.CODEXAME FKVEXAMESPRONT_VEXAMESR
VPERFILEXAMEFUNC.CODEXAME FKVPERFILEXAMEFUNC_VEXAMESR
VPERFILEXAMEPESSOA.CODEXAME FKVPERFILEXAMEPESSOA_VEXAMESR
VRELACAOCAMPOSEXAMES.CODEXAME FKVRELACAOCAMPOSEXAMES_VEXAMESR
NOMEEXAME varchar 150 √ null
PROCEDMEDICO MEMO 2147483647 √ null
TIPOEXAME smallint 2 √ null
ID int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODIGOTUSS varchar 10 √ null
VTUSS.CODCLIENTE FKVEXAMES_VTUSSR

Indexes

Constraint Name Type Sort Column(s)
PKVEXAMES Primary key Asc/Asc CODCOLIGADA + CODEXAME
VXEXAMESID Must be unique Asc ID

Relationships

Close relationships within degrees of separation