0 Replies Latest reply on Mar 9, 2015 1:07 PM by User13396737-Oracle

    Additional Detail Table Design Doubt

    User13396737-Oracle

      Hi,

       

        We have introduced a new table which will have some other's table primary key as a key attribute. Please go through the below sample case and suggest the standard approach.

       

        For Ex:-

       

          Existing Table:  Customer table CUSTOMER with columns CUST_ID, CUST_NAME, CUST_ADDR

          New Table     :  Premium Customer table PREMIUM_CUSTOMER with columns CUST_ID, PREMIUM_START_DATE, PREMIUM_END_DATE

         

          In the above example, table PREMIUM_CUSTOMER will not be having a row for each customer (of table CUSTOMER) and also will not be having multiple rows for a given CUST_ID. So here in this case, do we need any new column to be introduced in table PREMIUM_CUSTOMER as a primary key or CUST_ID as a primary key is allowed and suffice as per EBS standards.

         

      Thanks,

      Praveen Kumar Ch