Re: Looking for elegant solution to sensor / reading / alert database design.
From: Bob Badour <bob_at_badour.net>
Date: Thu, 09 Dec 2010 06:27:01 -0800
Message-ID: <dd2dnUKakaarep3QnZ2dnUVZ5t6dnZ2d_at_giganews.com>
>> Please post DDL, so that people do not have to guess what the keys,
>> constraints, Declarative Referential Integrity, data types, etc. in
>> your schema are. Please learn to follow ISO-11179 data element naming
>> conventions and formatting rules. The singular table names (they are
>> sets of more than one element, aren't they?) so use a collective or
>> plural name and the use of universal "_id" on every table were pretty
>> bad.
>
> Okay, point taken.
Date: Thu, 09 Dec 2010 06:27:01 -0800
Message-ID: <dd2dnUKakaarep3QnZ2dnUVZ5t6dnZ2d_at_giganews.com>
Mark S. (UK) wrote:
> On 07/12/2010 18:42, -CELKO- wrote: >
>> Please post DDL, so that people do not have to guess what the keys,
>> constraints, Declarative Referential Integrity, data types, etc. in
>> your schema are. Please learn to follow ISO-11179 data element naming
>> conventions and formatting rules. The singular table names (they are
>> sets of more than one element, aren't they?) so use a collective or
>> plural name and the use of universal "_id" on every table were pretty
>> bad.
>
> Okay, point taken.
Ignore Joe. This isn't some product-specific or even language-specific technical support group. It's the fucking theory group. Joe is an idiot. Received on Thu Dec 09 2010 - 15:27:01 CET