TRESERVARELAC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLORIGEM DCODCOLIGADA 2 null
TRESERVALOC.CODCOLIGADA FKTRESERVARELAC_TRESERVALOCORIR
IDPRD int 4 null
TRESERVALOC.IDPRD FKTRESERVARELAC_TRESERVALOCORIR
IDRESERVAORIGEM int 4 null
TRESERVALOC.IDRESERVA FKTRESERVARELAC_TRESERVALOCORIR
CODFILIALORIGEM smallint 2 null
TRESERVALOC.CODFILIAL FKTRESERVARELAC_TRESERVALOCORIR
CODLOCORIGEM varchar 15 null
TRESERVALOC.CODLOC FKTRESERVARELAC_TRESERVALOCORIR
CODCOLDESTINO DCODCOLIGADA 2 null
TRESERVALOC.CODCOLIGADA FKTRESERVARELAC_TRESERVALOCDESR
IDRESERVADESTINO int 4 null
TRESERVALOC.IDRESERVA FKTRESERVARELAC_TRESERVALOCDESR
CODFILIALDESTINO smallint 2 null
TRESERVALOC.CODFILIAL FKTRESERVARELAC_TRESERVALOCDESR
CODLOCDESTINO varchar 15 null
TRESERVALOC.CODLOC FKTRESERVARELAC_TRESERVALOCDESR
QUANTIDADE RMDVALOR4 17,4 √ null
TIPO varchar 1 null
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)
PKTRESERVARELAC Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLORIGEM + IDPRD + IDRESERVAORIGEM + CODFILIALORIGEM + CODLOCORIGEM + CODCOLDESTINO + IDRESERVADESTINO + CODFILIALDESTINO + CODLOCDESTINO

Relationships

Close relationships within degrees of separation