[jbpm-dev] [Design of JBoss jBPM] - Re: Schema for the current BI implementation?

[tom.baeyens@jboss.com]

create table JBPM_LOG (
  |   ID_ bigint generated by default as identity (start with 1), 
  |   CLASS_ char(1) not null, 
  |   INDEX_ integer, 
  |   DATE_ timestamp, 
  |   TOKEN_ bigint, 
  |   PARENT_ bigint, 
  |   MESSAGE_ varchar(4000), 
  |   EXCEPTION_ varchar(4000), 
  |   ACTION_ bigint, 
  |   NODE_ bigint, 
  |   ENTER_ timestamp, 
  |   LEAVE_ timestamp, 
  |   DURATION_ bigint, 
  |   NEWLONGVALUE_ bigint, 
  |   TRANSITION_ bigint, 
  |   CHILD_ bigint, 
  |   SOURCENODE_ bigint, 
  |   DESTINATIONNODE_ bigint, 
  |   VARIABLEINSTANCE_ bigint, 
  |   OLDBYTEARRAY_ bigint, 
  |   NEWBYTEARRAY_ bigint, 
  |   OLDDATEVALUE_ timestamp, 
  |   NEWDATEVALUE_ timestamp, 
  |   OLDDOUBLEVALUE_ double, 
  |   NEWDOUBLEVALUE_ double, 
  |   OLDLONGIDCLASS_ varchar(255), 
  |   OLDLONGIDVALUE_ bigint, 
  |   NEWLONGIDCLASS_ varchar(255), 
  |   NEWLONGIDVALUE_ bigint, 
  |   OLDSTRINGIDCLASS_ varchar(255), 
  |   OLDSTRINGIDVALUE_ varchar(255), 
  |   NEWSTRINGIDCLASS_ varchar(255), 
  |   NEWSTRINGIDVALUE_ varchar(255), 
  |   OLDLONGVALUE_ bigint, 
  |   OLDSTRINGVALUE_ varchar(4000), 
  |   NEWSTRINGVALUE_ varchar(4000), 
  |   TASKINSTANCE_ bigint, 
  |   TASKACTORID_ varchar(255), 
  |   TASKOLDACTORID_ varchar(255), 
  |   SWIMLANEINSTANCE_ bigint, 
  |   primary key (ID_)
  | )
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4165814#4165814

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4165814