TFAMILIA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCFOFAMILIA.CODCOLIGADA FKTCFOFAMILIA_TFAMILIAR
TPRDFAMILIA.CODCOLIGADA FKTPRDFAMILIA_TFAMILIAR
TVENFAMILIA.CODCOLIGADA FKTVENFAMILIA_TFAMILIAR
TLOC.CODCOLIGADA FKTFAMILIA_TLOCR
GFILIAL.CODCOLIGADA FKTFAMILIA_GFILIALR
IDFAMILIA int 4 null
TCFOFAMILIA.IDFAMILIA FKTCFOFAMILIA_TFAMILIAR
TPRDFAMILIA.IDFAMILIA FKTPRDFAMILIA_TFAMILIAR
TVENFAMILIA.IDFAMILIA FKTVENFAMILIA_TFAMILIAR
VENDECOMPRA int 4 null
CODFAMILIA varchar 10 null
DESCFAMILIA varchar 100 √ null
CODFILIAL smallint 2 √ null
TLOC.CODFILIAL FKTFAMILIA_TLOCR
GFILIAL.CODFILIAL FKTFAMILIA_GFILIALR
CODLOC varchar 15 √ null
TLOC.CODLOC FKTFAMILIA_TLOCR
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)
PKTFAMILIA Primary key Asc/Asc CODCOLIGADA + IDFAMILIA
TXCODFAMILIA Must be unique Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFAMILIA + CODFILIAL + CODLOC + VENDECOMPRA

Relationships

Close relationships within degrees of separation