RE: Column unique index

[Vijay Kumar Jalagari <ja...@adobe.com>]

Hi Kasper,

Your right this only available in RDMBS systems and primary & foreign key will provided the relationship can be either 1:1 or 1:many and this determined by following 

Primary Key |foreign key | Unique 
-->   <Id>       | <id>            |  false             ===> 1:1
-->    <Id>      | <id>            |   true             ===> 1: Many


Regards,
Vijay Kumar J

-----Original Message-----
From: Kasper Sørensen [mailto:i.am.kasper.sorensen@gmail.com] 
Sent: Friday, July 01, 2016 12:20 AM
To: dev@metamodel.apache.org
Subject: Re: Column unique index

Hi Vijay,

We do not have a unique flag, that's correct. I'd be open to investigating if we can add it. But it seems like a trait that is more or less only available in RDBMS'es.

We do have the primary key flag though, which is normally the way of finding relationships because any foreign key would typically refer to a primary key, not just any unique value.

Kasper

2016-06-30 5:55 GMT-07:00 Vijay Kumar Jalagari <ja...@adobe.com>:

> Hi,
>
> I couldn't able to find the unique index property on table column 
> field, is it left out intentionally ?
> This property will be required to identity relation between tables is 
> 1 to
> 1 or 1 to many.
>
> Is there any way to find the relationship b/w tables is 1:1 or 1:many ?
>
>
> Regards,
> Vijay Kumar J
>