LDESCLAN

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
LDESCLANEMP.CODCOLIGADA FKLDESCLANEMP_LDESCLANR
FLAN.CODCOLIGADA FKLDESCLAN_FLANR
LEMPRESTIMOS.CODCOLIGADA FKLDESCLAN_LEMPRESTIMOSR
LUSUARIO.CODCOLIGADA FKLDESCLAN_LUSUARIOR
CODLANC int 4 null
LDESCLANEMP.CODLANC FKLDESCLANEMP_LDESCLANR
FLAN.IDLAN FKLDESCLAN_FLANR
CODCLIENTE int 4 √ null
LUSUARIO.CODIGO FKLDESCLAN_LUSUARIOR
CODEMPRESTIMO int 4 √ null
LEMPRESTIMOS.CODIGO FKLDESCLAN_LEMPRESTIMOSR
TIPOCOBRANCA varchar 1 ('M')
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)
PKLDESCLAN Primary key Asc/Asc CODCOLIGADA + CODLANC
L$LDESCLAN_FLAN Performance Asc/Asc CODLANC + CODCOLIGADA

Check Constraints

Constraint Name Constraint
CK__LDESCLAN__TIPOCO__7BB51C10 ([TIPOCOBRANCA] = 'U' or [TIPOCOBRANCA] = 'M')

Relationships

Close relationships within degrees of separation