Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database History

Re: Database History

From: Lieut_Data <lIeuT_dAtaREMOVEME_at_yahOO.com>
Date: Wed, 12 Mar 2003 13:19:10 -0500
Message-ID: <b4nt9j01n68@enews2.newsguy.com>


> > Do I delete the entry from the table? Then what happens to the trouble
> > ticket referring to it -- its stored keys now refers to a non-existent
> > user/hardware.
> >
> > Or should I hard-code the information into each ticket regarding the
> > user (I.e. dont use primary keys, but store "John" "Billcox" "IS/IT",
> > etc..)
> >
> > Or should I not delete users/hardware at all? Just mark them
> > "inactive", preventing them from showing up in the main list, where
> > they are not used. But what if we want to use a username again, for a
> > new employee?

> When equipment is retired it should be removed from the
> inventory, but you may wish to transfer the maintenance record
> to a service history table so that you can run a statistical
> analysis on failures and the required fixes.

This, too, makes sense -- thanks for the insight!

Lieut_Data Received on Wed Mar 12 2003 - 12:19:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US