TRESERVA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
KITEMPLANOMESTRE.CODCOLIGADA FKKITEMPLANOMESTRE_TRESERVAR
KMOVITEMRESERVAOP.CODCOLIGADA FKKMOVITEMRESERVAOP_TRESERVAR
KPMPMATERIAISITEMRESERVA.CODCOLIGADA FKKPMPMATITEMRESERVA_TRESERVAR
KPMPSEMIACABADO.CODCOLIGADA FKKPMPSEMIACABADO_TRESERVAR
KRESERVAESTOQUEPARAOP.CODCOLIGADA FKKRESERVAESTOQPARAOP_TRESERVAR
TITEMRESERVA.CODCOLIGADA FKTITEMRESERVA_TRESERVAR
GCOLIGADA.CODCOLIGADA FKTRESERVA_GCOLIGADAR
IDRESERVA int 4 null
KITEMPLANOMESTRE.IDRESERVA FKKITEMPLANOMESTRE_TRESERVAR
KMOVITEMRESERVAOP.IDRESERVANUCLEUS FKKMOVITEMRESERVAOP_TRESERVAR
KPMPMATERIAISITEMRESERVA.IDRESERVA FKKPMPMATITEMRESERVA_TRESERVAR
KPMPSEMIACABADO.IDRESERVA FKKPMPSEMIACABADO_TRESERVAR
KRESERVAESTOQUEPARAOP.IDRESERVA FKKRESERVAESTOQPARAOP_TRESERVAR
TITEMRESERVA.IDRESERVA FKTITEMRESERVA_TRESERVAR
IDORIGEM int 4 √ null
IDPRIORIDADE int 4 null
TRESERVAPRIORIDADE.IDPRIORIDADE FKTRESERVA_TRESERVAPRIORIDADER
DATA datetime 16,3 null
TIPO int 4 null
SISTEMA varchar 1 null
STATUS varchar 1 √ null
DATACRIACAO datetime 16,3 √ null
USUARIOCRIACAO varchar 20 √ null
DATACANCELAMENTO datetime 16,3 √ null
USUARIOCANCELAMENTO varchar 20 √ 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)
PKTRESERVA Primary key Asc/Asc CODCOLIGADA + IDRESERVA

Relationships

Close relationships within degrees of separation