Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Database design...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 3117 of 3212
Post > Topic >>

Database design pattern qestion

by TheWoland <thewoland@[EMAIL PROTECTED] > Mar 9, 2008 at 12:03 AM

I have a number of "clients" which re****t with a string
"client_id,client_model,0001001001", when the third part is a binary
string containing client's status. Each client model can have various
status message length and interpretation.
For each of the locations in the status message, stands it's
description and it's "im****tance level".

Example:
For model A:
Bit location: 0 1 2 3
Description: "General alarm" "Error no1" "Error no2" "Unit accessed"
Im****tance: "Critical" "Major" "Minor" "None"

For device B:
Bit location: 0 1 2
Description: "General alarm" "Error no1" "Unit accessed"
Im****tance: "Critical" "Major" "None"

What will be the best way to store this data into the database?
Any help will be appreciated.
 




 5 Posts in Topic:
Database design pattern qestion
TheWoland <thewoland@[  2008-03-09 00:03:47 
Re: Database design pattern qestion
Ed Prochak <edprochak@  2008-03-09 13:33:21 
Re: Database design pattern qestion
--CELKO-- <jcelko212@[  2008-03-19 14:29:23 
Re: Database design pattern qestion
son.matthew@[EMAIL PROTEC  2008-04-27 07:05:13 
Re: Database design pattern qestion
son.matthew@[EMAIL PROTEC  2008-04-27 07:09:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 23:24:14 CDT 2008.