Home

 Product

 Documentation

 Download
     
    
          
 
 
 
  Installation
  Rule
  ERD Generator
  Form Generator
  Form Type Generator
  Form Field Generator

HOT NEWS

Hot News



63069 visitor

 
ERD (Entity Relation Data)
Simple Junior Generator - X
+ HOW TO CREATE TABLES WITH RELATION
Two table have relation with condition first table [Master Table] have one field for set Unique and second table [Detail Table] have one field for set Index, For example:


This is first table [Master Table], table name "tbl_example". tbl_example have Unique key is name field "fieldex1".



This is second table [Detail Table], table name "tbl_detail_example". tbl_detail_example have Index key is name field "fieldex1".

Tips: For auto generate ERD Field Name Key Master and Field Name Key Detail must same. If not same ERD must manual create.
+ HOW TO AUTO GENERATE ERD
Simple Junior Generator - X interface menu. You can click "ERD" button in top corner. For example:
+ HOW TO UPDATE AUTO GENERATE ERD
Simple Junior Generator - X interface menu. You can click "ERD" button in top corner and click "GENERATE SCHEMA" button.

+ HOW TO DELETE RELATIONAL
 Click "ERD" button in top corner and next step click ARROW OBJECT until change color be blue. For example:

Next step press "DELETE" / "DEL"  button from your keyboard.
+ HOW TO CREATE RELATIONAL MANUALLY
 Click "ERD" button in top corner and next step click Key Index   from Detail Table  until change icon to then click Key Unique from Master Table.
 
 
     
   Junior Software © 2002 - 2008