2 Replies Latest reply: Mar 28, 2011 9:38 AM by Vaibhav Sathe RSS

    Need help to avoid creating duplicate tables

    Vaibhav Sathe

      I am a new developer and looking for options.

      Here is my scenario

      1. We have transaction table and each transaction is owned by user. each transaction can have multiple activities and activities owners could be same as Transaction owner or different.

      Here is some data

      User table

       

      useriduname
      1test1
      2test2
      3test3
      4test4
      5test5


      Transaction data

       

      TranIdTranOwnerId = userid
      Tr11
      Tr23
      Tr34


      Activity data

       

      ActidTranIdActuserId = userid
      Act1Tr11
      Act2Tr12
      Act3Tr13
      Act4Tr22
      Act5Tr23
      Act6Tr24
      Act7Tr33
      Act8Tr34
      Act9Tr35


      I can create transactionuser table as well as activityuser table. but we have many more such scenarios and I will end up creating 5-6 user tables.

      Is there any way..

      Thanks

      Vaibhav