CREATE TABLE Addresses ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE Groups ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL ); CREATE TABLE Group_Members ( grp_id INTEGER REFERENCES Groups(id), adr_id INTEGER REFERENCES Addresses(id) );