What is master table and transaction table in SQL?

What is transaction table and master table?

A transaction is an activity performed by entities(master tables) within the system. These activities are captured in transaction tables and usually, these transaction entries have foreign keys to master records. Transaction tables are designed to store events in the system.

What is master table in SQL?

The tables that hold the records containing general information about the participants or objects of transactions within a module. In General Ledger the master table contains the account names, numbers, and balances.

What is the difference between master data and transaction data?

Master and transactional data Transactional data relates to the transactions of the organization and includes data that is captured, for example, when a product is sold or purchased. Master data is referred to in different transactions, and examples are customer, product, or supplier data.

What called master table?

Sqlite Master listing of all database objects in the database and the SQL used to create each object.