Uploaded image for project: 'TCIA RESTful API'
  1. TCIA RESTful API
  2. TRA-42 Create Shared Lists via API
  3. TRA-71

AutoIncrement Primary Key of "Custom_Series_List"

XMLWordPrintable

    • Icon: Technical task Technical task
    • Resolution: Won't Fix
    • Icon: Major Major
    • 2014-15 Q1
    • None
    • None
    • None
    • 20141009-201410015

      The table that stores shared list metadata is called “CUSTOM_SERIES_LIST”. This table stores the data about the shared list, except the SeriesInstanceUIDs, which are stored in custom_series_list_attribute.

      The table CUSTOM_SERIES_LIST contains the Name, Comment, URL, Username, Date and CUSTOM_SERIES_LIST_PK_ID (<— Primary Key)

      The create shared list API expects a CSV that contains “Name”, “Comment”, “URL”, and “Username”.

      The issue is that the PK column does not auto-increment.

      Could we set it to auto increment?
      i.e.
      alter table NCIA.CUSTOM_SERIES_LIST modify column CUSTOM_SERIES_LIST_PK_ID bigint(20) auto_increment

            ashish Ashish Sharma
            ashish Ashish Sharma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: