XALGCONTRATOADMPROPRIETARIO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTADM DCODCOLIGADA 2 null
XALGCONTRATOADMBENEFICIARIO.CODCOLCONTADM FKXALGCONTADMBEN_XALGCONTPROPR
XALGCONTRATOADMPROPPROC.CODCOLCONTADM FKXALGCONTADMPROP_XALGCONTPROCR
XALGCONTRATOADM.CODCOLCONTADM FKXALGCONTADMPROP_XALGCONTRATOR
CODCONTRATOADM int 4 null
XALGCONTRATOADMBENEFICIARIO.CODCONTRATOADM FKXALGCONTADMBEN_XALGCONTPROPR
XALGCONTRATOADMPROPPROC.CODCONTRATOADM FKXALGCONTADMPROP_XALGCONTPROCR
XALGCONTRATOADM.CODCONTRATOADM FKXALGCONTADMPROP_XALGCONTRATOR
CODCOLCFOPROP DCODCOLIGADA 2 null
XALGCONTRATOADMBENEFICIARIO.CODCOLCFOPROP FKXALGCONTADMBEN_XALGCONTPROPR
XALGCONTRATOADMPROPPROC.CODCOLCFOPROP FKXALGCONTADMPROP_XALGCONTPROCR
XALGPROPRIETARIO.CODCOLCFOPROP FKXALGCONTADMPROP_XALGPROPRIETR
CODCFOPROP varchar 25 null
XALGCONTRATOADMBENEFICIARIO.CODCFOPROP FKXALGCONTADMBEN_XALGCONTPROPR
XALGCONTRATOADMPROPPROC.CODCFOPROP FKXALGCONTADMPROP_XALGCONTPROCR
XALGPROPRIETARIO.CODCFOPROP FKXALGCONTADMPROP_XALGPROPRIETR
IDPROPRIETARIO int 4 null
XALGCONTRATOADMBENEFICIARIO.IDPROPRIETARIO FKXALGCONTADMBEN_XALGCONTPROPR
XALGCONTRATOADMPROPPROC.IDPROPRIETARIO FKXALGCONTADMPROP_XALGCONTPROCR
PRINCIPALPROP smallint 2 √ null
PERCENTPARTPROP RMDVALOR4 17,4 null
DTENTRADA DDATE 16,3 √ null
DTSAIDA DDATE 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SITUACAO smallint 2 √ null
IDADITIVOALTERACAO int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOADMPROPRIETARIO Primary key Asc/Asc/Asc/Asc/Asc CODCOLCONTADM + CODCONTRATOADM + CODCOLCFOPROP + CODCFOPROP + IDPROPRIETARIO

Relationships

Close relationships within degrees of separation