Multi Association is kind of association in database between 2 tables, generally this is theoretically term.
multi- association reference generally handle by below table, this is also called linking table. It has same synonyms like
cross-reference table,
bridge table,
join table,
map table,
intersection table,
linking table,
link table
Structure Explanation, ( There is 2 table, Customer is one table, Address is second table), I need to create link table where i can store ID of both tables. I will create a table Custom_address whose structure like as below.
Customer_ID column has reference to Customer table, and Address_id column has reference to Address table
Note*- Its also depends upon the database designer, some time user create ID column in link table sometimes not.
multi- association reference generally handle by below table, this is also called linking table. It has same synonyms like
cross-reference table,
bridge table,
join table,
map table,
intersection table,
linking table,
link table
Structure Explanation, ( There is 2 table, Customer is one table, Address is second table), I need to create link table where i can store ID of both tables. I will create a table Custom_address whose structure like as below.
Customer | |||
ID | First Name | Last Name | Middle Name |
1 | Kind | Singh | s. |
2 | Nice | Singh |
Address | ||
ID | State | Country |
1 | Punjab | India |
2 | Goa | India |
3 | New York | United State |
Customer_ID column has reference to Customer table, and Address_id column has reference to Address table
Customer Id | Address Id |
1 | 1 |
1 | 3 |
2 | 1 |
2 | 2 |
Note*- Its also depends upon the database designer, some time user create ID column in link table sometimes not.
No comments:
Post a Comment