sun

• Aug 29th, 2005

 

Extension table may be 1:1 realation table to the base table or a 1:M relation to the base table. 
 
1:1 extension table and the base table are logically considered as a single table. 
 
Par_row_id will be the foriegn key. 
 

Kamal

• Nov 2nd, 2005

 

Extension tables are 1:1 or 1:M extensions of Base tables, like S_PARTY (base) has S_CONTACT etc. For  a 1:1 extension there is implict join but for a 1:M extension. You can only extend a base table. For 1:1 there is a PAR_ROW_ID to ROW_ID join and for a 1:M there is 3 different columns that represents a unique record.