Intertable
Intertable is a term used in information technology to describe the coordination of data that resides in separate database tables. It denotes the interfaces, constraints, and predicates that define how rows in one table relate to rows in another. The concept appears in discussions of database design, data integration, and reporting as a way to characterize the linkage mechanisms that enable cross-table queries while preserving data integrity.
An intertable relationship is typically implemented with foreign keys, join predicates, and referential constraints. It supports
Common intertable operations include intertable joins, where predicates link tables in a query, and intertable projections
Example: a Customers table with customer_id and name, and an Orders table with order_id, customer_id, and amount,
See also: foreign key, join, relational database, normalization, data integration.