AlgebraicJulia / AlgebraicRelations.jl

Relational Algebra, now with more algebra!
https://www.algebraicjulia.org
MIT License
48 stars 3 forks source link

How to create multi-column schema? #36

Open jmatsushita opened 1 year ago

jmatsushita commented 1 year ago

The concise example shows how to create a schema of the type:

CREATE TABLE get_manager (Person1 int, Person2 int);
CREATE TABLE get_name (Person1 int, Name2 text);
CREATE TABLE get_employees (Person1 int, ID2 int);
CREATE TABLE get_salary (Person1 int, Salary2 real);

How would you create a schema such as:

CREATE TABLE employees (Person1 int, ID2 int, Manager3 int, Name4 text, Salary5 real);