Use tiny Valentina DB Abstraction Links. 1:1, M:1 or M:M relations - without building tables. Foreign keys optional.
Valentina Binary Links
Valentina DB goes beyond the constraints of traditional relational databases by providing you with more options: traditional foreign keys, object points and high performance binary links. These are all accessible via standard SQL or through the native Valentina DB API.
Binary Links in Valentina SQL
CREATE BINARY LINK link_Phone_Person ON (Person, Phone) AS MANY TO MANY;
- Foreign Keys
- Valentina DB supports industry standard foreign keys, making it easy to port existing SQL databases to Valentina.
- Object Pointers
- Valentina DB provides an advance on foreign keys that results in less information needed when working with 1:1 and M:1 relations.