VHISTMOVEPI

160 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VEMPRESTIMOEPI.CODCOLIGADA FKVHISTMOVEPI_VEMPRESTIMOEPIR
VEPI.CODCOLIGADA FKVHISTMOVEPI_VEPIR
TITMMOV.CODCOLIGADA FKVHISTMOVEPI_TITMMOVR
CODHISTMOVEPI int 4 null
CODEPI varchar 10 null
VEMPRESTIMOEPI.CODEPI FKVHISTMOVEPI_VEMPRESTIMOEPIR
VEPI.CODEPI FKVHISTMOVEPI_VEPIR
CODIDENTEPI varchar 30 null
VEMPRESTIMOEPI.CODIDENTEPI FKVHISTMOVEPI_VEMPRESTIMOEPIR
VEPI.CODIDENTEPI FKVHISTMOVEPI_VEPIR
SEQUENCIAL int 4 √ null
VEMPRESTIMOEPI.SEQUENCIAL FKVHISTMOVEPI_VEMPRESTIMOEPIR
IDMOV int 4 null
TITMMOV.IDMOV FKVHISTMOVEPI_TITMMOVR
NSEQITMMOV int 4 null
TITMMOV.NSEQITMMOV FKVHISTMOVEPI_TITMMOVR
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)
PKVHISTMOVEPI Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODHISTMOVEPI + CODEPI + CODIDENTEPI

Relationships

Close relationships within degrees of separation