CREATE TABLE hwr_team (
    TEAM_ID               NUMBER(19, 0)     NOT NULL,
    TEAM_NAME             VARCHAR2(1020)    NOT NULL,
    DESCRIPTION           VARCHAR2(4000),
    EFFECTIVE_DATE        TIMESTAMP(6)      NOT NULL,
    SOURCE_APPLICATION    VARCHAR2(1020)    NOT NULL,
    STATUS                VARCHAR2(80)      NOT NULL,
    IS_PRIVATE            NUMBER        ,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    SOURCE_ID             NUMBER(18, 0) ,
    CONVERSATION_ID       VARCHAR2(400) ,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    BUSINESS_GROUP_ID     NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    TEAM_ID               NUMBER(19, 0)     NOT NULL,
    TEAM_NAME             VARCHAR2(1020)    NOT NULL,
    DESCRIPTION           VARCHAR2(4000),
    EFFECTIVE_DATE        TIMESTAMP(6)      NOT NULL,
    SOURCE_APPLICATION    VARCHAR2(1020)    NOT NULL,
    STATUS                VARCHAR2(80)      NOT NULL,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    BUSINESS_GROUP_ID     NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    IS_PRIVATE            NUMBER        ,
    SOURCE_ID             NUMBER(18, 0) ,
    CONVERSATION_ID       VARCHAR2(400) 
);
