Hi Atif, On Tue, Jun 04, 2002 at 02:09:20AM +0200, Atif Ghaffar wrote:
Can someone explain me what the ValidID and UserID is?
I am assuming UserID is the numeric ID of the user, and ValidID? Is this the ID of the user creating the record?
Right, UserID is a numeric ID (auto increment). ValidID --> the validity of the data record (valid|invalid|invalid-temporarily). Example: If you would delete a user (or queue, ...) from the database you will run in trouble if the application is working with database id references (a good database design is working with references). So set the data record to invalid an the record is still visible (e. g. for ticket history, ...) but not activ for the application. --> ValidID is a reference to the table "valid". ==> If a user is invalid (or invalid-temporarily), the user can't login or work with the system. Use invalid-temporarily if you get no money from a user/company for the ASP-solution. Use invalid for RIP.
-- Atif Ghaffar
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 102 Tage bis zum Gäubodenvolksfest! ;-)