| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> 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_MESSAGE
Idmes
Iditf
Name
Identification
Service
Timing
Answer
Description
T_TYPE
Idtyp
Name
isNative
Description
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 - 09:40:27 CST
 |
 |