CREATE TABLE Session ( SessID INTEGER PRIMARY KEY AUTOINCREMENT, DoneDate TEXT, Topic TEXT ) CREATE TABLE Person ( PersId INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT ) CREATE TABLE Role ( RoleId INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT ) CREATE TABLE PersonRoles ( PersID INTEGER, RoleID INTEGER, PRIMARY KEY(PersID, RoleID) ) CREATE TABLE PersonSessions ( SessID INTEGER, PersID INTEGER, PRIMARY KEY(SessID, PersID) )