CREATE TABLE bm_package (
    ID                  NUMBER(18, 0) ,
    NAME                VARCHAR2(1020)    NOT NULL,
    DESCRIPTION         VARCHAR2(4000),
    VERSION_NUMBER      NUMBER(7, 0)      NOT NULL,
    DATE_RELEASE        DATE          ,
    DATE_ADDED          DATE              NOT NULL,
    DATE_MODIFIED       DATE          ,
    IDENTIFIER          VARCHAR2(1020),
    USER_ADDED_ID       NUMBER(18, 0)     NOT NULL,
    USER_MODIFIED_ID    NUMBER(18, 0)     NOT NULL,
    SOURCE_SITE_URL     VARCHAR2(1020),
    IMPORT_FLAG         VARCHAR2(4)   ,
    ID                  NUMBER(18, 0) ,
    NAME                VARCHAR2(1020)    NOT NULL,
    DESCRIPTION         VARCHAR2(4000),
    VERSION_NUMBER      NUMBER(7, 0)      NOT NULL,
    DATE_RELEASE        DATE          ,
    DATE_ADDED          DATE              NOT NULL,
    DATE_MODIFIED       DATE          ,
    IDENTIFIER          VARCHAR2(1020),
    USER_ADDED_ID       NUMBER(18, 0)     NOT NULL,
    USER_MODIFIED_ID    NUMBER(18, 0)     NOT NULL,
    SOURCE_SITE_URL     VARCHAR2(1020),
    IMPORT_FLAG         VARCHAR2(4)   ,
    CONSTRAINT pk_bm_package PRIMARY KEY (ID, ID)
);
