XALGLAN

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
XALGCONTRATOLOC.CODCOLCONTLOC FKXALGLAN_XALGCONTRATOLOCR
XALGHISTORICOGERALAN.CODCOLIGADA FKXALGLAN_XALGHISTORICOGERALANR
FLAN.CODCOLIGADA FKXALGLAN_FLANICR
XALGCONTRATOADM.CODCOLCONTADM FKXALGLAN_XALGCONTRATOADMR
CODCONTLOC int 4 null
XALGCONTRATOLOC.CODCONTLOC FKXALGLAN_XALGCONTRATOLOCR
CODCONTADM int 4 √ null
XALGCONTRATOADM.CODCONTRATOADM FKXALGLAN_XALGCONTRATOADMR
CODGERACAO int 4 √ null
XALGHISTORICOGERALAN.CODGERACAO FKXALGLAN_XALGHISTORICOGERALANR
IDLAN int 4 null
FLAN.IDLAN FKXALGLAN_FLANICR
INICIOPER DDATE 16,3 null
FIMPER DDATE 16,3 null
IDLANREL int 4 √ null
FLAN.IDLAN FKXALGLAN_FLANIRCR
CODCOLTDO DCODCOLIGADANULL 2 √ null
CODTDO varchar 10 null
PAGREC int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAREAJUSTE DDATE 16,3 √ null
VALOR RMDVALOR4 17,4 √ null
VRRESIDUO RMDVALOR4 17,4 √ null
VRBASEREAJUSTE RMDVALOR4 17,4 √ null
MEMOCALCULO varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXALGLAN Primary key Asc/Asc CODCOLIGADA + IDLAN

Relationships

Close relationships within degrees of separation