至少一个所有者 [英] at least one owner

查看:100
本文介绍了至少一个所有者的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

 大家好,


我有实体表,其中包含entity_id列。


我还有entity_owner表并且它也作为entity_id和owner_id列。


现在我需要设置一个规则,即实体应该至少有一个所有者,尽管它可以有多个所有者。 / p>

我如何实现这一目标? 


请提供建议。

解决方案

不清楚你想要实现什么以及"规则"是什么你的意思是?


请将表格设计作为DDL发布,将一些样本数据作为DML和预期结果发布+更多有关"规则"的详细信息。


 Hi all,

I got entities table and it has entity_id column among others.

I got also entity_owner table and it as entity_id and owner_id columns among others as well.

Now I would need to set a rule that entity should have at least one owner, though it can have more than one owner.

How do I achieve that? 

Please advise.

解决方案

Not clear what you trying to achieve and what for "rules" do you mean?

Please post table design as DDL, some sample data as DML und the expected result + some more details about "rule".


这篇关于至少一个所有者的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆