Database Design using SQL

Database design is the key for successful software and this is a very strict thing you need to consider when using OneLine Framework and OneLine Tool.

Every database design and entity should have his primary keys, foreign keys, constraints if any, descriptive entity name and descriptive column names (Take note that: composite key entities are not supported and should not be used) with the conventions mentioned here From Database Context.

Is very important to follow the conventions on the link cause this process will help you also translate correctly all labels and texts in the OneLine Tool for you.

If you write wrong, acronym or shorten words for table or column names this will lead to unexpected translations behavior.