XXCOMPONENTE

43 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOMPN int 4 null
XADITIVOALTERACAOVRPARCCOMPN.CODCOMPN Implied ConstraintR
XLOGCOMPONENTEVRINTEGRACAO.CODCOMPN Implied ConstraintR
XXCOMPONENTEVALORBASE.CODCOMPN FKXXCOMPONENTEVALORBASE_1R
XXCOMPONENTEVALORBASE.CODCOMPNVALORBASE FKXXCOMPONENTEVALORBASE_2R
XXCONTRATOCONTABILIZACAO.CODCOMPN Implied ConstraintR
XXCONTRATOGRUPOREGRA.CODCOMPN FKXXCONTRATOGRUPOREGRA_XXCOMPNR
XXCONTRATOGRUPOREGRALOG.CODCOMPN Implied ConstraintR
XXPARCELACOMPONENTELOG.CODCOMPN Implied ConstraintR
XXPARCELALOG.CODCOMPN Implied ConstraintR
DSCCOMPN varchar 200 null
CODTIPOCOMPN int 4 null
XXTIPOCOMPONENTE.CODTIPOCOMPN FKXXCOMPONENTE_XXTIPOCOMPNR
CODVALOROP varchar 200 √ 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)
PKXXCOMPONENTE Primary key Asc CODCOMPN

Relationships

Close relationships within degrees of separation