VCONVENIOS

17 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VAGENDAEXAM.CODCOLIGADA FKVAGENDAEXAM_VCONVENIOSR
VHORARIOCONVENIO.CODCOLIGADA FKVHORARIOCONVENIO_VCONVENIOSR
VEXAMES.CODCOLIGADA FKVCONVENIOS_VEXAMESR
CODEXAME varchar 10 null
VAGENDAEXAM.CODEXAME FKVAGENDAEXAM_VCONVENIOSR
VHORARIOCONVENIO.CODEXAME FKVHORARIOCONVENIO_VCONVENIOSR
VEXAMES.CODEXAME FKVCONVENIOS_VEXAMESR
CODENTIDADE varchar 16 null
VAGENDAEXAM.CODENTIDADE FKVAGENDAEXAM_VCONVENIOSR
VHORARIOCONVENIO.CODENTIDADE FKVHORARIOCONVENIO_VCONVENIOSR
VENTIDADES.CODENTIDADE FKVCONVENIOS_VENTIDADESR
PRECO RMDVALOR2 17,2 √ null
TEMPOGASTO int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DIASENTREGAEXAME int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation