Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • No Format
    CREATE SEQUENCE ENTITY_PROP_ID_SEQ
      START WITH 1
      MAXVALUE 999999999999999999999999999
      MINVALUE 1
      NOCYCLE
      CACHE 20
      NOORDER;
    
    ...
  • No Format
    
    -- warehouse module
    CREATE TABLE DW_ASSIGNMENT_STATUS
    (
      USER_ID             VARCHAR2(99 BYTE)         NOT NULL,
      ASSIGNMENT_ID       VARCHAR2(99 BYTE)         NOT NULL,
      COURSE_TITLE        VARCHAR2(256 BYTE),
      ASSIGNMENT_TITLE    VARCHAR2(256 BYTE),
      ASSIGNMENT_STATUS   VARCHAR2(64 BYTE),
      ASSIGNMENT_GRADE    VARCHAR2(64 BYTE),
      STUDENT_FIRST_NAME  VARCHAR2(128 BYTE),
      STUDENT_LAST_NAME   VARCHAR2(128 BYTE),
      SCHOOL              VARCHAR2(128 BYTE),
      DISTRICT            VARCHAR2(128 BYTE),
      CLASS_YEAR          VARCHAR2(128 BYTE),
      ADVISOR             VARCHAR2(128 BYTE),
      COURSE_TERM         VARCHAR2(128 BYTE),
      COURSE_CODE         VARCHAR2(128 BYTE),
      COURSE_SECTION      VARCHAR2(128 BYTE),
      COURSE_START_DATE   VARCHAR2(128 BYTE),
      INSTRUCTOR          VARCHAR2(128 BYTE)
    )