Re: DB design issue

Neo ha scritto:

> > ... how to design the Message table and how to link a 'type ID' with either a simple type (Type table) or a composed type (Block table).
>
> Could you treat simple types as a composed type having one element?

hi, thank you for your interest.

well I thought simple types with different attributes, but your hint make me think about the following possible solution:

T_SYSTEM
Idsys
Name
Description

T_INTERFACE (interfaces have a direction: a source and a dest system) Iditf
Name

Idsys	(source)
Idsys	(dest)

T_FIELDSOFMESSAGE
Idfom
Idmsg
Position
Idtyp
Name
Size
Unit
Values
Accuracy
Resolution
Description

T_FIELDSOFTYPE
Idfot
Idtyp
Position
Idtyp
Name
Size
Unit
Values
Accuracy
Resolution
Description

Do you all think it could be a good design? Received on Fri Nov 17 2006 - 16:40:27 CET