CREATE TABLE msc_allocations (
    ALLOCATION_ID              NUMBER(18, 0),
    WEEKLY_ALLOC_QTY           NUMBER       ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    TIME_PHASE_ID              NUMBER(18, 0)    NOT NULL,
    ALLOCATION_PERCENT         NUMBER       ,
    PRIORITY                   NUMBER       ,
    DEMAND_CLASS               VARCHAR2(120)    NOT NULL,
    SERVICE_LEVEL              NUMBER       ,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    ATTRIBUTE_CATEGORY         VARCHAR2(120),
    ATTRIBUTE1                 VARCHAR2(600),
    ATTRIBUTE2                 VARCHAR2(600),
    ATTRIBUTE3                 VARCHAR2(600),
    ATTRIBUTE4                 VARCHAR2(600),
    ATTRIBUTE5                 VARCHAR2(600),
    ATTRIBUTE6                 VARCHAR2(600),
    ATTRIBUTE7                 VARCHAR2(600),
    ATTRIBUTE8                 VARCHAR2(600),
    ATTRIBUTE9                 VARCHAR2(600),
    ATTRIBUTE10                VARCHAR2(600),
    ATTRIBUTE11                VARCHAR2(600),
    ATTRIBUTE12                VARCHAR2(600),
    ATTRIBUTE13                VARCHAR2(600),
    ATTRIBUTE14                VARCHAR2(600),
    ATTRIBUTE15                VARCHAR2(600),
    CLASS                      VARCHAR2(120),
    PARTNER_ID                 NUMBER(18, 0),
    PARTNER_SITE_ID            NUMBER(18, 0),
    LEVEL_ID                   NUMBER(18, 0),
    LEVEL_ALLOC_PERCENT        NUMBER       ,
    LEVEL_PRIORITY             NUMBER       ,
    MIN_ALLOCATION_PERCENT     NUMBER       ,
    MIN_LEVEL_ALLOC_PERCENT    NUMBER       ,
    REFRESH_NUMBER             NUMBER(18, 0),
    ALLOCATION_ID              NUMBER(18, 0),
    WEEKLY_ALLOC_QTY           NUMBER       ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    TIME_PHASE_ID              NUMBER(18, 0)    NOT NULL,
    ALLOCATION_PERCENT         NUMBER       ,
    PRIORITY                   NUMBER       ,
    DEMAND_CLASS               VARCHAR2(120)    NOT NULL,
    SERVICE_LEVEL              NUMBER       ,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    ATTRIBUTE_CATEGORY         VARCHAR2(120),
    ATTRIBUTE1                 VARCHAR2(600),
    ATTRIBUTE2                 VARCHAR2(600),
    ATTRIBUTE3                 VARCHAR2(600),
    ATTRIBUTE4                 VARCHAR2(600),
    ATTRIBUTE5                 VARCHAR2(600),
    ATTRIBUTE6                 VARCHAR2(600),
    ATTRIBUTE7                 VARCHAR2(600),
    ATTRIBUTE8                 VARCHAR2(600),
    ATTRIBUTE9                 VARCHAR2(600),
    ATTRIBUTE10                VARCHAR2(600),
    ATTRIBUTE11                VARCHAR2(600),
    ATTRIBUTE12                VARCHAR2(600),
    ATTRIBUTE13                VARCHAR2(600),
    ATTRIBUTE14                VARCHAR2(600),
    ATTRIBUTE15                VARCHAR2(600),
    CLASS                      VARCHAR2(120),
    PARTNER_ID                 NUMBER(18, 0),
    PARTNER_SITE_ID            NUMBER(18, 0),
    LEVEL_ID                   NUMBER(18, 0),
    LEVEL_ALLOC_PERCENT        NUMBER       ,
    LEVEL_PRIORITY             NUMBER       ,
    MIN_ALLOCATION_PERCENT     NUMBER       ,
    MIN_LEVEL_ALLOC_PERCENT    NUMBER       ,
    REFRESH_NUMBER             NUMBER(18, 0),
    CONSTRAINT pk_msc_allocations PRIMARY KEY (ALLOCATION_ID, ALLOCATION_ID)
);
