I am finding impossible to draw ERD for below scenario.
I have two tables Table1 and Table2. Table1’s PK is composite key (combination of 3 columns) and my table2 referencing a column of table1 but not the entire PK
See structure below
Table1: (with composite key)
T1Col1 – part of pk
T1Col2 – part of pk
T1Col3 – part of pk
T1Col4
.
.
.
Table 2: (referencing Col1 in the Table1)
T2Col1 – part of pk
T1Col1 – foreign key
.
.
.
I just want to show a link between two tables that T1Col1 in table2 is referencing ‘a’ column of table1
Any one please help. Is it doable without creating intermediate table?