我有一个称为“产品”的表格和一个称为“商店”的表格。 每个商店都有一份销售的产品清单。 我需要一个中间桌,该桌上有商业信息数据库和产品信息数据库。 我应该说什么? 我的心.一空。
商店购物?
Edit: 也许 我应该把它称作“可拆卸的物品”吗? 或者,这种混淆太大。
是 商店(取决于你使用的多元数)是我如何命名一个联系实体。
Shop
|
-----
| | |
ShopProduct
| | |
-----
|
Product
因此,商店可以拥有许多产品,每个产品可以在许多商店出售。
我更喜欢按<代码>的行文。shopProductsJunction . 。 第条可提供其他几个点名:
......也称为交叉参考表、桥梁表、加入表、地图表、交叉表、链接表或联系表
是的,店铺好。 没有问题
个人上,我只想像在my 语言上所感觉的那样,使用商店产品。
我看到了ORMs使用的product_shop_rel。 例如,与OERP(现称Ooo)一样。
商店2购物(或产品2Shop)较好:“2”在中间显示是中间桌。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...