Re: [dtp-dev] SQL Model Question - Column Data Types

[rcernich@xxxxxxxxxx]

> Hey all,
>
> I've got another SQL model question.
>
> In the column element, what is the distinction between DataType,
> ReferenceType and ContainedType?
>
> My assumption would be that the ReferenceType should be a
> ReferenceDataType, ContainedType would be a PredefinedDataType and
DataType
> would be a UserDefinedDataType?  However, ReferenceType is a
> UserDefinedType, which is not a parent of ReferenceDataType;
ContainedType
> could be either a ReferenceDataType or a PredefinedDataType; and DataType
> could be any of the three.
>
> Thanks in advance for any insight.
>
> Rob
>

Also, is there a reason why there are three different types of
relationships (seeing as DataType could be used to hold any of the three
distinct types)?

Thanks again,
Rob