Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-304

Database: Remove primary key & add index to PM_USER_LOGIN

    XMLWordPrintable

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Done
    • None
    • 1.7.10
    • None
    • Rank:
      0|i003y7:

    Description

      The PM_USER_LOGIN table should not have a primary key. The existing primary key is on the user_id and will be removed. An index will be added to the table. This index will be

      PM_USER_LOGIN_IDX ON PM_USER_LOGIN(USER_ID, ENTRY_DATE)

      Attachments

        Activity

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: