TITMCNTMEDICAO

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNTRELPREVMED.CODCOLIGADA FKTCNTRELPREVMED_TITMCNTMEDICAR
TITMCNTMEDICAOWFLUIG.CODCOLIGADA FKTITMCNTMEDICAOWFLUIG_TITMCNTR
TITMMOV.CODCOLIGADA FKTITMMOV_TITMCNTMEDICAOR
TITMCNT.CODCOLIGADA FKTITMCNTMEDICAO_TITMCNTR
IDCNT int 4 null
TCNTRELPREVMED.IDCNT FKTCNTRELPREVMED_TITMCNTMEDICAR
TITMCNTMEDICAOWFLUIG.IDCNT FKTITMCNTMEDICAOWFLUIG_TITMCNTR
TITMMOV.IDCNT FKTITMMOV_TITMCNTMEDICAOR
TITMCNT.IDCNT FKTITMCNTMEDICAO_TITMCNTR
NSEQITMCNT smallint 2 null
TCNTRELPREVMED.NSEQITMCNT FKTCNTRELPREVMED_TITMCNTMEDICAR
TITMCNTMEDICAOWFLUIG.NSEQITMCNT FKTITMCNTMEDICAOWFLUIG_TITMCNTR
TITMMOV.NSEQITMCNT FKTITMMOV_TITMCNTMEDICAOR
TITMCNT.NSEQITMCNT FKTITMCNTMEDICAO_TITMCNTR
NSEQMEDICAO smallint 2 null
TCNTRELPREVMED.NSEQMEDICAO FKTCNTRELPREVMED_TITMCNTMEDICAR
TITMCNTMEDICAOWFLUIG.NSEQMEDICAO FKTITMCNTMEDICAOWFLUIG_TITMCNTR
TITMMOV.NSEQITMCNTMEDICAO FKTITMMOV_TITMCNTMEDICAOR
STATUS smallint 2 √ null
DATA datetime 16,3 √ null
VALOR numeric 23,10 √ null
QUANTIDADE RMDVALOR4 17,4 √ null
DATAEXECUCAO datetime 16,3 √ null
CODMUNSERVICO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKTITMCNTMEDICAO_GMUNICIPIOR
CODETDMUNSERV varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKTITMCNTMEDICAO_GMUNICIPIOR
CODIGOSERVICO varchar 40 √ 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)
PKTITMCNTMEDICAO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDCNT + NSEQITMCNT + NSEQMEDICAO

Relationships

Close relationships within degrees of separation