Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Database
    • Labels:
    • Rice Module:
      KEW
    • Application Requirement:
      KFS, KC, KS, Rice

      Description

      The DDL for KEW currently has no RI constraints. We need to analyze the tables in KEW and determine what RI constraints need to be created. We also need to identify any problematic areas.

        Attachments

          Activity

          Hide
          ewestfal Eric Westfall added a comment -

          Here is an ERD diagram showing the relationships between the tables.

          https://test.kuali.org/confluence/display/KEW/Diagrams

          Show
          ewestfal Eric Westfall added a comment - Here is an ERD diagram showing the relationships between the tables. https://test.kuali.org/confluence/display/KEW/Diagrams
          Hide
          agodert Aaron Godert (Inactive) added a comment -

          Eric, is this still the case, that the RI constraints are not in place for KEW?

          Show
          agodert Aaron Godert (Inactive) added a comment - Eric, is this still the case, that the RI constraints are not in place for KEW?
          Hide
          agodert Aaron Godert (Inactive) added a comment -

          Looks like it... I'm seeing only three files in the constraints directory. Is this something that Andrew is still planning on working on?

          Show
          agodert Aaron Godert (Inactive) added a comment - Looks like it... I'm seeing only three files in the constraints directory. Is this something that Andrew is still planning on working on?
          Hide
          ewestfal Eric Westfall added a comment -

          Yes, we've only been creating constraints for the newest tables (those 3 that you're seeing). I don't think that Andrew's going to be working on this. Go ahead and un-assign from him for now.

          Show
          ewestfal Eric Westfall added a comment - Yes, we've only been creating constraints for the newest tables (those 3 that you're seeing). I don't think that Andrew's going to be working on this. Go ahead and un-assign from him for now.
          Hide
          jcoltrin Jessica Coltrin (Inactive) added a comment -

          still needed per today's review.

          Show
          jcoltrin Jessica Coltrin (Inactive) added a comment - still needed per today's review.

            People

            • Assignee:
              Unassigned
              Reporter:
              ewestfal Eric Westfall
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: