gistfile1.txt

MANY-TO-MANY

create table Left (
    Id  integer
    Name TEXT
)

create table LeftRights (
   LeftId INTEGER not null,
   Key TEXT not null,
   RightId INTEGER not null,
)

create table Right (
    Id  integer
    Name TEXT
)


ONE-TO-MANY

create table Left (
    Id  integer,
    Name TEXT
)

create table Right (
    Id  integer,
    Name TEXT,
    Key TEXT,
    LeftId INTEGER,
)