SLAN

1138 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SBOLSALAN.CODCOLIGADA FKSBOLSALAN_SLANCREDR
SLANDESCPONTUAL.CODCOLIGADA FKSLANDESCPONTUAL_SLANR
SPARCELA.CODCOLIGADA FKSLAN_SPARCELAR
FLAN.CODCOLIGADA FKSLAN_FLANR
SLANDESCPONTUAL.CODCOLIGADA FKSLAN_SLANDESCPONTUALR
IDLAN int 4 null
SBOLSALAN.IDLAN FKSBOLSALAN_SLANR
SBOLSALAN.IDLANBOLSACREDITO FKSBOLSALAN_SLANCREDR
SLANDESCPONTUAL.IDLAN FKSLANDESCPONTUAL_SLANR
FLAN.IDLAN FKSLAN_FLANR
SLANDESCPONTUAL.IDLAN FKSLAN_SLANDESCPONTUALR
IDPARCELA int 4 √ null
SPARCELA.IDPARCELA FKSLAN_SPARCELAR
CODPARCELALAN varchar 100 null
CODLAN int 4 √ ((0))
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDAGRUPADESCPONTUAL int 4 √ null
SLANDESCPONTUAL.IDAGRUPADESCPONTUAL FKSLAN_SLANDESCPONTUALR
IDDESCONTO int 4 √ null
SLANDESCPONTUAL.IDDESCONTO FKSLAN_SLANDESCPONTUALR

Indexes

Constraint Name Type Sort Column(s)
PKSLAN Primary key Asc/Asc CODCOLIGADA + IDLAN
S$SLAN_FLAN Performance Asc/Asc IDLAN + CODCOLIGADA
SXSLANCODPARCELALAN Must be unique Asc CODPARCELALAN
SXSLANPARCELA Performance Asc/Asc CODCOLIGADA + IDPARCELA

Relationships

Close relationships within degrees of separation