Table Structure for Critique (1 Viewer)

dynamictiger

Registered User.
Local time
Today, 01:38
Joined
Feb 3, 2002
Messages
270
Access should have a built in shortened documenter for table structures. Anyway that is beside the point.

I am working on a design for a new application. It is for testing water for swimming pools. The following are the documented requirements:
-Any pool requires a test
-Any test can consist of treatment triggered by a parameter being out of required range
-Any test can contain treatment messages that are not triggered by a parameter
-The user ultimately controls the test order, treatment order and order of messages on the recipe
-Some parameters affect the outcome of tests by other parameters this outcome can range from making one or the other test invalid or altering the order of treatment

My structure to address these requirements is as follows:

tblMessages
MsgID
Message

tblParameterComplex
ComplexID
ParameterAffected
Math
Parameter
ActionRequired

tblPool
PoolID
Type (Pool or spa or ???)
Construction
PSanitiser
PpHControl

tblPoolTarget
TargetID
PoolParam (links to tblTreatOrder)
Math
TValue (trigger value)
Outcome

tblPoolUnbound
UnboundID
Pool
TestGroup
Order
Outcome

tblTreatOrder
ID
Pool
TestGroup
Parameter
Type (Test or treat)
Order

I think the above structure with the assisting lookup tables addresses the requirements of the design. However, on the old adage two minds are better than one I am requesting critique.
 

Users who are viewing this thread

Top Bottom