XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      +-- SAM-2970 Extended Time
      +
      +CREATE TABLE SAM_EXTENDEDTIME_T (
      + ID bigint(20) NOT NULL,
      + ASSESSMENT_ID bigint(20) DEFAULT NULL,
      + PUB_ASSESSMENT_ID bigint(20) DEFAULT NULL,
      + USER_ID varchar(255) DEFAULT NULL,
      + GROUP_ID varchar(255) DEFAULT NULL,
      + START_DATE datetime(6) DEFAULT NULL,
      + DUE_DATE datetime(6) DEFAULT NULL,
      + RETRACT_DATE datetime(6) DEFAULT NULL,
      + TIME_HOURS int(11) DEFAULT NULL,
      + TIME_MINUTES int(11) DEFAULT NULL,
      + PRIMARY KEY (ID),
      + KEY (ASSESSMENT_ID),
      + KEY (PUB_ASSESSMENT_ID),
      + CONSTRAINT FOREIGN KEY (PUB_ASSESSMENT_ID) REFERENCES SAM_PUBLISHEDASSESSMENT_T (ID),
      + CONSTRAINT FOREIGN KEY (ASSESSMENT_ID) REFERENCES SAM_ASSESSMENTBASE_T (ID)
      +);
      +

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ottenhoff Sam Ottenhoff
                Reporter:
                ottenhoff Sam Ottenhoff
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code