Create your schema
Create your schema
No restriction on how many tables/relationships you can have.
All you need to do is model your business requirement in the 'Current View'.
Automatically generate all the code required based on your 'current view' design with one simple command.
100% code generation is the key step which insulates the developer from complexity caused by dates. All the code required to police primary, unique and foreign keys is generated. The code ensures consistency and referential integrity when data is inserted, updated and deleted and when the existence of a row is altered by updating the start of existence (soe) and/or end of existence (eoe). It also ensures that rows referenced by foreign keys e.g. emp.deptno exist for the duration of that row.
Primary Keys, Unique Keys and Foreign Keys are fully supported across time.
You can define restrict, cascade, nullify and default rules on each Foreign Key. Foreign keys can also be optional and transferable.
No need for any Date columns, History or Audit tables - they are generated for you.
A completely new world of productivity and simplicity!