CREATE TABLE member ( id INTEGER PRIMARY KEY, user_id INTEGER REFERENCES user(id) ); CREATE TABLE user ( id INTEGER PRIMARY KEY, username TEXT );