术语问题 - 多个表中的相关记录集

UnitCostI''m looking for a term that could apply to an arbitrarily complex set ofitems, possibly with relationships among them, but all restricted byrelationship to a single key value somewhere. It could be as simple as aninvoice and its lines, or it could be as complex as a virtual schema for onecompany in a database that supports multiple, independent companiessimultaneously, each with their own product catalog, customer, invoices, etc.,and with no overlap allowed between records in different companies.For example...A collection of records comprising a single Company record and all otherrecords in all other tables that apply to that company and only that company.Company*CompanyIdCompanyNameProduct*ProductIdCompanyIdProductName(Unique CompanyId, ProductName)Customer*CustomerIdCompanyIdCustomerName(Unique CompanyId, CustomerName)Invoice*InvoiceIdCompanyIdInvoiceNumber(Unique CompanyId, InvoiceNumber)InvoiceLine*InvoiceLineIdCompanyId (part of both FKs to enforce same company)InvoiceId (part FK to Invoice)ProductID (part FK to Customer)LineQtyUnitCost 实体？ 发票标题+发票项目=发票。Entity?Invoice Header + Invoice Items = Invoice. 我正在寻找一个可以适用于任意复杂的项目的术语，可能与它们之间的关系，但所有受某种关键值限制的关系。它可以像发票及其行一样简单，也可以像支持多个独立公司的数据库中的一个公司的虚拟架构一样复杂同时，每个都有自己的产品目录，客户，发票，等，并且不同公司的记录之间不允许重叠。 例如... 包含单个公司记录的记录集合以及适用于该公司且仅适用于该公司的所有其他表格中的所有其他记录。 公司 *公司名称公司名称 产品 * ProductId CompanyId 产品名称（Unique CompanyId，ProductName） 客户 * CustomerId CompanyId 客户名称（独特的CompanyId，客户名称） 发票 * InvoiceId CompanyId InvoiceNumber （独特的CompanyId，InvoiceNumber） InvoiceLine * InvoiceL ineId CompanyId（执行同一公司的两个FK的一部分） InvoiceId（部分FK到发票） ProductID（部分FK到客户） LineQty UnitCost I''m looking for a term that could apply to an arbitrarily complex set of items, possibly with relationships among them, but all restricted by relationship to a single key value somewhere. It could be as simple as an invoice and its lines, or it could be as complex as a virtual schema for one company in a database that supports multiple, independent companies simultaneously, each with their own product catalog, customer, invoices, etc., and with no overlap allowed between records in different companies. For example... A collection of records comprising a single Company record and all other records in all other tables that apply to that company and only that company. Company *CompanyId CompanyName Product *ProductId CompanyId ProductName (Unique CompanyId, ProductName) Customer *CustomerId CompanyId CustomerName (Unique CompanyId, CustomerName) Invoice *InvoiceId CompanyId InvoiceNumber (Unique CompanyId, InvoiceNumber) InvoiceLine *InvoiceLineId CompanyId (part of both FKs to enforce same company) InvoiceId (part FK to Invoice) ProductID (part FK to Customer) LineQty UnitCost 这篇关于术语问题 - 多个表中的相关记录集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 1403页，肝出来的..