blocks|key|870943|text|在我们的ERP系统中，账单和发票是分开的；供应商和客户在一个表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|870944|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In our ERP system we have bills and invoices separate; vendors and customer we have in one table.

blocks|key|2621846|text|我建议，如果它们是单独的概念，请将它们分开。通常，当您开始设计一个数据库，并且您的实体在其表中具有相同的列时，就会产生将它们合并到一个表中的冲动。如果您知道在解决方案的持续时间内，您永远不需要添加特定于客户的字段或特定于供应商的字段，那么我建议您将它们设置为1个表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2621847|保持它们的分离允许每个实体随着系统的发展和成熟而独立开发。|2621848|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I would suggest that if they are separate concepts, keep them separate. Usually when you start out designing a database and you have entities that have the same columns in their tables, the urge arises to consolidate them into 1 table. If you know for a fact that for the duration of the solution, you will never need ta add say customer-specific fields or vendor-specific fields, I would say go ahead and make them 1 table.

Keeping them separate allows each entity to develop on its own as the system grows and matures.

blocks|key|873100|text|在我看来，进货账单和出货发票确实是两码事：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|873101|发货发票将具有与您的产品表相匹配的行项目，并且收到的账单将有一个非常正式的审批流程，涉及经理、财务和发货人。在收到的账单上，accountants|873102|The“”是您的合作伙伴，但在发票上，合作伙伴的名称是"To"。|unordered-list-item|873103|873104|不同的实体应该有自己的表。如果它们有共同的属性，您可以将它们存储在文档表中，并在该表和Invoice+and+Bill表之间创建一个关系。|873105|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|N|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

It seems to me that an incoming bill and an outgoing invoice are really different things:

<ul>
<li>The outgoing invoice will have line items that match your product table</li>
<li>The incoming bill will have a very formal approval process, involving managers, finance, and accountants</li>
<li>The "From" on an incoming bill is your partner, but on an invoice, the partner's name is the "To"</li>
</ul>

Entities that are that different should have their own table. If they have common properties, you could store them in a Document table, and create a relation between that table and the Invoice and Bill table.

blocks|key|873124|text|出于许多原因，这是一条危险的道路。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|873125|我认为从逻辑上讲，您可以将所有内容折叠到一个表中，其中包含一个列"PrimaryKey“和可选的列Col1、Col2、Col3等，所有的varchars都可以被其他类型解释。|873126|特别是对于存在审计跟踪和归档问题的财务数据，这并不是一种简化。|873127|(但这是一种我们都会经历的策略...:)|873128|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

A dangerous road for many reasons.

I suppose logically speaking you could collapse everything into one table with a column "PrimaryKey" and optional columns Col1, Col2, Col3, etc. all varchars interpretable to other types.

Especially with financial data where there are audit trail and archiving issues, this is not a simplification.

(But it's the sort of strategy we all go through as a passing phase ...:) )

If i have bills (from vendors), and invoices (to customers), would it be better to keep them separate (in two tables), or in a single table?

What about vendors / customers? 

These are all relational-inheritance problems, can you give me some best practices regarding this?

Invoices and Bills in single table?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如果我有账单(来自供应商)和发票(给客户)，最好将它们分开(放在两个表中)，还是放在一个表中？那么供应商/客户呢？这些都是关系继承问题，你能给我一些关于这方面的最佳实践吗？

问单表中的发票和账单？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问单表中的发票和账单？EN