SZCADERNOGABARITO

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDCADERNO int 4 null
SZGABARITO.IDCADERNO FKSZGABARITO_SZCADERNOGABARITOR
SZGABARITOCONTA.IDCADERNO Implied ConstraintR
NOME varchar 100 null
EPLANILHASEXP.NOME Implied ConstraintR
DATAINI datetime 16,3 null
DATAFIM datetime 16,3 √ null
CODCOLIGADACONV DCODCOLIGADA 2 null
SZTABMATMED.CODCOLIGADA FKSZCADERNOGAB_SZTABMATMEDR
SZTABPRECOUSADA.CODCOLIGADA FKSZCADGAB_SZTABPRECOUSADAPROCR
SZCADGERAL.CODCOLIGADA FKSZCADERNOGABARITO_SZCADGERALR
CODCONVENIO int 4 null
SZCADGERAL.CODGERAL FKSZCADERNOGABARITO_SZCADGERALR
CODTABPROC char 2 √ null
SZTABPRECOUSADA.CODTABELA FKSZCADGAB_SZTABPRECOUSADAPROCR
CODTABSERV char 2 √ null
SZTABPRECOUSADA.CODTABELA FKSZCADGAB_SZTABPRECOUSADASERVR
CODTABMAT int 4 √ null
SZTABMATMED.CODTABMATMED FKSZCADERNOGAB_SZTABMATMEDMATR
CODTABMED int 4 √ null
SZTABMATMED.CODTABMATMED FKSZCADERNOGAB_SZTABMATMEDR
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)
PKSZCADERNOGABARITO Primary key Asc IDCADERNO

Relationships

Close relationships within degrees of separation