Forms approach DB mappings

 SELECT * FROM lportal.ddmforminstance;  // Forminstanceid and xml with form name    

SELECT * FROM lportal.ddmforminstancerecordversion;  //Forminstanceid, forminstancerecordid  (this.forminstancerecordversionId == kaleoinstance.classPK)   

SELECT * FROM lportal.kaleoinstance; // json with approve and content  (createDate is SUBMITTED date , completionDate is APPROVED date )  

SELECT * FROM lportal.ddmstructureversion; //Has the label key etc   

  

SELECT * FROM lportal.ddmstructure;  // ddmstructure.StructureId = ddmforminstance.StructureId 

 

1) ON CREATE 

 

Entry in  SELECT * FROM lportal.ddmforminstance;  

 

2) ON SUBMIT 

 

SELECT * FROM lportal.ddmforminstancerecordversion;  

 

SELECT * FROM lportal.kaleoinstance;  

com.liferay.dynamic.data.mapping.model.DDMFormInstanceRecord 

 

"userId":"37154", 

      "transitionName":nothing 

 

And  

"formInstanceId":"39905", 

 

 

3) On APPROVING 

 

SELECT * FROM lportal.kaleoinstance;  

 

"userId":"39460", 

      "transitionName":"approve" 

 

And  

"formInstanceId":"39905", 

 

 

 

 

3) On REJECTING 

 

SELECT * FROM lportal.kaleoinstance;  

 

 

"userId":"39460", 

      "transitionName":"reject"