DFGEN Framework is simple structure and relationship between tables. It’s just give a proper name and proper data type, so you will easy to understand including a very big databases. Our mind just remember this concept and all will be in hand and in mind.
- DFGEN framework is base on mysql 5 naming rule, were you can use space in your name of field, database or tables. Just like this `tuition this day`.
- For DFGEN naming rule, for case of letters, i prefered to use non capital letter for all of database structure name. Use capital for MySQL Keywords when you make a query. This will simplicize your mind.
- The DFGEN relationship concept is concept for a database. So, you have to built the relationship between tables that member of current database.
- We use ‘id’ field as main identification of records. ‘id’ is an autoincremen integer type. An other tables in current database will refer to this tables with fieldname same as the refered table. This field is integer type. Example:Â ‘tuition’ tables will be refered as ‘tuition’ field in other tables. it use exact match.
- A tables refered by other tables have 1 or more string or varchar field type. At first edition of HTML Form Generator and HTML Form Handler, it will choose the first of varchar type as options to user when the user entries data. When you use a desktop version ( Delphi ), you can configure the prefred name used for options. YOu hmust remember that this field have to unique content. Duplicate content will confusing the user when they choose a record.
Good day,
Putu Swastawa
